Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Do a Full Database Export?

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/globalguideline 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:ORACLEXEAPPORACLEADMINXEDPDUMPEXPDAT.DMP

Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed

 126 views

More Questions for you: