justDo1MoreTime 2019-04-18 16:26 采纳率: 0%
浏览 1696

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

数据泵导入时,
设置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条回答

  • Flying_with_you 2019-05-14 17:33
    关注

    table_exists_action选项对序列是无效的,所以会报序列已存在的错误。

    评论

报告相同问题?

悬赏问题

  • ¥15 教务系统账号被盗号如何追溯设备
  • ¥20 delta降尺度方法,未来数据怎么降尺度
  • ¥15 c# 使用NPOI快速将datatable数据导入excel中指定sheet,要求快速高效
  • ¥15 再不同版本的系统上,TCP传输速度不一致
  • ¥15 高德地图点聚合中Marker的位置无法实时更新
  • ¥15 DIFY API Endpoint 问题。
  • ¥20 sub地址DHCP问题
  • ¥15 delta降尺度计算的一些细节,有偿
  • ¥15 Arduino红外遥控代码有问题
  • ¥15 数值计算离散正交多项式