Hello Oracle People,
I'd like to run a shell script from the Scheduler in my 10g database.
Right now it is a simple shell script.
Eventually it will wrap RMAN commands to back up my DB.

I have a question regarding a common source code base supporting both
Oracle & DB2.
I'm in a tough spot. I know people who assume the same COBOL source
code can used regardless whether someone is using DB2 or Oracle. (This

We urgently require SAP consultant with 5 year of SAP experience
Qualification: -   recognized Bachelors or Masters degree.
Experience
1) 5 years of SAP work experience and a minimum of 3 full SAP

I've searched google.com, tahiti.oracle.com and tried going through the 10g
documentation library but I'm not finding what I'm looking for so I thought
I'd ask if anybody here would have a clue where to point me ...
I'm looking for a list of Oracle system privileges and their ...

I need to duplicate one of our DB to the new Linux server:
Original DB: 10.1.0.2 64 bit on Solaris
Catalog DB: 10.1.0.2 64 bit on Solaris
'compatible' parameter is '9.2.0' for the above 2 db.

Oracle Apps Blog
http://skrajend.blogspot.com

I've developed a perl script that works with Oracle via DBI and
DBD::Oracle.
This perl script illustrates a strange problem while fetching
LONGs and LONG RAWs.

Need your suggestions to import a large dump file.
The compressed dump file size  is around 9 GB( if I do gunzip it will
be morethan 80gb).
This dump file has around 100 tables that needs to be imported.

It has been suggested that we could set-up a new production
environment on 10gR2 (2 instances) using VMWARE. This would enable us,
as I understand it, to allocate the resources of the server in the
ratio we choose between the different databases as each would

I am trying to trace a perticular user sessions using a logon trigger.
This works fine if I connect to the database without tns alis.
Example : sqlplus scott/tiger
But no trace file is generating when I connect to the database using

Hope someone can help me with his views about the following issue, i
will highly appreciate it!
I am trying to query a column  that is not in my GROUP BY clause,
SELECT s.store_key,

I have an Access Front-End, with an Oracle Back-End, connecting via
ODBC. I want to roll this out to maybe 500 users, so I am using
RegisterDatabase to programatically add the ODBC DSN:
DBEngine.RegisterDatabase "CSD_PO_PMIS", str_Driver_Name, True,

I'm using Oracle Discoverer Administrator Edition 3.1.38
I'm a newbie and I created a business area for running reports.  There
was problem come up with the report and therefore I exported the
business area and made some changes.  The changes didn't work out so I

Is it possible to access or grab environment variables inside Oracle
Procedures?
Thanks in advance for any help or information.
We need to change an one of the directories in an http_util call based