【ORACLE】impd expd的几个例子

**********************************************

** 原文： blog.csdn.net/clark_xu  徐长亮专栏

**********************************************

#按照表导出
[oracle@host2 ~]$ expdp u1/tiger tables=family  dumpfile='u1_family.dump' directory=dump_dir job_name=family1

Export: Release 10.2.0.5.0 - 64bit Production on Monday, 11 August, 2014 12:58:39

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Starting "U1"."FAMILY1":  u1/******** tables=family dumpfile=u1_family.dump directory=dump_dir job_name=family1
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "U1"."FAMILY"                               5.984 KB       2 rows
Master table "U1"."FAMILY1" successfully loaded/unloaded
******************************************************************************
Dump file set for U1.FAMILY1 is:
  /oracle/product/10.2.0.5/rdbms/log/u1_family.dump
Job "U1"."FAMILY1" successfully completed at 12:58:44

#跨用户导入:
[oracle@host2 ~]$ impdp u2/tiger  dumpfile=u1_family_1.dump directory=dump_dir  REMAP_SCHEMA=u1:u2

Import: Release 10.2.0.5.0 - 64