oracle impdp导入覆盖,impdp覆盖的问题

下面的提示是碰到已经有的type,sequence就跳过去了(ignore),什么方法可以导入覆盖而不是ignore?

Starting "VEBACKUP"."SYS_IMPORT_SCHEMA_01":  vebackup/******** DIRECTORY=DATABAK_DIR DUMPFILE=veasms_Friday_01.DMP,veasms_Friday_02.DMP,veasms_Friday_03.DMP,veasms_Friday_04.DMP,veasms_Friday_05.DMP,veasms_Friday_06.DMP,veasms_Friday_07.DMP,veasms_Friday_08.DMP SCHEMAS=veasms REMAP_SCHEMA=veasms:veasms LOGFILE=impdpstan.log table_exists_action=replace

Processing object type SCHEMA_EXPORT/USER

ORA-31684: Object type USER:"VEASMS" 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:"VEASMS"."TY_KHDD" already exists

ORA-31684: Object type TYPE:"VEASMS"."LB_ROW_TYPE_fp" already exists

ORA-31684: Object type TYPE:"VEASMS"."ETERM_FXFD_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_ETREM_FXFD_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_YBF_EMNU" already exists

ORA-31684: Object type TYPE:"VEASMS"."TY_YBF_SPLIT" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_BM" already exists

ORA-31684: Object type TYPE:"VEASMS"."TY_STR_SPLIT" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_AREA" already exists

ORA-31684: Object type TYPE:"VEASMS"."HDP" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_ETERM_SHOW_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."ETERM_IFGBYJ_CW_ROW" already exists

ORA-31684: Object type TYPE:"VEASMS"."HY_YJ_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."LB_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."LB_ROW_XCDPRINT" already exists

ORA-31684: Object type TYPE:"VEASMS"."LB_XML_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."LY_TDD_JG_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."LY_TDD_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."LY_TDD_YL_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."MDNUSER_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."TYPE_KHDD_COUNT" already exists

ORA-31684: Object type TYPE:"VEASMS"."TKHD_ROW" already exists

ORA-31684: Object type TYPE:"VEASMS"."TYPE_SPLIT" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_CFXC_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_CJR_BXYJ_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_CJR_BZYJ_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."DRFP_DSPH" already exists

ORA-31684: Object type TYPE:"VEASMS"."DRTP_DSPH" already exists

ORA-31684: Object type TYPE:"VEASMS"."DRZCP_DSPH" already exists

ORA-31684: Object type TYPE:"VEASMS"."HDYJ" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_HZTJ_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_HZTJ_ROW_TYPE_5000" already exists

ORA-31684: Object type TYPE:"VEASMS"."PJ" already exists

ORA-31684: Object type TYPE:"VEASMS"."QKHS_DSPH" already exists

ORA-31684: Object type TYPE:"VEASMS"."QTSZ_DSPH" already exists

ORA-31684: Object type TYPE:"VEASMS"."ZCLIST" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_ETERM_HB_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."TP_TDDJE_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_ZCPP_HB_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_ZCPP_WFC_HB_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_HC_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_ZCPP_DDJSZC_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_ZCPP_DDTJZC_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."T_KHXX_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."DDBH3_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."DDBH5_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS"."HDTP_ROW_TYPE" already exists

ORA-31684: Object type TYPE:"VEASMS".

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值