xudong1107
徐晟奕扬
2019-04-18 16:26

Oracle数据泵导入设置table_exists_action=replace 依然报错

  • oracle
  • sql

数据泵导入时,
设置table_exists_action=replace意思是:存在该表的话,先drop再插入数据,
所以有我要执行的表的话应该是正常情况吧,但是为什么会报错呢。
执行语句为:

impdp atomic/******** directory=DATA_PUMP_DIR dumpfile=EXPDP_SIT20190315.dmp schemas=atomic table_exists_action=replace logfile=EXPDP_SIT20190315.log 

但是该错误不影响结果,数据成功导入了。

部分日志如下:
import: Release 11.2.0.4.0 - Production on Fri Mar 22 09:23:12 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "ATOMIC"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "ATOMIC"."SYS_IMPORT_SCHEMA_01": atomic/******** directory=DATA_PUMP_DIR dumpfile=EXPDP_SIT20190315.dmp schemas=atomic table_exists_action=replace logfile=EXPDP_SIT20190315.log
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"ATOMIC" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
ORA-31684: Object type TYPE:"ATOMIC"."FSI_ADJUST_AMORT_TYPE_OBJ" already exists
ORA-31684: Object type TYPE:"ATOMIC"."FSI_ADJUST_AMORT_TYPE_TYPE" already exists
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
ORA-31684: Object type SEQUENCE:"ATOMIC"."FSI_GEN_ACCOUNT_SKEY" already exists
ORA-31684: Object type SEQUENCE:"ATOMIC"."FSI_OBJECT_DEN_SEQ_NUM" already exists
ORA-31684: Object type SEQUENCE:"ATOMIC"."FSI_IDENTITY_SEQ" already exists
ORA-31684: Object type SEQUENCE:"ATOMIC"."PROCESS_NODE_MAP_ID_SEQ" already exists
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "ATOMIC"."FSI_D_CASA" 838.6 MB 2087267 rows
. . imported "ATOMIC"."FSI_D_TERM_DEPOSITS" 448.7 MB 1197937 rows
. . imported "ATOMIC"."FSI_D_LOAN_CONTRACTS" 32.07 MB 73974 rows
. . imported "ATOMIC"."SYS_EXPORT_SCHEMA_01" 27.68 MB 6882 rows
. . imported "ATOMIC"."SYS_EXPORT_SCHEMA_02" 27.71 MB 6520 rows
. . imported "ATOMIC"."STG_PAYMENT_SCHEDULE" 14.24 MB 378694 rows
. . imported "ATOMIC"."FSI_IRC_RATE_HIST" 10.99 MB 296220 rows
. . imported "ATOMIC"."REV_TAB_COLUMNS_MLS" 2.316 MB 15650 rows
. . imported "ATOMIC"."FSI_D_LEDGER_STAT_INSTRUMENT" 1.488 MB 4733 rows
. . imported "ATOMIC"."REV_TAB_COLUMNS" 822.8 KB 15650 rows
. . imported "ATOMIC"."FSI_RESULT_QUEUE" 641.2 KB 12332 rows
. . imported "ATOMIC"."FSI_D_INVESTMENTS" 591.7 KB 1296 rows
. . imported "ATOMIC"."DIM_COUNTRY_B" 11.18 KB 71 rows
. . imported "ATOMIC"."DIM_COUNTRY_TL" 11.45 KB 71 rows
.....
Job "ATOMIC"."SYS_IMPORT_SCHEMA_01" completed with 127 error(s) at Fri Mar 22 09:27:12 2019 elapsed 0 00:03:55

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

1条回答