Anybody know how I can get data that is not on my application table
into a cdc table, particulary custom session data like the "real" user,
passed in from the web or a client application, who is making the
change?  The Oracle user will be the same for everybody since we are

Our DAT DDS-3 tape drive finally gave up the ghost and we are
considering replacements.
SUN now has a DAT72 format drive.  Does anyone know if ORACLE RMAN
supports the DAT72 format?

Please help.
How do I compare two records in SQL*Plus by each field pair?
-- I have two tables with the same structure, but the records in the
two tables may be the same and may be different. I can use minus to

My company is considering moving some development databases to a new
hardware platform. There are two proposals under consideration:
a) 5 blade servers, using VMware to create 25 virtual servers with each
virtual servers running a single instance of Oracle 10g on each.

I have two issues that i need some opinions.
Issue 1
I was investigating the export command that i have running on the
preprod and prod environment

    I downloaded Oracle XE (the free trial version), and I'm trying it
out for my boss.  I've got a script that contains the statement
'whenvever sqlerror continue;' and the Run Script page says "You have
requested to run a script containing statement(s) SQL Workshop will

I have 97 GB 10g data wareouse running on AIX. I have created star
materialized views of 150 GB I want to exclude from full export/import
cause they contains ROWID columns that will be obsolete after import.
These MVs belong to many owners. Any ideas how can I exclude MVs from

I have a database table in Oracle 9i. The table contains Data of
customers for a company. If I want retrive  all the customer codes
present in cust_cd column in a single row by using SQL statement how
can I do It.

While in the process of migrating a Progress database to Oracle 8 database,
I noticed that Oracle does not support logical variables and array data
structure. It does not seem to be right. So please let me know if I am right
in my findings or I am missing something.

I am getting ramped up on 10g.  In Oracle 9i on Solaris 8 the web
server used was Apache and was installed under
$ORACLE_HOME/Apache/Apache etc.
In Oracle 10g where is Apache installed on Sun Solaris?

I have a table with a constraint NOT NULL
wich is enable, validate,
but there is some rows with a null value.
How is it posssble ?

Anyone using Oracle Streams? Anyone know if it is available in 9i
Standard Engine?
Should I be using Oracle Streams rather tha Advanded Queueing nd Basic
Replication?

Is there any SQL command in Oracle that returns a "CREATE TABLE"
statement in Oracle. For example in MySQL there is a command called
"SHOW CREATE TABLE <tableName>"
This command can be sent from any client and it returns the script for

Let me start with the details:
Database: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit
Production
OS: SunOS P0021ADCDA 5.8 Generic_117350-20 sun4u sparc SUNW,Sun-Fire

What are various techniques to demonstrate successful restore in
Oracle?
for instance:  what kind of formal confirmation does oracle provide?
are there any sort of restore reports?  what kind of information do