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