Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: IMPORT Jump to:  
Category: >> Oracle PL/SQL >> IMPORT Bookmark and Share

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


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 215 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?