imp ignore
impdp
impdp prdrefwork/dba4true directory=test dumpfile=a.dmp tables=csm_offer TABLE_EXISTS_ACTION=append
default is value skip
局限性：不能在DB readonly状态下运行，而exp可以
[ora10g@centos ~]$ expdp prdrefwork/dba4true dumpfile=a.dmp tables=csm_offer directory=test
Export: Release 10.2.0.1.0 - 64bit Production on Tuesday, 29 October, 2013 7:14:26
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31633: unable to create master table "PRDREFWORK.SYS_EXPORT_TABLE_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 863
ORA-16000: database open for read-only access
imp statistics=none
impdp
impdp prdrefwork/dba4true directory=test dumpfile=a.dmp tables=csm_offer TABLE_EXISTS_ACTION=append exclude=statistics
阅读(1378) | 评论(0) | 转发(0) |
