hi everybody! i m doing oracle 9i dba from niit delhi. presently i m
working with a reputed printing organization (THOMSON PRESS (I) LTD.
FARIDABAD, HARYANA, INDIA) in delhi ncr. i have almost 7 yrs of exp in
production as well as planning and working on oracle as an user for

I currently have a stored procedure which reads a transaction table for new
records, writes them to a flat file (which is uploaded to a mainframe system
for processing) and then updates the records as being processed.
We will be creating a new ORACLE instance which also creates ...

I have been tasked with cloning our prod db to a new server from an
rman backup(with a catalog) on tape to a new server in another data
center. I have installed oracle on the new server and have copied the
init file and started up the db. I created a new catalog user in the

OCP People,
I'm looking at topic areas for the OCP Exam 1Z0-040.
I'm curious about this topic:
"Installation Performance Enhancements"

I'll appreciate your help in the following case.
I get a varchar parameter, in my procedure, that stores several
supplier's id (concatenated and separated by commas) which I want to
use in my where clause as follows: WHERE supp_id

I have been tasked with cloning our prod db to a new server from an
rman backup(with a catalog) on tape to a new server in another data
center. I have installed oracle on the new server and have copied the
init file and started up the db. I created a new catalog user in the

I have a query that returns a huge result set and would like to
display the results page by page to the user, similar to the way how
Google displays its results. To do this, I have to first find an
approximation of the number of rows returned, then fetch results page

I write installation scripts in sqlplus which as a first command issue
"DROP USER". When the user to be dropped is currently connected i get
"can't drop connected user" error, but the script carries on.
What i want to do is to display prompt like "you have to disconnect

There are three different systems (a Mainframe, a C++ application and
a VB application) connected to each other through Application
Integration (AI) layer (CORBA + MOM). Database of two of the systems
i.e., C++ application and VB application must be in sync with each

someone could tel me how can i do to see the value of theese
parameters ?
_OPTIMIZER_MJC_ENABLED
_projection_pushdown

I search a GOOD solution to generate scripts to recreate database with
no data.  I already do that with EXP/IMP but someone have better
suggestion to me.
Thanks!

I'm on oracle 9i and don't have regex functionality in plsql.
How can I strip out and set a persons last name from a column .
I have a column name that will contain names like
John L. Hubbard

I've use VB as my front-end and oracle as my back-end.
I tried to use the program to purge data from 8i to 9i, all the while
there is no problem, but after sometimes, when i purge the data, it
will prompt this error message: "Out of present range".

Hi Guru's
Basically, I just need to know whether it is possible to restore data
backed by RMAN to a database/server other than the database/server it
was backed up from.

Hey All,
This is probably a simple question, but I've never seen this before:
VOLGA2.__shared_pool_size=1073741824
*.background_dump_dest='/u01/NI00/admin/bdump'