Thursday, July 25, 2013

ORACLE - Expdp estimate_only with compression

How to find expdp dump size ?

expdp oper/oper schemas=JX_2011_1 estimate_only=y

Export: Release 11.2.0.3.0 - Production on Wed Mar 20 12:28:05 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Starting "OPER"."SYS_EXPORT_SCHEMA_01":  oper/******** schemas=JX_2011_1 estimate_only=y
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
.  estimated "JX_2011_1"."M_TICKET_HIST"              32.49 GB
.  estimated "JX_2011_1"."M_EXECUTION"                11.31 GB
.  estimated "JX_2011_1"."M_BLOCK_EXECUTION"          5.703 GB
.  estimated "JX_2011_1"."M_BLOCK"                      848 MB
.  estimated "JX_2011_1"."HV_TRADE_REPORT"              816 MB
.  estimated "JX_2011_1"."M_TICKET_CHARGES_HIST"         30 MB
.  estimated "JX_2011_1"."TICKETS_MXE_JAN_2011"           2 MB
.  estimated "JX_2011_1"."M_SESSION"                     64 KB
.  estimated "JX_2011_1"."OPTION_PARTIES"                 0 KB
.  estimated "JX_2011_1"."OPTION_TRADES"                  0 KB
Total estimation using BLOCKS method: 51.17 GB
Job "OPER"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:28:17

expdp oper/oper schemas=JX_2011_1  compression=all estimate_only=y

Export: Release 11.2.0.3.0 - Production on Wed Mar 20 12:28:30 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Starting "OPER"."SYS_EXPORT_SCHEMA_01":  oper/******** schemas=JX_2011_1 compression=all estimate_only=y
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
.  estimated "JX_2011_1"."M_TICKET_HIST"              32.49 GB
.  estimated "JX_2011_1"."M_EXECUTION"                11.31 GB
.  estimated "JX_2011_1"."M_BLOCK_EXECUTION"          5.703 GB
.  estimated "JX_2011_1"."M_BLOCK"                      848 MB
.  estimated "JX_2011_1"."HV_TRADE_REPORT"              816 MB
.  estimated "JX_2011_1"."M_TICKET_CHARGES_HIST"         30 MB
.  estimated "JX_2011_1"."TICKETS_MXE_JAN_2011"           2 MB
.  estimated "JX_2011_1"."M_SESSION"                     64 KB
.  estimated "JX_2011_1"."OPTION_PARTIES"                 0 KB
.  estimated "JX_2011_1"."OPTION_TRADES"                  0 KB
Total estimation using BLOCKS method: 51.17 GB
Job "OPER"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:28:34

No comments:

Post a Comment