In Tom's expert oracle database architecture book, i got stumped on
page 7. He uses this sentence: "Create an index only on the
processed_flag column when the processed_flag is N...".  i am stumped
on how to make an index on a column but only for certain values. In

I wanted know if table objects are available with sql server and oracle
ver 7

Where can I get data for testing databases: Oracle, MSSQL.
The large databases or prepared scripts.
Can I get it somewhere?
Thank You very mach for your help!

I am at a client who has recently migrated from Oracle 7.3.4 to Oracle
9.0.2. During the migration, we noticed that we could not execute a
number of the package procedures, resulting in an error message
ORA-03117 (internal message that should not occur). After some

Hi, in our application a user is able to retrieve a dcoument (typically
MS Word in terms of its origin and mimetype) from the system (this is a
9i / mod_plsql / iAS application running in a browser) and we display
this in a browser window. A user has asked if they can edit the ...

Solaris 9
Veritas Foundation for Oracle 4.1 & Veritas VM
Oracle 10.2.0.1 & 9.2.0.6
We want to setup 2 Node RAC for oracle (i) 9iR2 and (ii) 10gR2 on the

We are setting up a failover over server for our big database. The
current server has O/S Solaris 2.6, we plan to install O/S solaris 2.8
on failover server. Database is 8.1.7.4 release.
Do you see any issues if we have different O/S on failover servers.

And if yes, is there a way to turn them on, using order by or
something?
THX
Dean

we use an Oracle 9 database, and connect via ODBC (yes I know, it is
not good to have ODBC connecting to Oracle, but there is no choice for
us)
When a user is logging in, everything works fine. He uses our

In one my trace file i have this error
*** 2005-12-12 13:41:37.097
ksedmp: internal or fatal error
Current SQL statement for this session:

Thank you for all your posts. I learn alot from just lurking.
We are a 9.2.0.6 shop looking to upgrade to 10.2.
I have installed the software in a new home and taken my cold backup of
the database. Now I want to connect as sysdba via the 10.2 client.

I would like to execute following statement in Oracle 9i SQL Worksheet:
insert into rp_themeright_definition values (42, 'Sachdaten erstellen &
löschen', 3);
I get the following error message:

Can anyone shed some light on this ?
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
 'This view joins product_information and product_descriptions, using

First time caller here, so a bit nervous.
Oracle 10.1.0.4 (HPUX)
I’m building a consolidated table of about 30 million rows for a
reporting type instance.

Help - I've got an Enterprise Edition database (9i) where we have two
types of user; User Interface-based and Analyst-based. I'd like to use
something (e.g., Resource Manager) to ensure that Analysts get 100% of
CPU unless the User Interface users want to do something, at which