i have a pl/sql statement
that inserts into a table, the select  brings back about 1000 rows, but
the table already has 900 of the rows and a unique constraint on it.
i want the pl/sql to disregard any row that is already there but insert

I installed an Oracle 10.1.0.2 on a Debian Woody machine.
After the installation someone did an upgrade of the Debian
from Woody to Sarge. Now I tried to install the Patchset
10.1.0.4. I get an error (or warning??)

I have an ER diagram which has an entity called "Form" .This is a typical
electronic Form but number of its fields are not known and may vary at future.
What is the best logical design for this case? If I  create a table for this
Form I should add columns to it in the future.This ...

Putting costs aside what do most people think about using hardware san
replication technologies like SRDF/Truecopy etc..  for replicating Oracle
volumes at a block level to a remote instance of Oracle ? vs using something
like dataguard, I know dataguard allows you to have read ...

We have a long-running query (CTAS) that throws up ORA-01555. This is
the only query running against the database, which is Oracle9i
(9.2.0.6). Also, automatic undo is turned off on instructions from the
application vendor. Increasing the rollback tablespace makes this error

I've got a problem where a Redhat Linux server running our Oracle 10g
database stops responding every couple of weeks at random times.  It could
be connected with backups that take place at night but we can't find any
problems reported by Oracle or Linux.  The only notice we get is ...

We are having issues with OLTP scalability. I am sure it is my
implementation of db. We have one machine with 2 cpus (3Gig Hz) and
about 16 drives.   One table is about 10 Million rows. Queries and DML
are taking place Updates are killing us.  We are seeing about 10-20

I got a v9.2.0 oracle database engine installed and I create a database
called TEST1. I'm able to launch the listener for this DB and I can connect
to this base with sqlplus locally. But I'm not able to connect from any
other machine with sqlplus. I always get :

I am on Oracle 9i and using conventional path load because of trigger
in the table.  Is there a way to make it commit at the end of the load
file?  The files I am trying to load are around 100M.  I tried to use
ROWS and bindsize but sql loader crashed with "SQL*Loader-700: Out of

Looking for a consultant with solid experience in application and
database security for a project in the GTA.
CONTACT
------------------------------­---------------------

I've probably just not found the correct manual to read, but I looked in
both the SQL Reference and the Advanced Security Guide and haven't found
any information on the amount of extra space used if you're using TDE -
transparent data encryption.  Does each row (field?) grow, or ...

My input data consists of a string field. I need to find rows where
this string field is matching "approximately"!! i.e. I need some kind
of a fuzzy match.
Is there any such inbuilt facilitty/function in SQLServer or Oracle?

Does anyone know how to get a jumpstart on oracle apps?
i have installed it on a unix box and want to apply patch, however i
don't know where to find a patch and which patch should apply.
Thanks in advance.

I am running SAP R/3x200 on a 9.2.0.5 database. I perform a nightly
backup to disk (SAN) of Prod and Dev systems, which run at different
times, using SAP BRBACKUP which uses RMAN. The db sizes are 60G and 45G
respectively. I am getting markedly different backup times for both

     We are using explicit cursors in select statements as shown
below:
SELECT A.OID OID,PUR_ORD_NUMBER,PUR_ORD_DATE,PUR_VENDOR_CD,
(SELECT NAME FROM BV_USER X,BV_USER_PROFILE Y WHERE X.USER_ID =