Has anyone else noticed that the error message documentation is missing?
For me the pdf containing all ORA- messages and their meaning was the most
important document for 9i.
Is this a bug in the documentation or did oracle leave it out intentionally?

I have a table with about 10 million records, and would want to copy it
from one db instance to another. could anyone tell me what the fastest
way(s) to do this is(are).
thanks

Thank you for your advise DBAs
In linux or Solaris I rename my control file name and make new control
file with touch command.
but let me tell you,

Hi all;
Oracle 9.2 on Solaris8.  I start the Apache webserver ok with
./apachectl start and the logs indicate a normal start.
I then access the url http://machine:8000/ and get the index.html page

I've got a simple structure like the following:
DECLARE
TYPE LOGON_PACKET  IS RECORD(
    szUsername    CHAR(256),

are there any encrypt and decrypt functions available? In particular,
I'm looking for 3DES encryption library.
thanks

               Can anyone provide me some links or docs that covers
the Oracle PL/SQL Coding
Standards to Follow. I have been to tahiti.oracle.com and on net but i
am not able to provide any proper search condition.

I'm writing a package in PL/SQL with few functions and one of them logs
in to my server using defined login credenitals. How can I hide the
credentials so noone can see them when browsing a package? is there any
special protected area I could put them in and use later on in my

I am facing a problem in the case of Replication/Materialize View,its
don't support CLOB/BLOB. What is the alternative solution for this.
Please put some light.
Regards

I have 3 tables
1. customer (customer_id,name,address) primary key = customer_id
2. account (account_number,balance) primary key =account_number
3. depositor (account_number,customer_id,deposite_date)

I have never used Oracle's standard edition but may be interested in
using it because of its low price and its inclusion of RAC in Oracle
10G. I have
several questions on Oracle's standard edition on Windows or

I've got a c# .net application calling an Oracle package via ODP.NET.
The package itself calls another vendor supplied function that returns
a pipelined table based on an input parameter.
I need to return the rows from this pipelined table to the .Net app.

Hi, last week I asked in this newsgroup about getting sqlplus installed
so I could connect to an instance of Oracle at home. I didn't want to
install several hundred megabytes to just get sqlplus installed. The
suggestions were sqldeveloper and instantclient. I got sqldeveloper up

Can anyone point me to suggested implementation strategies for 10g OEM?
specifically, where the different components have been intalled?  for
ex:, has anyone installed the management service on the same node as
the DB?  what types of performance hit that makes.

I have a very strange situation.  I am using 'Oracle 10g Enterprise Edition
Release 10.2.0.1.0 - Production' on winxp.  I am trying to access tables
through the OCI.  I have the following table setup:
SQL> describe test4;