advertisements
_____________________________________________________________________________________________________________________
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 11.2.0.2.0 - 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 11.2.0.2.0 - 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
More About Data Pump Impdp TABLE_EXISTS_ACTION Parameter
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment