ITPub博客

首页 > 数据库 > Oracle > remap_tablespace

remap_tablespace

原创 Oracle 作者:tolilong 时间:2015-10-09 14:56:41 0 删除 编辑

remap_tablespace多个的时候,如下两种方式都可以的。
remap_tablespace=users:tt2 remap_tablespace=tt1:tt3
remap_tablespace=users:tt2,tt1:tt3

C:\Users\Admin.LONG1-LI>impdp tt3/tt3 directory=temp_dir dumpfile=scott.dmp remap_schema=scott:tt3 remap_tablespace=users:tt2 remap_tablespa
ce=tt1:tt3

Import: Release 10.2.0.1.0 - Production on Monday, 28 September, 2015 9:59:56
C:\Users\Admin.LONG1-LI>impdp tt3/tt3 directory=temp_dir dumpfile=scott.dmp remap_schema=scott:tt3 remap_tablespace=users:tt2,tt1:tt3

Import: Release 10.2.0.1.0 - Production on Monday, 28 September, 2015 9:56:10
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "TT3"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "TT3"."SYS_IMPORT_FULL_01":  tt3/******** directory=temp_dir dumpfile=scott.dmp remap_schema=scott:tt3 remap_tablespace=users:tt2,t
t1:tt3
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TT3"."DEPT"                                5.656 KB       4 rows
. . imported "TT3"."EMP"                                 7.820 KB      14 rows
. . imported "TT3"."SALGRADE"                            5.585 KB       5 rows
. . imported "TT3"."TT1"                                 4.945 KB       3 rows
. . imported "TT3"."TT2"                                 4.929 KB       3 rows
. . imported "TT3"."TT3"                                 4.937 KB       2 rows
. . imported "TT3"."BONUS"                                   0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "TT3"."SYS_IMPORT_FULL_01" successfully completed at 09:56:14

##################################################################################################################################

C:\Users\Admin.LONG1-LI>impdp tt3/tt3 directory=temp_dir dumpfile=scott.dmp remap_schema=scott:tt3 remap_tablespace=users:tt2,tt1:tt3

Import: Release 10.2.0.1.0 - Production on Monday, 28 September, 2015 10:03:12

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "TT3"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "TT3"."SYS_IMPORT_FULL_01":  tt3/******** directory=temp_dir dumpfile=scott.dmp remap_schema=scott:tt3 remap_tablespace=users:tt2,t
t1:tt3
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TT3"."DEPT"                                5.656 KB       4 rows
. . imported "TT3"."EMP"                                 7.820 KB      14 rows
. . imported "TT3"."SALGRADE"                            5.585 KB       5 rows
. . imported "TT3"."TT1"                                 4.945 KB       3 rows
. . imported "TT3"."TT2"                                 4.929 KB       3 rows
. . imported "TT3"."TT3"                                 4.937 KB       2 rows
. . imported "TT3"."BONUS"                                   0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "TT3"."SYS_IMPORT_FULL_01" successfully completed at 10:03:16

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/24237320/viewspace-1813598/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-07-13

  • 博文量
    406
  • 访问量
    1208701