Home » RDBMS Server » Server Utilities » IMPDP ignore=y (Oracle 10g)
IMPDP ignore=y [message #419292] Fri, 21 August 2009 00:46 Go to next message
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 #419297 is a reply to message #419292] Fri, 21 August 2009 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ You can't import from one table into another one with imp.
2/ Try "content=data_only"

Regards
Michel

Re: IMPDP ignore=y [message #419302 is a reply to message #419292] Fri, 21 August 2009 01:25 Go to previous messageGo to next message
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.


Re: IMPDP ignore=y [message #419346 is a reply to message #419302] Fri, 21 August 2009 06:46 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

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


Fix constraint error before importing data
Previous Topic: Export with DML/Modification
Next Topic: 10g_export_errors
Goto Forum:
  


Current Time: Mon Nov 04 12:11:50 CST 2024