Have the following query producing the plan shown. This query is being
executed upwards of 20,000 times each run. The TRANSACTIONS table
contains 12,000,000 rows and the TRANSACTION_DETAILS table 19,000,000.
Its taking way too long to run.

I am trying to a DELETE that I thought would be simple but isn't.
I have table A and table B.  Both have a column named "Number".  There
are duplicate records in the two tables.
All I want to do is delete all of the records in table A that exist in

 When I am doing a full export of database. I am getting the below
error.
EXP-00008: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel

Here is a query that selects data over a dblink (several tables). It
returns data in 60-70 seconds. Inserting this data into a local table
takes a very long time, well over an hour.  Am I missing something? I
have several queries going to the same set of dblinks and being

Any idea why my scroll button isn't working? After running a query, I have
to use the scroll bar to move up and down. I can scroll in any other
program, but discoverer.
thanks

There are plenty of home-grown scripts for reading the data dictionary
and then generating a "disable" or "enable" constraints script - is
there any native functionality in Oracle though to do this?
9iR2 plus...

( Oracle 9iAS on RedHat 6.2 w/ /usr/local/jdk1.2.2/bin/java -version
java version "1.2.2"
Classic VM (build Linux_JDK_1.2.2_RC4, native threads, sunwjit))
Once in a while the HTTP listenneer dies giving the below entries in

I have noticed a difference in the optimizer choices between 10g and
9.2 for :
select * from all_tab_columns - choose in 9.2.0.6
select * from all_tab_columns - hint in 10.2.0.1.0

I want to create a database link from Oracle 9.2.0.5 to an Access
database.  The client wants it that way.
I'm not sure how to do this.  I mean, other than some TNS entries on
the Unix side, what needs to be put on the PC side to get to the access

Is oem repository mandatory to use data guard manager option in Oracle
client. I have oem installed on the desktop ( pre installed by
operations group) and it does not show the option at all in the
database applications. though the document says it should appear in

I have got table with many fields - including clob. And I would like to
put data using INSERT command from C++ using OCCI.
example below (not working :()
Clob clob(conn); //existing connection object

I am trying to restore backup taken by rman of database 9.2 running in
noarchivelog format on 2000. I want to restore database on another
server with same directory structure. Currently no database is existing
on new server. My understanding regarding this first nomount dastabase

I have various listeners on various databases
lsnrctl status shows SECURITY OFF for some and SECURITY ON for others
How is this set?

Hi Faculties,
 Sorry if i m posting this in the wrong group. Please bear.
 I ve installed Oracle9i on my Windows XP Prof using an Administrator
login. There are some other logins : user1 and user2 on the same system

If a machine hosting Oracle database is pinged and it shows something
like this
Reply from 10.0.0.51: bytes=32 time<10ms TTL=128
Reply from 10.0.0.51: bytes=32 time<10ms TTL=128