Hi, all.
I have a database server which has a failover server.
There is suspicion that the failover server may have been omitted in a
couple of instances when we applied patches to the production server.

I need to recover a datafile found on c:\oracle...drive that pends on
startup. the file was deleted accidently and needs to be recovered
using the syntax below; I was told to find out the original file number
by using the select file# from v$datafile  ? how can I tell which is

I'd like to return all rows in my table, but the 3rd column must only
contain the "VALUE" (OIDP_VALUE) when "(LOWER(TBL5.OIDP_DOMAIN) =
LOWER('JACK'))".
If I run the query below as is, I ONLY get data where the above clause

I am a bit confused by exactly what constitute a Phantom Read.  Does it
include ONLY the case where ADDITIONAL rows have been added during 2
queries.  Then what about rows DELETED between 2 queries?  I have this
concern because many textbooks do define Phantom read as addition of ...

Can someone help me, please? -- I want to do the following steps, and
output strictly in SQL*Plus only:
-1- select count(*) from table1;
-2- select count(*) from table2;

I am trying to migrate a report generator written in Pro C  to Java.
But when i'm  precompiling the Pro*C code using the Oracle Pro*C tool
it spews out the following errors.
int CreWhereClause(char *szRunDate,...)

Given a table representing student's enrollment in classes:
create table student_enrollment (
   student_id number,
   enrollment_id number,

Server:- Sun Solaris 9.
Working:- Oracle Release 10.1.0.3.0.
Required:- Oracle Release 9.2.0.4.0
For reasons beyond my control (app):-

using oracle  9.2.0.3.0  running on unix starfire Sun OS 2.7
when doing a stored procedure we are getting the following errror when trying
to concatenate 2 variables  (variable sqlSqtmt)
               Undeclared Identifier ' sqlStmt'

from within a PL/SQL procedure, is it possible to call another
procedure whose name is passed in as an argument (IE not known until
run time).
For example:-

Hello...
I'm considering using TUSC
http://www.tusc.com/index.html
for consulting with a troublesome database. Has anyone here had experience with

I have got a very complicated view. There are a few thousand rows, an on
each row there are calculated fields. If i do a select * on that view,
it is about 2 Minutes until i get an answer. That is no problem so far.
I have got an INSTEAD OF INSERT-Trigger on that view. When i try ...

Hi SQL gurus!
I am getting the following error when I run my sql:
ORA-01799: a column may not be outer-joined to a subquery
The solution provided is to use views or remove the outer join. Since I

We have a large (3TB) Oracle 8.1.7 OLTP database running on a 14CPU
SunFire server (48GB RAM).  This drives a website with around 100 users
requests per second (transactional commits per second).  We use MTS to
manage web server connection requests.

I've made some attempts to find any information regarding this problem
with no success.
Oracle EE 9.2.0.1.0, Windows 2000:
dbms_stat.gather_schema_stats doesn't work for nested tables and their