티스토리 뷰
출처 : 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 |
'Dev > Oracle' 카테고리의 다른 글
[펌] oracle table 관련 구문 (0) | 2007.10.26 |
---|---|
[펌] oracle tablespace 관련 구문 (0) | 2007.10.11 |
[펌] oracle update 구문 (1) | 2007.10.01 |
[펌] Logging Localized Message [메시지 로깅] (0) | 2007.08.22 |
[펌] oracle : connect by ~ start with ~ (0) | 2007.01.03 |
댓글
최근에 올라온 글
최근에 달린 댓글
- Total
- Today
- Yesterday
TAG
- 금연
- connect by
- 낭패
- 안드로이드 앱
- iBATIS
- 오라클
- 출근길
- 충동구매
- 출근
- 무료 프로그램
- ubuntu
- 헌혈
- oracle
- 바이크
- 일하는 곳
- EditPlus
- 최대 메모리
- 액땜
- 윈도우
- Git
- 정부과천청사
- Eclipse
- VMware
- 법무부
- 짜증
- GB-P100
- Java
- 김용
- 프로젝트
- 파워콤해지
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |
글 보관함