Snippet Name: IMPORT
Description: An example of using Oracle's IMPORT functionality.
Comment: (none)
Language:
Highlight Mode: PLSQL
Last Modified: March 01st, 2009
|
IMP
USERID=system/manager
BUFFER= -- operating system dependant
FILE=export.dmp
SHOW=N -- default (if Y lists but does not import)
IGNORE=N -- default (Y ignores creation errors)
GRANTS=Y -- default
INDEXES=Y -- default
ROWS=Y -- default
FULL=N -- default
FROMUSER=fuser
TOUSER=tuser
TABLES=(x,y,z) -- comma delimited list
RECORDLENGTH -- only required if changing operating systems
INCTYPE -- default undefined (valid values are SYSTEM & RESTORE)
COMMIT=Y -- default is N
HELP -- default is N, displays help
PARFILE=parfile.SQL -- parameter file
LOG=implog.LOG
DESTROY=N -- check this one out before importing
INDEXFILE -- default is NONE
imp USERID=system/attwsys FILE=llink8.dmp FROMUSER=livelink TOUSER=livelink LOG=llink8.LOG
|