Does anyone know of the best way to prepare for the OCA examination ?
I m interested in brain dumps. please refer !
Thanks

what does a tnsnames.ora have to look like on a client? I copied a working
tnsnames.ora from a server (Windows 2003, 10g) to my client (Windows XP,
also 10g) but still can't tnsping the SID, TNS-03505.
PROD_SID =

10gR2
Not a Java guy here.....
Give a GTT (Global Temp Table), defines as "On DELETE Commit"....
Is it possible that one Java/Oracle sessions running on JBOSS will "reuse"

I have other asp.net web services that I can call with no problem from
oracle as follows:
declare
 o varchar2(5000);

During the last month, we have promote version of Oracle server 9i to
10g. A cursor is very slow since the 10g version. This cursor uses
much NVL function to retrieve information.
I would like know if the function NVL can be used in Oracle 10g?

I specified a full export from one database instance (exp user/
passwd@sid FULL=Y FILE=fu.dmp)
My question is,if I import this into another instance, will this
overwrite the "System" schema in the new instance? Is there a way to

During the last month, we have promote version of Oracle server 9i to
10g. A cursor is very slow since the 10g version. This cursor uses
much NVL function to retrieve information.
I would like know if the function NVL can be used in Oracle 10g?

I have a question about "the best" approach to deal with lookup
tables(employees, sections, etc..) that show up again and again in
many database (HR, Inventory, CRM ) of an enterprise with Oracle DB
servers.

Dear Experts,
Our organization is moving from Oracle 9i to 10g. I know about some
technical issues during migration of the database itself, but what
about the user application level (SQL/PL scripts, triggers, sequences,

does anybody know the meaning of the v$lock.id1 column for a lock of
type 'DX'?
We are facing some problems w/ this type of lock.
Sometimes a session hangs after acquiring a DX lock in exclusive mode

Is there an easy way to find which of a set of numbers isn't in a
table? I'm trying to find financial periods that are missing from a
set of data. I can do it if I have a table which just contains the
valid period numbers 1- 12 in the following way:

I have a question about rownum which is not mentioned.
Lets say that I want to extract a 3 records out of a result where the
middle one is the query.
For example:

An Exciting Opportunity for Oracle Apps DBA Professionals Gear up guys
let's attend a seminar on "Career options for oracle apps
professionals" by Mr.K.Bramhananda Rao an Oracle Apps DBA Professional
from a Global MNC.

Hi all gurus,
A stupid question.  How to delete system02.dbf file from Personal
Oracle 8i.
By error created system file in personal oracle 8i using dba studio.