IMPDP ignore=y [message #419292] |
Fri, 21 August 2009 00:46 |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
I am importing table A records into Table B
Table A haiving 1000 records.
Table B having 100 records.
I want to import through IMPDP
What is option in IMPDP which is equivalant to IGNORE= Y in IMPORt utility
Thanks,
Amol
|
|
|
|
Re: IMPDP ignore=y [message #419302 is a reply to message #419292] |
Fri, 21 August 2009 01:25 |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Oracle> cat table_1.par
directory=table_1
dumpfile=table_1PART_20090427.dmp
logfile=table_1PART_20090427.log
tables=tmlods_owner.table_1:PART_20090427
CONTENT=DATA_ONLY
Oracle> impdp dba_sup parfile=table_1.par
Import: Release 10.2.0.4.0 - 64bit Production on Friday, 21 August, 2009 1:48:55
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "DBA_SUP"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "DBA_SUP"."SYS_IMPORT_TABLE_01": dba_sup/******** parfile=table_1.par
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "TMLODS_OWNER"."table_1":"PART_20090427" failed to load/unload and is being skipped due to error:
ORA-00001: unique constraint (TMLODS_OWNER.table_1_PK) violated
Job "DBA_SUP"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 01:49:57
Seee above error.
ORA-00001: unique constraint (TMLODS_OWNER.table_1_PK) violated
But is there any feature for IMPDP to avoid the existing rows , ignore ORA-00001: unique constraint (TMLODS_OWNER.table_1_PK) violated error?
So that i can proceed with inserting remaining records.
I cannot remove any constraint because its a production database.
Please suggest.
|
|
|
|