티스토리 뷰
출처 : http://www.psoug.org/reference/import.html
다음 내용은 최신 버전이 아닐 수 있습니다. 최신 버전은 위 사이트를 참조하세요.
다음 내용은 최신 버전이 아닐 수 있습니다. 최신 버전은 위 사이트를 참조하세요.
Importing Schemas | |
Note: Deprecated ... replaced by DataPump | |
Import help | imp -help |
imp -help | |
Import Authority | imp userid=<schema_owner/password> |
imp uwclass/uwclass | |
Import File Name | imp userid=<schema_owner/password> FILE=<file_name> |
imp uwclass/uwclass file=c:\temp\uw_test.dmp | |
Log File Name | imp userid=<schema_owner/password> LOG=<file_name> |
imp uwclass/uwclass log=c:\temp\uw.log | |
Buffer Size | -- O/S dependent and can usually be ignored imp userid=<schema_owner/password> BUFFER=<integer> |
-- rows_in_array * maximum_row_size imp uwclass/uwclass buffer=64000 |
|
Commit | imp userid=<schema_owner/password> COMMIT=<Y|N> |
imp uwclass/uwclass commit=Y | |
Compile | imp userid=<schema_owner/password> COMPILE=<Y|N> |
imp uwclass/uwclass compile=N | |
Constraints | imp userid=<schema_owner/password> CONSTRAINTS=<Y|N> |
imp uwclass/uwclass constraints=N | |
Data Files | imp userid=<schema_owner/password> DATAFILES=(df1, df2, ... df#) |
imp uwclass/uwclass datafiles=(c:\oradata\datasml1.dbf') | |
Destroy | imp userid=<schema_owner/password> DESTROY=<Y|N> |
imp uwclass/uwclass destroy=Y | |
Feedback | imp userid=<schema_owner/password> FEEDBACK=<integer DEFAULT 0> |
imp uwclass/uwclass feedback=100 | |
File Size | -- if used in exporting must match export specification imp userid=<schema_owner/password> FILESIZE=<integer> [KB|MB] |
imp uwclass/uwclass filesize 100MB | |
From User | imp userid=<schema_owner/password> FROMUSER=<schema_name> |
imp uwclass/uwclass fromuser=uwclass touser=abc | |
Full | imp userid=<schema_owner/password> FULL=<Y|N> |
imp uwclass/uwclass full=N | |
Grants | imp userid=<schema_owner/password> GRANTS=<Y|N> |
imp uwclass/uwclass grants=N | |
Ignore | imp userid=<schema_owner/password> IGNORE=<Y|N> |
imp uwclass/uwclass ignore=Y | |
Indexes | imp userid=<schema_owner/password> INDEXES=<Y|N> |
imp uwclass/uwclass indexes=N | |
Index File | -- creates a file of index creation statements: INDEXES parameter -- must be N imp userid=<schema_owner/password> INDEXFILE=<file_name> |
imp uwclass/uwclass indexfile=c:\temp\index_dml.sql | |
Parameter File | imp userid=<schema_owner/password> PARFILE=<parameter_file_name> |
imp uwclass/uwclass parfile=c:\temp\uwparfile.ctl | |
Record Length | imp userid=<schema_owner/password> RECORDLENGTH=<bytes> |
imp uwclass/uwclass recordlength=32000 | |
Resumable | imp userid=<schema_owner/password> RESUMABLE=<Y|N> |
imp uwclass/uwclass resumable=Y | |
Resumable Name | imp userid=<schema_owner/password> RESUMABLE_NAME = 'User USERNAME (USERID), Session SESSIONID, Instance INSTANCEID' |
imp uwclass/uwclass resumable_name 'UWCLASS' | |
Resumable Timeout | imp userid=<schema_owner/password> RESUMABLE_TIMEOUT=<seconds> DEFAULT 7200 (2 hours) |
imp uwclass/uwclass resumable_timeout=18000 | |
Rows | imp userid=<schema_owner/password> ROWS=<Y|N> |
imp uwclass/uwclass rows=N | |
Show | imp userid=<schema_owner/password> SHOW=<Y|N> |
imp uwclass/uwclass show=Y | |
Skip Unusable Indexes | -- default is parameter from spfile imp userid=<schema_owner/password> SKIP_UNUSABLE_INDEXES=<Y|N> |
imp uwclass/uwclass skip_unusable_indexes=N | |
Statistics | imp userid=<schema_owner/password> STATISTICS=<ALWAYS | NONE | RECALCULATE | SAFE> |
imp uwclass/uwclass statistics=RECALCULATE | |
Streams Configuration | imp userid=<schema_owner/password> STREAMS_CONFIGURATION=<Y|N> |
imp uwclass/uwclass streams_configuration=N | |
Streams Instantiation | imp userid=<schema_owner/password> STREAMS_INSTANTIATION=<Y|N> |
imp uwclass/uwclass streams_instantiation=Y | |
Tables | imp userid=<schema_owner/password> TABLES=(t1, t2, ... t#) |
imp uwclass/uwclass tables=(emp, dept, bonus) | |
Tablespaces | imp userid=<schema_owner/password> TABLES=(t1, t2, ... t#) |
imp uwclass/uwclass tables=(emp, dept, bonus) | |
Table Object ID No Validate | imp userid=<schema_owner/password> TOID_NOVALIDATE=([schemaname.]typename [, ...]) |
imp uwclass/uwclass TABLE=jobs TOID_NOVALIDATE=typ1 | |
To User | imp userid=<schema_owner/password> TOUSER=<schema_name> |
imp uwclass/uwclass fromuser=uwclass touser=abc | |
Transport Tablespace | imp userid=<schema_owner/password> TRANSPORT_TABLESPACE=<Y|N> |
imp uwclass/uwclass transport_tablespace=Y | |
TTS Owners | imp userid=<schema_owner/password> TTS_OWNERS=(o1, o2, ... o#) |
imp uwclass/uwclass tts_owners=(uwclass, ids) | |
Volume Size | imp userid=<schema_owner/password> VOLSIZE <integer> [KB|MB|GB] |
imp uwclass/uwclass volsize=10GB | |
Write DDL From DMP file | imp userid=<schema_owner/password> full=Y show=Y 2>path_and_file |
imp uwclass/uwclass
file=c:\temp\uwclass.dmp full=Y show=Y 2> c:\temp\uwclass.sql |
'Dev > Oracle' 카테고리의 다른 글
[펌] oralce analyze 관련 구문 (0) | 2009.02.25 |
---|---|
[펌] oracle procedure 관련 (0) | 2008.02.01 |
[펌] oracle table 관련 구문 (0) | 2007.10.26 |
[펌] oracle tablespace 관련 구문 (0) | 2007.10.11 |
[펌] oracle update 구문 (1) | 2007.10.01 |
댓글
최근에 올라온 글
최근에 달린 댓글
- Total
- Today
- Yesterday
TAG
- 액땜
- ubuntu
- Eclipse
- 윈도우
- 프로젝트
- iBATIS
- 법무부
- 낭패
- 출근
- 헌혈
- EditPlus
- 안드로이드 앱
- 짜증
- 금연
- VMware
- 충동구매
- 최대 메모리
- Git
- 파워콤해지
- Java
- 바이크
- GB-P100
- 김용
- 무료 프로그램
- 오라클
- oracle
- 출근길
- 일하는 곳
- 정부과천청사
- connect by
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
글 보관함