Firstly i would like to thank everyone for their help an
suggestions
However, i still could not fulfil my boss request. Here what i need t
do

I am fairly new the Oracle and SQL and I am trying to find out how can I
achieve the following: I have a program that uses a database (schema for
Oracle?) and I am creating NEW tables on an existing database. How can I
set the defaults for my tables regardless of what the ...

I am attempting to connect to a remote Oracle database using the 9i
client.   I can successfully ping the server on which the database
resides but TNSPING produces a tijmeout expired error.  The TNSNAMES
file contains the correct entries and I can connect to the database

I would like anyone to help me out in this UTL_FILE issue...
SQL> CREATE OR REPLACE PROCEDURE UTL_FILE_TEST_READ
 2  IS
 3     INPUT_FILE   UTL_FILE.FILE_TYPE;

We are currently trying to test our backup/restore/recover procedures
at work.  We are new to RMAN and I am new to Oracle.  On small
databases we have been able to use RMAN along with Veritas to backup to
tape and restore/recover a database.  We have now moved the same

I am having a problem with what I guess is a recursive SQL query.
The simplified version of the problem is I have a table that consists
of two columns of numbers, the record_id and the parent_record_id.
I would like to build a string that consists of the full chain of

Would be interested to know what the DBAs out there do when things are
slack, i.e. everything's running fine.
Serious answers please!

Have a DB that I use for testing (so not really important if I can
recover data in future), but I reallly need it working again.
I still have REDO03.LOG, but lost 01 and 02 forever.
Can I regenerate 01 and 02 somehow?

Dear Oracle Masters,
I have deleted a file through unix (BOBBY_TBSP.dbf ) because it was
corrupted and now my oracle instance does not start up, using my
username and password:

Red Hat says that we should use Red Hat Advanced Server for databases
but both RH Enerprise edition and Advanced server are supported by
Oracle. I am not sure which one we should be going with.
The support charges for RH AS is over $2000 per year whereas for

I am trying to force a query to run using the Rule Based Optimizer
(RBO). The query is fairly complex so I've included the <*+ RULE *>
hint in every SELECT statement contained in it.  The query contains a
UNION ALL.  When I run it, the execution plan suggests that it's using

I'm building a query where I need to retrieve just 1 one row,
which must be that with the highest Date (I mean that which
is closest to the moment where the query is issued)
SELECT a.lista_campi_tpr, date_import

we have 9.1.2 on Unix StarFire Sun server.
we have a column load_Date  with DATE format.  it is part of primary key
when we do a query on 04/02/05 when we changed to daylight savings time we get
the following

I read on (S)Pfiles in a book, but I think I didnt get this topic.
Some databases seem to have a text pfile including the parameters
and some only have a binary spfile.
(1) What is the main difference between a "normal" init file and a sp-initfile?

I'm in the process of planing an Database-Upgrade from 10gR1 to 10gR2.
Operation Sytem is Windows 2003 Server SP1 fully patched. While reading
through the "Oracle Database Upgrade Guide" I came over the point where
it is stated to run the Oracle Net Configuration Assistant. I'm ...