使用expdp导出命令时,通常需要评估导出文件的大小来作为空间是否足够的依据,
特别是在做全库导出的场景中。
设置参数estimate_only=y|n 来指定是否仅做评估而不导数据
设置参数estimate=statistic 根据最近统计值估算对象占用空间
测试过程如下:
[oracle@hisdb1:/home/oracle]$ expdp ‘/ as sysdba’ full=y estimate_only=y estimate=statistics
Export: Release 11.2.0.4.0 - Production on Fri Feb 18 16:20:27 2022
Copyright © 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting “SYS”.“SYS_EXPORT_FULL_01”: “/******** AS SYSDBA” full=y estimate_only=y estimate=statistics
Estimate in progress using STATISTICS method…
. estimated “SYSTEM”.“REPCAT
R
E
S
O
L
U
T
I
O
N
S
T
A
T
I
S
T
I
C
S
"
0
K
B
.
e
s
t
i
m
a
t
e
d
"
S
Y
S
T
E
M
"
.
"
R
E
P
C
A
T
_RESOLUTION_STATISTICS" 0 KB . estimated "SYSTEM"."REPCAT
RESOLUTIONSTATISTICS"0KB.estimated"SYSTEM"."REPCAT_RESOL_STATS_CONTROL” 0 KB
. estimated “SYSTEM”.“REPCAT
R
U
N
T
I
M
E
P
A
R
M
S
"
0
K
B
.
e
s
t
i
m
a
t
e
d
"
S
Y
S
T
E
M
"
.
"
R
E
P
C
A
T
_RUNTIME_PARMS" 0 KB . estimated "SYSTEM"."REPCAT
RUNTIMEPARMS"0KB.estimated"SYSTEM"."REPCAT_SITES_NEW” 0 KB
. estimated “SYSTEM”.“REPCAT
S
I
T
E
O
B
J
E
C
T
S
"
0
K
B
.
e
s
t
i
m
a
t
e
d
"
S
Y
S
T
E
M
"
.
"
R
E
P
C
A
T
_SITE_OBJECTS" 0 KB . estimated "SYSTEM"."REPCAT
SITEOBJECTS"0KB.estimated"SYSTEM"."REPCAT_SNAPGROUP” 0 KB
. estimated “SYSTEM”.“REPCAT
T
E
M
P
L
A
T
E
O
B
J
E
C
T
S
"
0
K
B
.
e
s
t
i
m
a
t
e
d
"
S
Y
S
T
E
M
"
.
"
R
E
P
C
A
T
_TEMPLATE_OBJECTS" 0 KB . estimated "SYSTEM"."REPCAT
TEMPLATEOBJECTS"0KB.estimated"SYSTEM"."REPCAT_TEMPLATE_PARMS” 0 KB
. estimated “SYSTEM”.“REPCAT
T
E
M
P
L
A
T
E
R
E
F
G
R
O
U
P
S
"
0
K
B
.
e
s
t
i
m
a
t
e
d
"
S
Y
S
T
E
M
"
.
"
R
E
P
C
A
T
_TEMPLATE_REFGROUPS" 0 KB . estimated "SYSTEM"."REPCAT
TEMPLATEREFGROUPS"0KB.estimated"SYSTEM"."REPCAT_TEMPLATE_SITES” 0 KB
. estimated “SYSTEM”.“REPCAT
T
E
M
P
L
A
T
E
T
A
R
G
E
T
S
"
0
K
B
.
e
s
t
i
m
a
t
e
d
"
S
Y
S
T
E
M
"
.
"
R
E
P
C
A
T
_TEMPLATE_TARGETS" 0 KB . estimated "SYSTEM"."REPCAT
TEMPLATETARGETS"0KB.estimated"SYSTEM"."REPCAT_USER_AUTHORIZATIONS” 0 KB
. estimated “SYSTEM”.“REPCAT$_USER_PARM_VALUES” 0 KB
. estimated “SYSTEM”.“SQLPLUS_PRODUCT_PROFILE” 0 KB
Total estimation using STATISTICS method: 29.25 MB
Job “SYS”.“SYS_EXPORT_FULL_01” successfully completed at Fri Feb 18 16:20:42 2022 elapsed 0 00:00:14