Quick Search:
 
 Oracle PL/SQL: IMPORT Jump to:  
Category: >> Oracle PL/SQL >> IMPORT  

<< lastnext >>

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
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org