Disk Space Needed for an Export Job in Oracle

Q

How To Estimate Disk Space Needed for an Export Job in Oracle?

✍: FYIcenter.com

A

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

⇑ Loading and Exporting Data in Oracle

⇑⇑ Oracle Database Tutorials

2016-10-15, 3232🔥, 0💬

Where Is the Export Dump File Located in Oracle
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and file name, the dump file will be stored in the default dump directory with the default file name. The tutorial exercise below tells you find what is your default dump directory and locate the dump file.... 2016-10-15, 5447🔥, 0💬

Disk Space Needed for an Export Job in Oracle
How To Estimate Disk Space Needed for an Export Job in Oracle? 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 d... 2016-10-15, 3233🔥, 0💬

Perform a Full Database Export in Oracle
How To Do a Full Database Export in Oracle? If you are ready to do a full database export, you can use the FULL=y parameter on the expdp command, as shown in the following tutorial exercise: >expdp SYSTEM/fyicenter FULL=y ESTIMATE_ONLY=y Starting "SYSTEM"."SYS_EXPORT_FULL_01": SYSTEM/**** FUL... 2016-10-15, 3183🔥, 0💬

Invoke the Data Pump Export Utility in Oracle
How To Invoke the Data Pump Export Utility in Oracle? The Data Pump Export utility is distributed as executable file called "expdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "expdp" command. Here is tutorial exercise on how to in... 2016-10-15, 3001🔥, 0💬

Invoke the Data Pump Import Utility in Oracle
How To Invoke the Data Pump Import Utility in Oracle? The Data Pump Import utility is distributed as executable file called "impdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "impdp" command. Here is tutorial exercise on how to in... 2016-10-15, 2960🔥, 0💬

Export Your Own Schema in Oracle
How To Export Your Own Schema in Oracle? If you have a non-system user account and you want to export all data objects in the schema associated with your account, you can use the "expdp" command with the SCHEMAS parameter. Running "expdp" command with a non-system user account requires a directory o... 2016-10-15, 2938🔥, 0💬

Modes of Data Dump Export and Import in Oracle
What Are Data Pump Export and Import Modes in Oracle? Data Pump export and import modes are used to determine the type and portions of database to be exported and imported. Oracle 10g supports 5 export and import modes: Full: Exports and imports a full database. Use the FULL parameter to specify thi... 2016-10-15, 2930🔥, 0💬

Data Pump Export Utility in Oracle
What Is the Data Pump Export Utility in Oracle? Oracle Data Pump Export utility is a standalone programs that allows you to export data objects from Oracle database to operating system files called dump file set, which can be imported back to Oracle database only by Oracle Data Pump Import utility. ... 2016-10-15, 2803🔥, 0💬

Export Several Tables Together in Oracle
How To Export Several Tables Together in Oracle? If you don't want to export the entire schema and only want to export several tables only, you can use the "expdp" command with the "TABLES" parameter as shown in the following tutorial exercise: >cd \oraclexe\app\oracle\product\1 0.2.0\server\B... 2016-10-15, 2789🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.