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
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