From what Oracle told us, it would cost about 100,000$ to setup a standby
database (Enterprise Edition) on a 4 CPU box.
Considering this would be at a remote site, and the machine would only ever
be used in case of disaster recovery (that is, no connected users ever

I am new to Oracle and wonder if anyone can enlighten me. I am looking
for the syntax for parameter equivalent to @ in SQL, for example, in
"SELECT * FROM EMPLOYEES WHERE EmpID = @EmpID".
Thank you in advance,

We are implementing RMAN.  I've run into a few test cases where I
received the following error:
RMAN-06089: archived log
/u01/app/oracle/admin/mpcpilot/arch/arch_1_145202.arc not found or out

I have installed the same Oracle version (10.x) on a Windows 2003
Server and on a Linux RHAS 3. I have created the same database and run
some querys. The hardware and the data are the same and in Linux I have
set the recommended kernel parameters. The W2K3 filesystem is NTFS, and

Is there a PRODUCT() OVER() equivalent to SUM() OVER() analytical
function which can help me with the query output below?
In Oracle 9.2.x, given the following source data, how could I get the
output shown, using SQL (no plsql).

I am using 9r2 on Windows.
I'd like to setup parallel query. What I am going to do is to set
PARALLEL_AUTOMATIC_TUNING = TRUE. All my tables are creted with
NOPARALLEL clause. Could I still use /*+ PARALLEL */ hint to run

I need Oracle 8i but i don't find it...Where can I Find?

I tried this and it did not work
SQL> var dirName varchar2(50);
SQL> exec :dirName := 'newdir'
PL/SQL procedure successfully completed.

I have two columns representing start_datetime and end_datetime. They
look like 1085008980 and 1085009504 respectively. They are stored in
UTC format (number of seconds from '15/12/1970').
How do I calculate difference in hours:minutes:seconds?

I use Oracle 9i and would like to mix two different databases into one.
These two databases have different tables and views. Each name of a
table or view is unique and does not exist in the other database.
Now I would like to bring them all together into a new database so that

Greetings All, I am not sure if this is the location for this issue but
I will ask anyhow.  In short I have a C# program that calls a package,
the package takes one argument and that argument is defined in the
package as a clob.  I am using the OleDb provider for Oracle MSDAORA to

I have an associative array full of primary keys from a table.  I need to
populate two other arrays with other column data from the same table.  Is
there a bulk collect syntax I can use that uses my existing array of keys?
I have it working using the following:

I am writing some procedures wich refer to non-existing tables yet..
so, when I try to compile, it gives me : "PLS-00201: identifier
'your_table' must be declared"
How could I prevent this without creating those tables to not stop

I have an Oracle Server Enterprise Edition with 8174 DB on HPUx 11.11. It
was installed with OHS (Oracle HTTP Server) but we have never used this
component. According to Oracle Critical Patch Update APR 2005, I have
applied Security Alerts 45, 51, 62 but am stuck while applying ...

how do I set the processname of a unix oci program (Oracle 8 and 9) in
v$session.program?
I checked the DBMS_APPLICATION_INFO package, but it appears not to be
appropriate to set the column v$session.program.