Oracle ORA-31684在计划期间

c:\users\179818>impdp demo2/demo2@ora11g directory=TMP dumpfile=demo_dump.dmp remap_schema=DEMO:DEMO2 table_exists_action=SKIP

Import: Release 11.2.0.4.0 - Production on Mon Oct 5 17:57:24 2015

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 "DEMO2"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "DEMO2"."SYS_IMPORT_FULL_01":  demo2/********@ora11g directory=TMP dumpfile=demo_dump.dmp remap_schema=DEMO:DEMO2 table_exists_action=SKIP
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
ORA-31684: Object type SEQUENCE:"DEMO2"."S1" already exists
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Table "DEMO2"."EMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
Table "DEMO2"."DEPT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Job "DEMO2"."SYS_IMPORT_FULL_01" completed with 1 error(s) at Mon Oct 5 17:57:29 2015 elapsed 0 00:00:04


c:\users\179818>

conn dba_user/oralce@ora11g
create user demo identified by demo
default tablespace data_11g;
alter user demo quota unlimited on data_11g;
grant create session,create table,create sequence to demo;

create user demo2 identified by demo2
default tablespace data_11g;
alter user demo2 quota unlimited on data_11g;
grant create session,create table,create sequence to demo2;

conn demo/demo@ora11g
create table emp as select * from scott.emp;
create table dept as select * from scott.dept;
create sequence s1;
host
expdp demo/demo@ora11g directory=TMP dumpfile=demo_dump.dmp

The ORA-31684 in this situation cannot be avoided. The conventional EXP/IMP tools could not replace such objects and EXPDP/IMPDP has been designed the same way.