All,
Is it recommended to set the COMPATIBLE initialization parameter always to
the installed patch version ? After upgrading an Oracle 9i db to version
9.2.0.6.0, I noticed that it's still set to 9.2.0.0.0, couldn't this lead to

I have some tables that store hierarchical data, just wondering what is
a good way to enforce integrity on the database side.
The problem, deleting a node with children will result in the orphaning
of those nodes.  It's easy enough to do client-side but what I'd like to

Seeking a Salary or W2 hourly contractor (no copr-to-copr or H1B's)
Work under the directions of two senior DBA's in supporting database
for applications.
Task may include:

I have a 8i databases on HPUX 11.0, can these databases be managed from
OEM 10g. I tried to install the client agent on the server but it
errors out because HPUX 11.0 is not supported from the 10g agent
install.

I want to produce a report.  Here's a sample table I want to report on:
server_name severity log_only notification_only
------------  -------- --------  ----------------
serverA        critical    0           0

Can anyone tell me what the following unique constraint means:
ADRI I$PK_VOLUME_HEADER ADRI VOLUME_HEADER VOLUME_ID 1 22 0 ASC
ADRI I$PK_VOLUME_HEADER ADRI VOLUME_HEADER CIB_VOLUME_ID 2 10 10 ASC
ADRI I$PK_VOLUME_HEADER ADRI VOLUME_HEADER VOLUME_EDITION 3 22 0 ASC

I have an Oracle 9 table with a field performed_date.
Select * from my_table
where performed_date > (sysdate - 8);
This will return all records with performed_date within last week.

Can anyone tell me...
I want to install RAC oracle 10g...
1st node is 32bit windows, and 2nd node 64bit windows...
is it possible to install RAC... does the RAC support different platforms???

I am working on a project in image processing. I have like 600 to 700
images in my database and I need to Quantize all the images that are
present in the database.
A signature for the image abstraction is generated as follows. Each

Hi *,
I applied the 9.2.0.6 patch to one of our database servers, running
9.2.0.4.
The installation completed without any errors (i used a response file

My new job requires me to tune lots of SQL which run for long time.
I'm not keen in this area and would like to get some idea how to start.
I read some books on EXPLAIN_PLAN, TKPROF, etc.  but those are
not easy to understand for me (I'm new to Oracle !).  Although I

Hi, we are doing a database migration from Oracle v8.1 running on
SOLARIS to DB2 v7.0 running on AIX.
 Because the data is in the order of tera bytes, the whole migration
effort is likely to take about 10 days. The customer cannot shut down

I would likre to write in PL/SQL small tool for
dba-s,that will note from "V$SESSION" for any,
login username and other datas into a table,
something like "last" on UNIX, but I don't know

Ok,
I want to hear some horror stories about using the TIMED_STATISTICS
parameter in 8.1.5 (unpatched).
I've found some interesting nightmares on the web, but I want to get

One of my client lost his sys/system password.  After I sudo to oracle user,
re-generated password file with "Orapwd file =xxx password=test123",, I try
to use "sqlplus /nolog", "connect sys as sysdba", oracle asked for my
password, after I typed test123, it retured error ...