Collections:
Disk Space Needed for an Export Job in Oracle
How To Estimate Disk Space Needed for an Export Job in Oracle?
✍: FYIcenter.com
If you just want to know how much disk space for the dump without actually exporting any data, you can use the ESTIMATE_ONLY=y parameter on the expdp command. The following tutorial exercise shows you how a system user wants to see the disk space estimates on a full database export:
>cd \oraclexe\app\oracle\product\10.2.0\server\BIN >expdp SYSTEM/fyicenter FULL=y ESTIMATE_ONLY=y Starting "SYSTEM"."SYS_EXPORT_FULL_01": SYSTEM/**** FULL=y ESTIMATE_ONLY=y Estimate in progress using BLOCKS method... Processing object DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA . estimated "FLOWS_020100"."WWV_FLOW_PAGE_PLUGS" 42 MB . estimated "FLOWS_020100"."WWV_FLOW_STEP_ITEMS" 27 MB . estimated "FLOWS_020100"."WWV_FLOW_STEP_PROCESSING" 16 MB ...... . estimated "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB . estimated "TSMSYS"."SRS$" 0 KB Total estimation using BLOCKS method: 169.8 MB Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed
Now you know that you need 170 MB disk space to export the entire data base.
Oracle also records the screen output in a log file called export.log at \oraclexe\app\oracle\admin\XE\dpdump.
⇒ Perform a Full Database Export in Oracle
⇐ Modes of Data Dump Export and Import in Oracle
2016-10-15, 1964🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...