I'm hoping someone can help me.  I have the query below with the
explain plan.  It takes more than 10 minutes to complete.  There are
only 128 records in the table named INDUSTRY and about 150,000 records
in the table named BROKER_REP_LOOKUP, and BROKER_REP_LOOKUP is

Oracle 9.2.0.7
Windows 2003
We are going through a Certification and Accreditation process with
our databases. We are being dinged for grants that any schema owner is

10gR2
If a couple of (non-unique) indexes are added to a table...
is the table supposed to be re-analyzed (immediately) to be useful to the
CBO ?

I have this query in which I am trying to figure out the best way to
get a result set for my application.
I really want to be able to call a query, function, etc and pass it
three values and get a result set back. Before I was using views to

The Oracle DB is on a PC with OS windows XP. I want to access the db from
another machine with MIPS cpu and linux OS.
I wonder is that possible and how to?
Thanks in advance.

Web based app (using mod_plsql)
At the start of processing, an activity ID is retrieved from a sequence:
select act_s.nextval
into   l_act_id

I'm running on 10g Express Edition 10.2.0.1.0
There is some strange behaviour of the ORDER BY clause in the
following example. I'm executing all SQL via JDBC.
create table test (foo varchar2(3))

I have to create a service_name called "supora" for the Oracel
instance called Ora9i running on machine "support-db1". Then I need to
use this service_name to create a Net service name on my local machine
so that I can connect to that ora9i instance on support-db1.

I need your help and I want to install for my learning things.   There
are different files.  Can you tell me what is the different and what
is the easiest installation for my learning.    Is there website for
me to follow the step by step and tell me which one is the better file

I am fairly new to oracle, and have run into a problem that confuses me. I
tried to create a database manually, and for some reason the create database
script failed. After correcting what was wrong and cleaned up all the files
I try once again. But now I'm not able to start due ...

Is there a way to get the length of a CLOB in bytes (not in chars)?
Thanks!

I am trying to raise a simple error in a trigger...But apart from my
error it also displays two other errors.
ORA - 6512 at line 10
and ORA 04088 : error during execution of trigger

I've heard Dataguard Real Time Apply feature makes Primary database to
do a bit of overhead processes.Is that true? Is there the source WP or
metalink docs or else?
Thanks in advance.

I've got a long running job that is using the database to queue
up entries to be processed.
Sometimes a couple of million items might be dumped in the queue,
needing a couple of days to process.

I'm working with Oracle 10g and need an instance where whenever a
record is modified I can automatically store a copy of that record and
assign it a version number.  So at any given time I can see a history
for that given record in the table.