14.3.2 调用IMPDP —— 导入表空间

C:/>sqlplus system/orcl@orcl

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 1月 5 10:16:03 2009

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

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> drop tablespace tbs01 including contents and datafiles;

表空间已删除。

SQL> drop tablespace tbs02 including contents and datafiles;

表空间已删除。

SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开

C:/>sqlplus system/orcl

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 1月 5 10:19:11 2009

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

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> create tablespace tbs01 datafile 'd:/orcl/tbs01.dbf' size 10M autoextend on
next 1M ;

表空间已创建。

SQL> create tablespace tbs02 datafile 'd:/orcl/tbs02.dbf' size 10M autoextend on
next 1M ;

表空间已创建。

SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开

C:/>impdp system/orcl@orcl directory=dump_dir dumpfile=tablespace.dmp tablespace
s=tbs01,tbs02

Import: Release 10.2.0.1.0 - Production on 星期一, 05 1月, 2009 10:20:26

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

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
已成功加载/卸载了主表 "SYSTEM"."SYS_IMPORT_TABLESPACE_01"
启动 "SYSTEM"."SYS_IMPORT_TABLESPACE_01":  system/********@orcl directory=dump_d
ir dumpfile=tablespace.dmp tablespaces=tbs01,tbs02
处理对象类型 TABLE_EXPORT/TABLE/TABLE
处理对象类型 TABLE_EXPORT/TABLE/TABLE_DATA
. . 导入了 "SCOTT"."TAB01"                             4.937 KB       2 行
. . 导入了 "SCOTT"."TAB02"                             4.937 KB       2 行
作业 "SYSTEM"."SYS_IMPORT_TABLESPACE_01" 已于 10:20:30 成功完成