Will IGNORE=Y Option Work with Data Pump IMPDP

In conventional import utility (IMP) we have IGNORE=Y option to ignore the error if the object is already present in the database. If you give the same option in data pump impdp it will consider as the TABLE_EXISTS_ACTION=APPEND. The data from the dump will be appended to the table. See an example below.

$ impdp directory=exp_dir dumpfile=emp.dmp logfile=imp1.log ignore=y

Import: Release - Production on Tue May 1 23:37:37 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdva
UDI-00002: invalid username or password

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "ignore=TRUE" Location: Command Line, Replaced with: "table_exists_action=append"
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":  /******** AS SYSDBA directory=exp_dir dumpfile=emp.dmp logfile=imp1.log table_exists_action=append
Processing object type TABLE_EXPORT/TABLE/TABLE
Table "SCOTT"."EMPLOYEE" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT"."EMPLOYEE"                        5.953 KB       4 rows
Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at 23:37:47

More About Data Pump Impdp TABLE_EXISTS_ACTION Parameter
DBA Tips Data Pump Reference


Post a Comment


dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google