Hi, all.
I'm on 8.1.7.4 on AIX 5.2.0.2.
I'm configuring a standby database, on the same node as the primary, in
a different directory structure. I want it to be managed, not manual.

I am new to Oracle Lite, I read this docs :
http://www.oracle.com/technology/products/lite/TWP_Lite_10gR2.pdf

1) Is it correct that to run Oracle Lite on offline mobile apps, I must

I have an Oracle text search that searches CLOBs, and is now failing --
hypothesis is that the CLOBs over 200 MB are causing it to fail.  Is
there any tuning I can do to ensure these CLOBs get searched?  Thanks!

hi experts,
i am new to oracle and want to learn oracle.i am confused whether to
start from 9i or 10g.i also want to give ocp exams .so please can
anybody guide me which certification to give 9i or 10g.

Suppose:
-  you have a table that has only a few colums and one of them, an
integer column, is used as an index;
-  rows in this table are only ever selected using the index field;

BrightStor for Oracle Backup Installation on AIX 5.3 encounters errors
as: ./install[1525]:0403-057 Syntax error at line 2951: 'then' is not
matched. Pls help me.

I need to write "binary" data, specifically a record separator byte
(x1E), to a file.  When I do so using "UTL_FILE.put_line(file_handle,
HEXTORAW("1E"));" I end up with an ASCII hex string of "1" "E", two
bytes not one with 0x1E followed by "newline."

I just migrate from SQL Server to Oracle.
I usually use local temporary table in my SQL Server queries (sign with
'#').
Now, could I create the local temporary table in Oracle too?

Hi DBAs,
I am working on 24 X 7 database.
I have 3 control files in database if one is currupted then where can I
see this problem.

I am very new to Oracle. My customer has a requirement, where in I need
to generate the XML scripts for the data that we are appending with in
the table.
eg: for the table

I am attempting to install Oracle 10.2.0.1.0 on a Solaris 2.9 box that
has Oracle 8.1.7.4.0 already installed.  Each time the install gets to
a certain point it fails.  At first we thought it was the use of
symbolic links but the installer is looking for certain *.a files that

Please tell me the syntax for inserting a calculated column into an
Oracle 10g database. The SQL Server ALTER TABLE code won't work. A
simple example:
ALTER TABLE Rentals

i have a oracle table that have run out of space, it is created with
the following storage
TABLESPACE xxxxx
STORAGE (INITIAL 1000K

I signed up for a Oracle/SQL class, started the class then had to drop
it because I am taking a MCSE course.... long story short... I followed
the directions to uninstall oracle from my home computer but the
service for the database I created keeps trying to start. I think this

Good Morning Gentleman,
Requirment:
Need to check whether there Is a record satisfying given criteria
(transnum = :Itransnum;) in a 10 million row table.