| 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 |
