CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle Import Utility
Version 10.2
 
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: emp\uw_test.dmp
Log File Name imp userid=<schema_owner/password> LOG=<file_name>
imp uwclass/uwclass log=c: emp\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: emp\index_dml.sql
Parameter File imp userid=<schema_owner/password> PARFILE=<parameter_file_name>
imp uwclass/uwclass parfile=c: emp\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: emp\uwclass.dmp full=Y show=Y
2> c: emp\uwclass.sql
 
Related Topics
Data Pump
DBMS_TTS Built-in Package
Export
Tablespaces
Transportable Tablespaces
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [49 users online]    © 2010 psoug.org