We have just introduced a new application (java based) which accesses
an Oracle 9i db. The app is quite complex and we have experienced some
oracle back end performance issues.
Explain plans indicate that certain indexes were not being used on the

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, I'm studying a book which is full of errors and the errata seems
sketchy.
Is this statement correct?
"In outer join statements on tables A and B, you specify the left outer

navigation, to creating your own SAP reports and using the many
different SAP components that make up NetWeaver and mySAP business
suite today, this Guide is ideal for people at all levels of

Hello Oracle Experts!
Unfortunately, I am given the task of designing database for a web
based application. Basically my Oracle DB would consist of several
schema's with identical tables something like the following

(1) While loading data using sql-loader I got the following error:
SQL*Loader-951: Error calling once/load initialization
ORA-26052: Unsupported type 180 for SQL expression on column col3.
I looked into docs for error description:

I'm trying to figure out how to test if an Oracle instance is healthy.
I mean, if it will respond to some basic query.
If I execute one query in one of the schemas in the instance, can I be
sure that the others schemas are in good shape? Or I need to test

Dear Experts,
I am going to migrate my applications from Oracle 9i to Oracle 10g
server. Some time ago I read that 10g has stricter rules for a user
password (must be at least 6 characters long, not be a simple

Oracle 10g 10.2.0.3, Windows 2003 Server
This may seem an easy question but I can't seem to find an answer.
If an Oracle instance is set up for automatic memory management and there
are some parameters, such as bitmap_merge_area_size (etc) which are non-zero

MI5Victim@mi5.gov.uk filted:

Sometimes these things just work out perfectly....r

10gR2
In my app, I've been using "OPEN some_cursor FOR some_dyn_sql ;"
Now I'm facing a limitation problem.... I have to generate a VERY LARGE
dynamic SQL.

Hi all gurus,
I have personal oracle 8i on Win Xp.  starting to learn oracle 8i.
By error created an extra system02.dbf file in personal oracle 8i
using dba studio.

I just recently transitioned from 9i to 10g. One question not covered in
the new features class was dba_jobs v. dba_scheduler_jobs. I'm asking
because I thought that the 10g scheduler replaced the old dbms_jobs
package, but when I created a materialized view on 10g and set up

How I can call the oracle function from SQL SERVER 2000 stored
procedure . Anyone?

I am trying to import a dump file in a scheme through the command "imp
parfile = filename" from cmd.exe and i am getting the following error:
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully