RE: import with IGNORE=Y option to ignore errors

  • From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 20 Jul 2004 13:43:37 -0400

David,

Import will create any missing objects.

I'm not exactly sure what you mean by "original state".  
If the table had rows in it before you ran the import, then those rows would
still exist - import will not delete any rows, but will add rows to a table.

If import had one definition for a FK or PK, and the existing table was
created with a different definition- but the same name- import would report
that the constraint already exists - but would not drop the existing one and
create the version that is in the import file.

Your best bet is to drop the table in the database, and let import recreate
it for you.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Nguyen, David M [mailto:david.m.nguyen@xxxxxx] 
Sent: Tuesday, July 20, 2004 1:36 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: import with IGNORE=Y option to ignore errors


I see but will all objects and his data be recovered to original state even
though it report errors?

Thanks,
David

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mercadante, Thomas F
Sent: Tuesday, July 20, 2004 12:27 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: import with IGNORE=3DY option to ignore errors

David,

IGNORE=3DY says just to ignore the errors - but keep reporting them. If
IGNORE=3DN, then it would report the errors and *not* import the = data.

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Nguyen, David M [mailto:david.m.nguyen@xxxxxx]=20
Sent: Tuesday, July 20, 2004 1:24 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: import with IGNORE=3DY option to ignore errors


I need to import data for an user that his table is dropped somehow.  I use
ignore=3Dy option to ignore all errors but why I still see bunches of errors
complaining about constraints violation? =20 =20

Thanks,
David


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: