刚才和同学聊天,说到数据泵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 ~]$
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 ~]$
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29505646/viewspace-1485845/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29505646/viewspace-1485845/