출처 : 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 |
|
'Programming > 오라클' 카테고리의 다른 글
| [펌] oralce analyze 관련 구문 (0) | 2009/02/25 |
|---|---|
| [펌] oracle procedure 관련 (0) | 2008/02/01 |
| [펌] oracle import 관련 구문 (0) | 2007/11/22 |
| [펌] oracle table 관련 구문 (0) | 2007/10/26 |
| [펌] oracle tablespace 관련 구문 (0) | 2007/10/11 |
| [펌] oracle update 구문 (1) | 2007/10/01 |
댓글을 달아 주세요