CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle Export Utility
Version 10.2
 
Exporting Schemas
Note: Deprecated ... replaced by DataPump
 
Export help exp -help
exp -help
Export Authority exp userid=<schema_owner/password>
exp uwclass/uwclass
Export File Name exp userid=<schema_owner/password> FILE=<file_name>
exp uwclass/uwclass file=c: emp\uw_test.dmp
Log File Name exp userid=<schema_owner/password> LOG=<file_name>
exp uwclass/uwclass log=c: emp\uw.log
Buffer size -- O/S dependent and can usually be ignored

exp userid=<schema_owner/password> BUFFER=<integer>
-- rows_in_array * maximum_row_size

exp uwclass/uwclass buffer=64000
Compress (default is Y) -- The default is Y and it is best to override it.

exp userid=<schema_owner/password> COMPRESS=<Y|N>
exp uwclass/uwclass compress=N
Consistent (default is N) -- Implements SET TRANSACTION READ ONLY

exp userid=<schema_owner/password> CONSISTENT=<Y|N>
exp uwclass/uwclass file=c: emp\cnsstnt.dmp consistent=Y
Constraints (default is Y) exp userid=<schema_owner/password> CONSTRAINTS=<Y|N>
exp uwclass/uwclass file=c: emp\cnstrnt.dmp constraints=N
Direct Path (default is N) exp userid=<schema_owner/password> DIRECT=<Y|N>
exp uwclass/uwclass file=c: emp\dirpath.dmp direct=Y
Feedback (default is 0) exp userid=<schema_owner/password> FEEDBACK=<integer DEFAULT 0>
exp uwclass/uwclass file=c: emp back.dmp feedback=100
File Size (default unlimited) exp userid=<schema_owner/password> FILESIZE=<integer> [KB|MB]
exp uwclass/uwclass file=c: emp size.dmp filesize 100MB
Flashback By SCN exp userid=<schema_owner/password> FLASHBACK_SCN=<SCN>
exp uwclass/uwclass file=c: emp bscn.dmp flashback_scn=7632619
Flashback By Timestamp exp userid=<schema_owner/password> FLASHBACK_TIME=<timestamp>
exp uwclass/uwclass FLASHBACK_TIME="TIMESTAMP '2002-05-01 11:00:00'"

or

exp uwclass/uwclass flashback_time="TO_TIMESTAMP('12-02-2001 14:35:00', 'DD-MM-YYYY HH24:MI:SS')"
Full -- Yes requires the user to have the EXP_FULL_DATABASE role

exp userid=<schema_owner/password> FULL=<Y|N>
exp uwclass/uwclass full=Y
Grants exp userid=<schema_owner/password> GRANTS=<Y|N>
exp uwclass/uwclass grants=N
Indexes exp userid=<schema_owner/password> INDEXES=<Y|N>
exp uwclass/uwclass indexes=N
Object Consistent exp userid=<schema_owner/password> OBJECT_CONSISTENT=<Y|N>
exp uwclass/uwclass object_consistent=Y
Owner exp userid=<schema_owner/password> OWNER=(o1, o2, ... o#)
exp uwclass/uwclass owner=(uwclass, ids, webapps)
Parameter File exp userid=<schema_owner/password> PARFILE=<parameter_file_name>
exp uwclass/uwclass parfile=c: emp\uwparfile.ctl
Query exp userid=<schema_owner/password> QUERY=<query_string>
exp uwclass/uwclass owner=SCOTT tables=emp 
query=\" WHERE job=\'MANAGER\' AND sal \>50000\"
Record Length exp userid=<schema_owner/password> RECORDLENGTH=<bytes>
exp uwclass/uwclass recordlength=32000
Resumable exp userid=<schema_owner/password> RESUMABLE=<Y|N>
exp uwclass/uwclass resumable=Y
Resumable Name exp userid=<schema_owner/password> RESUMABLE_NAME = 'User USERNAME (USERID), Session SESSIONID, Instance INSTANCEID'
exp uwclass/uwclass resumable_name 'UWCLASS'
Resumable Time Out exp userid=<schema_owner/password> RESUMABLE_TIMEOUT=<seconds>
DEFAULT 7200 (2 hours)
exp uwclass/uwclass resumable_timeout=18000
Rows exp userid=<schema_owner/password> ROWS=<Y|N>
exp uwclass/uwclass rows=N
Statistics exp userid=<schema_owner/password>
STATISTICS=<ESTIMATE | COMPUTE | NONE>
exp uwclass/uwclass statistics=COMPUTE
Tables exp userid=<schema_owner/password> TABLES=(t1, t2, ... t#)
exp uwclass/uwclass tables=(emp, dept, bonus)
Tablespaces exp userid=<schema_owner/password> 
TABLESPACES=(tbsp1, tbsp2, ... tbsp#)
exp uwclass/uwclass tablespaces=(uwdata, user_data)
Transportable Tablespaces exp userid=<schema_owner/password> TRANSPORT_TABLESPACE <Y|N>
exp uwclass/uwclass transport_tablespace=Y
Triggers exp userid=<schema_owner/password> TRRIGGERS <Y|N>
exp uwclass/uwclass triggers=N
TTS Full Check exp userid=<schema_owner/password> TTS_FULL_CHECK <Y|N>
exp uwclass/uwclass tts_full_check=Y
Volume Size exp userid=<schema_owner/password> VOLSIZE <integer> [KB|MB|GB]
exp uwclass/uwclass volsize=10GB
 
Related Topics
Data Pump
DBMS_TTS Built-in Package
Import
Tablespaces
Transportable Tablespaces
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [101 users online]    © 2010 psoug.org