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, 4789👍, 0💬
Popular Posts:
How To Use an Array as a Queue? - PHP Script Tips - PHP Built-in Functions for Arrays A queue is a s...
Does .NET support UNICODE and how do you know it supports? Yes .NET definitely supports UNICODE. Try...
How To Join a List of Keys with a List of Values into an Array? - PHP Script Tips - PHP Built-in Fun...
How to make elements invisible? Change the "visibility" attribute of the style object associated wit...
.NET INTERVIEW QUESTIONS - How to prevent my .NET DLL to be decompiled? By design .NET embeds rich M...