Please, advise me in what system table should I look for existing
constraints
for some table.
Is exists some method to update check constraints or I should remove old

Hi'
Have anyone tried to use any of the conversion utilities on the market? -
would you like to share your experiences?
Rgds, Henrik

I heard of great Oracle books that are written by Don
Burleson. I wonder if any of you had similar experience?

Hi, all.
I'm working through learning RMAN under 8.1.7.4 (yes, I know) running
on AIX 5.2.0. I am not using a recovery catalog.
I'm making progress, but am at a bit of an impasse.  Here is what I am

Oracle 9i:
create table t(i integer)
Table created
insert into t values(1)

I have put an "after logon on trigger" on the database which is
restricing a user to logon using SQLPLUS tool. The trigger works fine
and is giving me the result I am expecting but it throws errors in the
alert log file. Below is the trigger which works fine and is

I am using Oracle 9.2 enterprice addition on Win2003.
I am looking a way to partition an existing (packaged application)
table with 3M rows. It has 24 indexes and 2 triggers on it as well.
Could you, please refer me to the doc or show me the way of doing it?

One of our database is using "shutdown abort", and then take a cold backup.
Users on metalink are strongly against it.
If we take a cold backup, everything we need to do a instance recovery is in
online redo logs.  If people can use "shutdown abort" and startup again

I'm experiencing an intermittent performance problem reading and
writing a 9i database from Sqlplus. I'm running Sqlplus on my laptop
and the DB is on a Sun box in the same office. It seems that if my
connection to the DB is inactive for a period of time, there is usually

I have a problem where I need to look for a parameter value in
v$parameter base on datbase version.I tried looking for conditional
compilation feature introduce in 10G R2 onwards but since it is not
available for prior versions I cannot leverage on that.Logic should

In oracle 9i, admin. guide in chapter 25 a caution is mentioned:
It is on the topic of Specifying Default Roles
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/privs.htm
"

I have a requirement to create two tables that have a one-to-(zero or
one) relationship.  That is, for every record in table A, there can be
zero or one record in table B.
I understand that I could put everything in one table, and then create

I have a simple problem ,  how can a compare part of the substring with
the set of values from a sub query.
here is the example, probem is at irem No: 3
1. The below SQL will  be OK

I am trying to install Oracle 10g on windows 2003 with Active
Directory. I can't get 10g to run on Windows 2003 Server Domain
Controller. I get error:
OS 1388 error

I wonder if there is a query for the following:
I have three tables
LOCATION (
LOCATION_NO )  -- there is location 1