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