使用datapump估算导出将占用的磁盘空间大小

使用estimate_only参数来估计导出作业将消耗多少空间 ，expdp将在在不执行导出的情况下计算作业估计值。[@more@]

SQL> conn system/xxxxx
Connected.
SQL> desc dba_directories
Name Null? Type
--------------------------------- -------- ------------------------------------------------
OWNER NOT NULL VARCHAR2(30)
DIRECTORY_NAME NOT NULL VARCHAR2(30)
DIRECTORY_PATH VARCHAR2(4000)

SQL> col directory_path for a60
SQL> set linesize 130
SQL> select * from dba_directories;

OWNER DIRECTORY_NAME DIRECTORY_PATH
---------- -----------------------------------------------------------------------------
SYS DPDATA /data/dbbak/expbak

SQL> grant read,write on directory dpdata to aaa,bill,cash;

Grant succeeded.

SQL> select job_name,state from dba_datapump_jobs;

JOB_NAME STATE
------------------------------ ------------------------------
SYS_EXPORT_SCHEMA_01 EXECUTING

SQL> col owner_name for a10
SQL> col operation for a20
SQL> col state for a10
SQL> set linesize 130
SQL> select owner_name,job_name,operation,state from dba_datapump_jobs;

OWNER_NAME JOB_NAME OPERATION STATE
---------- ------------------------------ -------------------- ----------
SYSTEM SYS_EXPORT_SCHEMA_01 EXPORT COMPLETING

$expdp system/xxxxx schemas=bill,cash,aaa directory=DPDATA ESTIMATE_ONLY=y logfile=estimate.log
Export: Release 10.2.0.1.0 - 64bit Production on Tuesday, 19 December, 2006 10:08:43

Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** schemas=bill,cash,aaa directory=DPDATA ESTIMATE_ONLY=y logfile=estimate.l
og
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. estimated "BILL"."USAGE_CHARGE" 6.125 GB
. estimated "BILL"."DDI_TICKET_TOLL1000_1019" 1.75 GB
. estimated "BILL"."DDI_TICKET_TOLL1000_1022":"DDI_TICKET_TOLL1000_1022_1" 1.75 GB
. estimated "BILL"."DDI_TICKET_TOLL1000_1021":"DDI_TICKET_TOLL1000_1021_1" 1.625 GB
. estimated "BILL"."DDI_TICKET_TOLL1000_1020":"DDI_TICKET_TOLL1000_1020_1" 1.562 GB
. estimated "BILL"."DDI_TICKET_TOLL1000_1023":"DDI_TICKET_TOLL1000_1023_1" 1.562 GB
. estimated "BILL"."DDI_TICKET_TOLL1000_1018" 1.25 GB
. estimated "BILL"."DDI_TICKET_SETTLEMENT_1018" 1.062 GB
. estimated "BILL"."DDI_LACKDOC1000_0403" 736 MB
. estimated "BILL"."DDI_TICKET_TOLL1000_1024":"DDI_TICKET_TOLL1000_1024_1" 710 MB
. estimated "AAA"."USER_INFO" 632 MB
. estimated "BILL"."DDI_TICKET_TOLL1000_1017":"DDI_TICKET_TOLL1000_1017_1" 608 MB
. estimated "BILL"."DDI_TICKET_SETTLEMENT_1017" 496 MB
. estimated "BILL"."DDI_ABNORMAL1000" 464 MB
. estimated "BILL"."FILE_PRESENT_LOG_2005" 416 MB
. estimated "BILL"."DDI_TICKET_TOLL1000_1025":"DDI_TICKET_TOLL1000_1025_1" 389 MB
. estimated "BILL"."DDI_TICKET_TOLL1000_1021_79" 344 MB
. estimated "BILL"."DDI_TICKET_TOLL1000_1026":"DDI_TICKET_TOLL1000_1026_1" 328 MB
. estimated "BILL"."DDI_TICKET_TOLL1000_1027":"DDI_TICKET_TOLL1000_1027_1" 304 MB
. estimated "BILL"."DDI_TICKET_TOLL1000_1028":"DDI_TICKET_TOLL1000_1028_1" 288 MB
. estimated "BILL"."FILE_PRESENT_LOG" 256 MB
. estimated "BILL"."DDI_TICKET_TOLL1000_1029":"DDI_TICKET_TOLL1000_1029_1" 240 MB
. estimated "BILL"."DDI_TICKET_TOLL1000_1030":"DDI_TICKET_TOLL1000_1030_1" 240 MB
......
......
......
. estimated "CASH"."VMQ_SQL_STATS_COST_FIRST" 0 KB
. estimated "CASH"."VMQ_SQL_STATS_RULE" 0 KB
. estimated "CASH"."VMQ_SQL_TEXT" 0 KB
. estimated "CASH"."VMQ_SQL_UNQUALIFIED_NAMES" 0 KB
. estimated "CASH"."VOICE_CODING" 0 KB
. estimated "CASH"."VOICE_ITEM_TYPE" 0 KB
. estimated "CASH"."WITHDRAW_INFO" 0 KB
. estimated "CASH"."WORK_ORDER" 0 KB
. estimated "CASH"."WORK_ORDER_263" 0 KB
Total estimation using BLOCKS method: 26.79 GBJob "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 10:22:53

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

转载于:http://blog.itpub.net/7794469/viewspace-884789/