oracle 10g utilities .pump(1)

1.expdp

start ?/demo/schema/mkplug.sql;

create directory dmpdir as '/tpdata/dumpdata';

SQL> grant read,write on directory dmpdir to hr;

Grant succeeded.

SQL> grant read,write on directory dmpdir to test;

Grant succeeded.

[oracle@limmTest ~]$ expdp test/test DIRECTORY=dmpdir DUMPFILE=test2.dmp TABLES=test.T_TEST_RESUMABLE;

Export: Release 10.2.0.1.0 - Production on Sunday, 27 December, 2009 6:14:50

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
Starting "TEST"."SYS_EXPORT_TABLE_01":  test/******** DIRECTORY=dmpdir DUMPFILE=test2.dmp TABLES=test.T_TEST_RESUMABLE
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 61.62 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "TEST"."T_TEST_RESUMABLE"                   27.97 MB  299774 rows
Master table "TEST"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for TEST.SYS_EXPORT_TABLE_01 is:
  /tpdata/dumpdata/test2.dmp
Job "TEST"."SYS_EXPORT_TABLE_01" successfully completed at 06:15:09

[oracle@limmTest ~]$

幾個常用引數解析：
attach：ATTACH [=[schema_name.]job_name]
預設是當前使用者下執行的job。
相關檢視：dba_datapump_jobs和user_datapump_jobs
當使用attach引數的時候，不能使用除了 user/password以外的其他任何引數，不能attach其他schema的job，除非
這個job是正在執行的。例如這個例子中的hr.export_job是當前存在的：expdp hr/hr arrach=hr.export_job

content
預設值是ALL CONTENT={ALL | DATA_ONLY | METADATA_ONLY}
all包括了data和metadata
例子：expdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp CONTENT=METADATA_ONLY
這個命令將export hr schema；

[oracle@limmTest tpdata]$ expdp hr/hr DIRECTORY=dmpdir DUMPFILE=hr.dmp CONTENT=METADATA_ONLY

Export: Release 10.2.0.1.0 - Production on Sunday, 27 December, 2009 7:08:50

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
Starting "HR"."SYS_EXPORT_SCHEMA_01":  hr/******** DIRECTORY=dmpdir DUMPFILE=hr.dmp CONTENT=METADATA_ONLY
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Master table "HR"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HR.SYS_EXPORT_SCHEMA_01 is:
  /tpdata/dumpdata/hr.dmp
Job "HR"."SYS_EXPORT_SCHEMA_01" successfully completed at 07:09:20

[oracle@limmTest tpdata]$

directory 
指定目錄
示例：
create directory dmpdir as '/tpdata/dumpdata';
select * from dba_objects where object_type = 'DIRECTORY';

dumpfile
指定dump檔案 預設是expdat.dmp

EXTIMATE
指定估算被匯出表所佔用磁碟空間分方法。預設值是BLOCKS
EXTIMATE={BLOCKS | STATISTICS}
設定為BLOCKS時，oracle會按照目標物件所佔用的資料塊個數乘以資料塊尺寸估算物件佔用的空間，
設定為STATISTICS時，根據最近統計值估算物件佔用空間
Expdp scott/tiger TABLES=emp ESTIMATE=STATISTICS
DIRECTORY=dump DUMPFILE=a.dump

filesize
指定匯出檔案的最大尺寸，預設為0，（表示檔案尺寸沒有限制）

FLASHBACK_SCN
指定匯出特定SCN時刻的表資料
FLASHBACK_SCN=scn_value

FLASHBACK_TIME
指定匯出特定時間點的表資料
FLASHBACK_TIME=TO_TIMESTAMP（time_value）

NETWORK_LINK
指定資料庫鏈名，如果要將遠端資料庫物件匯出到本地例程的轉儲檔案中，必須設定該選項。

TABLES
指定匯出的表
TABLES=[schema_name.]table_name[：partition_name][，…]

TABLESPACES
指定要匯出表空間列表

SCHEMAS
該方案用於指定執行方案模式匯出，預設為當前使用者方案

 

 

 

 

 

 

 

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/16179598/viewspace-623643/，如需轉載，請註明出處，否則將追究法律責任。