ORA-39151分析

今天在导数据时出现  ORA-39151: Table "CX"."CX_CXZL" exists. All dependent metadata and data will be skipped due to table_exists_action of skip的错误，在导入语句的后面已经加了 TABLE_EXISTS_ACTION=TRUNCATE，为什么还是table存在，然后跳过呢！！

仔细观察，发现我的语句被分成了两半，实际上 ORA-39151是由上一半产生的，impdp system/11123 DIRECTORY=DP_DIR dumpfile=20141119_cx_NHLTGN.dmp logfile=imp20141119_cx_NHLTGN.log  而后一半则在后面无法识别执行。。可能是tables之前多了回车，将tables 往前移动就解决问题了

gdstdb01:/home/oracle$impdp system/11123 DIRECTORY=DP_DIR dumpfile=20141119_cx_NHLTGN.dmp logfile=imp20141119_cx_NHLTGN.log 

Import: Release 11.2.0.3.0 - Production on Thu Nov 20 08:43:46 2014


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
tables=CX.CX_CXDY,CX.CX_CXTJDY,CX.CX_CXJGDY,CX.CX_CXZL,CX.CX_SZXX,CX.CX_LXX,CX.CX_FZYJB,CX.CX_YHTJ TABLE_EXISTS_ACTION=TRUNCATE



Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** DIRECTORY=DP_DIR dumpfile=20141119_cx_NHLTGN.dmp logfile=imp20141119_cx_NHLTGN.log 
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39151: Table "CX"."CX_CXZL" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "CX"."CX_CXTJDY" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "CX"."CX_CXJGDY" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "CX"."CX_LXX" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "CX"."CX_SZXX" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "CX"."CX_YHTJ" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "CX"."CX_FZYJB" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "CX"."CX_CXDY" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 8 error(s) at 08:43:50


gdstdb01:/home/oracle$
gdstdb01:/home/oracle$tables=CX.CX_CXDY,CX.CX_CXTJDY,CX.CX_CXJGDY,CX.CX_CXZL,CX.CX_SZXX,CX.CX_LXX,CX.CX_FZYJB,CX.CX_YHTJ TABLE_EXISTS_ACTION=TRUNCATE
gdstdb01:/home/oracle$

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29863023/viewspace-1340311/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29863023/viewspace-1340311/