Oracle 11g数据泵详解 - 数据库编程

*****************
?Dump file set for SYSTEM.SYS_EXPORT_TABLE_03 is:
? /backup/expdp/hhhf.dmp
?Job "SYSTEM"."SYS_EXPORT_TABLE_03" successfully completed at 11:53:10

4)SQL> alter table liuwenhe.liuwenhe? drop column y;

Table altered.

5)SQL> truncate table liuwenhe.liuwenhe;

Table truncated.

6)[oracle@rac1 expdp]$ impdp system/manager123 directory=bak dumpfile=hhhf.dmp tables=liuwenhe.liuwenhe? content=data_only;

Import: Release 11.2.0.3.0 - Production on Mon Jul 6 11:55:07 2015

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

Master table "SYSTEM"."SYS_IMPORT_TABLE_04" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_TABLE_04":? system/******** directory=bak dumpfile=hhhf.dmp tables=liuwenhe.liuwenhe content=data_only?

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

. . imported "LIUWENHE"."LIUWENHE"? ? ? ? ? ? ? ? ? ? ? 5.492 KB? ? ? 6 rows

Job "SYSTEM"."SYS_IMPORT_TABLE_04" successfully completed at 11:55:13
7)SQL> select * from liuwenhe.liuwenhe;

? ? ? ? X

----------

? ? ? ? 1

? ? ? ? 2

? ? ? ? 3

? ? ? ? 4

? ? ? ? 5

? ? ? ? 6

6 rows selected.

总结：Oracle数据泵，逻辑备份和恢复工具，他直接在逻辑从面操作，不能想象成单纯的insert ，而且只导出数据，然后恢复数据时候，可以不用写remap_tablespace这个参数。?

Oracle 11g数据泵详解(三)