출처 : http://www.psoug.org/reference/export.html
다음 내용은 최신버전이 아닐 수 있습니다. 최신의 글은 위 사이트를 참조하세요.
다음 내용은 최신버전이 아닐 수 있습니다. 최신의 글은 위 사이트를 참조하세요.
| 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:\temp\uw_test.dmp | |
| Log File Name | exp userid=<schema_owner/password> LOG=<file_name> |
| exp uwclass/uwclass log=c:\temp\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:\temp\cnsstnt.dmp consistent=Y | |
| Constraints (default is Y) | exp userid=<schema_owner/password> CONSTRAINTS=<Y|N> |
| exp uwclass/uwclass file=c:\temp\cnstrnt.dmp constraints=N | |
| Direct Path (default is N) | exp userid=<schema_owner/password> DIRECT=<Y|N> |
| exp uwclass/uwclass file=c:\temp\dirpath.dmp direct=Y | |
| Feedback (default is 0) | exp userid=<schema_owner/password> FEEDBACK=<integer DEFAULT 0> |
| exp uwclass/uwclass file=c:\temp\fback.dmp feedback=100 | |
| File Size (default unlimited) | exp userid=<schema_owner/password> FILESIZE=<integer> [KB|MB] |
| exp uwclass/uwclass file=c:\temp\fsize.dmp filesize 100MB | |
| Flashback By SCN | exp userid=<schema_owner/password> FLASHBACK_SCN=<SCN> |
| exp uwclass/uwclass file=c:\temp\fbscn.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:\temp\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 | |
'Programming > 오라클' 카테고리의 다른 글
| [펌] oracle table 관련 구문 (0) | 2007/10/26 |
|---|---|
| [펌] oracle tablespace 관련 구문 (0) | 2007/10/11 |
| [펌] oracle update 구문 (1) | 2007/10/01 |
| [펌] oracle export 관련 구문 (0) | 2007/09/02 |
| [펌] Logging Localized Message [메시지 로깅] (0) | 2007/08/22 |
| [펌] oracle : connect by ~ start with ~ (0) | 2007/01/03 |
댓글을 달아 주세요