ORACLE 1Og expdp 跳过估算对象占用的空间 这部分

weiranth

刘大：

     操作系统：AIX 6.1 Oracle 版本：10.2.0.4     

     由于数据量比较大，想expdp到Linux 环境，在用expdp导出的时候想快点，节省点资源.

有没有什么办法可以跳过估算对象占用的空间这部分！.  

谢谢

Maclean Liu(刘相兵

ESTIMATE

Default: BLOCKS

Purpose

Specifies the method that Export will use to estimate how much disk space each table in the export job will consume (in bytes). The estimate is printed in the log file and displayed on the client's standard output device. The estimate is for table row data only; it does not include metadata.

Syntax and Description

ESTIMATE=[BLOCKS | STATISTICS]
BLOCKS - The estimate is calculated by multiplying the number of database blocks used by the source objects, times the appropriate block sizes.

STATISTICS - The estimate is calculated using statistics for each table. For this method to be as accurate as possible, all tables should have been analyzed recently. (Table analysis can be done with either the SQL ANALYZE statement or the DBMS_STATS PL/SQL package.)



try ESTIMATE=STATISTICS, but you can not skip estimate