Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Do a Full Database Export
How To Do a Full Database Export? - Oracle DBA FAQ - Loading and Exporting Data
✍: FYIcenter.com
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
2007-05-01, 4750👍, 0💬
Popular Posts:
What are the two fundamental objects in ADO.NET ? Datareader and Dataset are the two fundamental obj...
Can Java object be locked down for exclusive use by a given thread? Yes. You can lock an object by p...
What CLASSPATH Settings Are Needed to Run JUnit? It doesn't matter if you run your JUnit tests from ...
Does there exist any other function which can be used to convert an integer or a float to a string? ...
what are the advantages of hosting WCF Services in IIS as compared to self hosting? There are two ma...