Perform a Full Database Export in Oracle

Q

How To Do a Full Database Export in Oracle?

✍: FYIcenter.com

A

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/**** FULL=y 
Estimate in progress using BLOCKS method...
Processing object DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 169.8 MB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
......
. . exported FLOWS_020100.WWV_FLOW_PAGE_PLUGS      32.51MB
. . exported FLOWS_020100.WWV_FLOW_STEP_ITEMS      21.68MB
. . exported FLOWS_020100.WWV_FLOW_STEP_PROCESSING 11.17MB
......
Master table "SYSTEM"."SYS_EXPORT_FULL_01" unloaded
**********************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
  C:\ORACLEXE\APP\ORACLE\ADMIN\XE\DPDUMP\EXPDAT.DMP
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed

 

Loading and Exporting Data in Oracle

⇒⇒Oracle Database Tutorials

2016-10-15, 178👍, 0💬