| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: import with IGNORE=Y option to ignore errors
In the case of existing tables without a PK or UK constraint or a unique
index running an import with ignore=y can load duplicate (or unnecessary)
data. The ignore=y option is a very useful feature when you want to load or
restore data to an existing table. But you need to understand the effect it
can have when you use it on a full import.
Prior to alter table move the feature was very useful for relocating tables: exp, truncate, drop, recreate in new tablespace, imp ignore=y.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F
Sent: Tuesday, July 20, 2004 1:44 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: import with IGNORE=Y option to ignore errors
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_at_xo.com]
Sent: Tuesday, July 20, 2004 1:36 PM
To: oracle-l_at_freelists.org
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Mercadante, Thomas F
Sent: Tuesday, July 20, 2004 12:27 PM
To: 'oracle-l_at_freelists.org'
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_at_xo.com]=20
Sent: Tuesday, July 20, 2004 1:24 PM
To: oracle-l_at_freelists.org
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |