刚才和同学聊天,说到数据泵IMPDP的remap_schema会不会自动创建用户.做了一个实验.

remap_schema后面的用户需要建立好,才行.

[oracle@rh5 ~]$ impdp system/oracle directory=mydir dumpfile=exp_dp.dmp remap_schema=hr:lkn


Import: Release 11.2.0.3.0 - Production on Fri Apr 3 21:34:36 2015


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


UDI-12162: operation generated ORACLE error 12162
ORA-12162: TNS:net service name is incorrectly specified


[oracle@rh5 ~]$ p1
[oracle@rh5 ~]$ impdp system/oracle directory=mydir dumpfile=exp_dp.dmp remap_schema=hr:lkn


Import: Release 11.2.0.3.0 - Production on Fri Apr 3 21:35:00 2015


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, 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=mydir dumpfile=exp_dp.dmp remap_schema=hr:lkn 
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"LKN"."MAG" failed to create with error:
ORA-01918: user 'LKN' does not exist
Failing sql is:
CREATE TABLE "LKN"."MAG" ("AUTHOR" VARCHAR2(30 BYTE), "ANAME" VARCHAR2(50 BYTE), "ADATE" DATE, "ADATA" CLOB) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 21:35:06


[oracle@rh5 ~]$ impdp system/oracle directory=mydir dumpfile=exp_dp.dmp remap_schema=hr:sh


Import: Release 11.2.0.3.0 - Production on Fri Apr 3 21:35:39 2015


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, 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=mydir dumpfile=exp_dp.dmp remap_schema=hr:sh 
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SH"."MAG"                    188.7 KB    2052 rows
Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at 21:35:49


[oracle@rh5 ~]$