I'm having problems finding out how I can use or execute the file that
is created from 'alter database backup control file to trace' command. I
have the file and I've looked at it, to be sure it's correct. What I don't
know and can't find the command(s) is how to execute this ...

I am in the process of choosing between RAW devices or QFS (Sun Cluster
3.1/Solaris 9) to support a busy online transactional Oracle RAC 10g
application (2 nodes).
I want to know of any QFS drawbacks or performance issues.  Again, this

we was connected to 9.2.0.5.0.
Database links was active and programs and queries was working fine, and in
one moment queries using database links freeze..
and after time ORA-12154: TNS:could not resolve service name appears.

In an Oracle 9i database I have two tables (say PARENT and CHILD ).
The CHILD table uses the field station_key for both it's Primary Key
(PK) and Foreign Key (FK) for the PARENT table .   I cannot change to
table structure.

  Dear Experts,
I have a problem with a simple stored procedure which is running under
the Oracle 9.2.0.4.0
64 bit environment. After 100 - 200 calls, this stored procedure

Hi, I'm doing direct load inserts of a table with 9.5Mio recs in
nologging mode.
I still get quite large archive logs: 4GB.
In the manual I only found the following:

I upgraded one of our site's databases from 8.1.7 to 10gR2 this week, &
all appeared to go well until I also upgraded the client PCs. The
application, which is written in USoft, works for a few minutes then
crashes out with the standard XP error screen - "USoft Developer has

How can I force PMON (Oracle 9i or 10i) to register with listener in
old style (COMMAND=service_register) instead of new style
(COMMAND=service_register_NSGR)?

Hi all experienced XML-programmers!
I need some help on defining a relational view named "XMLVIEW" for
transforming and denormalizing an XML-struture stored in a column
"SYS_NC_ROWINFO$" of type SYS.XMLTYPE in a table named "XMLTAB".

It sounded like such a simple little thing.  Create a table of people
where one of the attributes is date of birth (p_dob).  Requirements are
to place a constraint on the field such that data must fall between Jan
1, 1900 and today.  Easy, right?

We have admin client 8.1 installed  on win 2000 servers
We were trying to install same 8.1 admin client on Win 2003 server ,
installation start but does not progress (installation window closed 2
second after start)

Here's a quote from the Oracle reference guide, page 27:
"There are ways to find information from the database regardless of
whether the data is in uppercase or lowercase, but these methods impose
an unnecessary burden. With few exceptions, such as legal text or

What happen when during the 'create trigger ...' on a table, a DML
takes place on the table? Does the DML fail or does it wait for the
'create trigger' to complete before running?
Thanks

Is there are any way to prevent jobs from being imported under wrong
username (SYS) when schema exp/imp is being done (e.g. schema
movement?)
I suspect this has to do with user_id's not matching..

I want a solutions for a compicateds sql select statments.
The selects can use anything : views, stored procedures, analytic functions,
etc...
(not use materialized view, unless it is neccessary).