Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import utility limitation

Re: Import utility limitation

From: Anthony Hogan <anon_at_spain.es>
Date: Fri, 24 May 2002 09:54:19 +0000
Message-ID: <3CEE0DCB.DD106FAF@spain.es>


Hi Rudy,
Your import will have thrown up ORA-00001 errors for each insert on the table i.e. PK violation. Import attempts an insert NOT an update. The ignore=y flag refers to object creation only.  

A way around this would be to CTAS from the emp table, drop the emp table, import, manually merge the data.

You may also want to have a look at how Log Miner works.

IMO In all but the most extreme circumstances rman is not the way to recover from data entry errors.

hth
Anthony Hogan
ahogan-nospam-_at_iespana.es Received on Fri May 24 2002 - 04:54:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US