oracle39151解决办法,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/11123DIRECTORY=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/，如需转载，请注明出处，否则将追究法律责任。