I ve got a table named schedule which includes epg information round
about 60.000 records. I would like to check if there are logical
conflicts.
One kind of conflict is that a program start stop time frame includes

I am getting an ORA-00600 when using a MEMBER OF condition using a
nested table.
If I create a list from the data in added to the neted table the error
does not occur.

I've been playing around with an 11g DB. I installed it on OEL 5.2 (no
updates / no subscription) and did a software only install. Then I
patched it to 11.1.0.7.0. After that I wanted to create a starters
database, so I fired up DBCA, selected a General Purpose database and

I am trying to install Oracle database 10g R2 on RedHat Linux 5.
The installation goes fine till the Oracle Net Configuration Assistant
but the DBCA hangs. I have selected to create a starter database with
sample schemas. I waited for about 4 hours to let DBCA finish its

All,
Is it possible to use pl/sql tables (Associative Arrays) instead of a
varray when using the MEMBER OF condition?
Thanks

I have a table t, partitioned by business_date, one partition per day.
I have a locally partitioned index on this table on column c1. The
following query performs as expected and accesses only one partition
of the index, and doesn't touch the table at all (as expected):

I'm trying to work out how many messages are queued in a pipe and how
long said messages are. Anyone got any ideas?
So far, the best I can come up with is something silly like receiving
DBMS_PIPE messages, unpacking them, counting and adding lengths and then

A programmer colleague of mine asked if he could submit a batch of
insert statements to Oracle (9i) using C#. And if there's any way to
identify which insert statement, if any failed during the batch
execution.

No otn links working, no tahiti, nothing.
Must be that 'unbreakable'  thing at work again...

I'm a little confused about how this works, or if its just an option for
what I want to do, which is, take a copy of a production database on
windows 32 bit os and prepare it for windows x86 64 bit. Database is
10.2.0.4

our environment: 9i EE 9.2.0.4 64bit, Solaris 8
We're trying to understand why the CBO picks suboptimal
single partition scan, when there is a more efficient
index range scan available.

no answer yet, but I've made some progress.  Is there a way to tell
REGEXP_INSTR to ignore spaces in my string?
Sale I have this expression:
SELECT REGEXP_INSTR('"FO EM, FO LA","ABCDEF","12345"','"([[:alnum:]])+,

 we are considering seriously on upgrading our database server.
 Current  database runs on HP-UX 11.11, 20CPU and  36GB RAM. The
version is Oracle8.1.7.
 To system running records,  we met Ora-600 error frequently. There

There has been many communication on the exists command on newsgroups, web
sites... but I could not find anything close to this (below) that it can be
possible with MS SQL.
I am migrating databases and scripts from SQL to Oracle and I am trying to

Can someone tell me if the Discoverer EUL command line for java can be
used on Discoverer Desktop?
Thank you in advance for your help!
Leo