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

<< lastnext >>

Snippet Name: EXPORT

Description: An example of using Oracle's EXPORT functionality.

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 01st, 2009

EXP 
     USERID=system/manager
     BUFFER=
     FILE=dba.dmp
     GRANTS=Y     -- default
     INDEXES=Y     -- default
     ROWS=          -- default
     CONSTRAINTS=Y     -- default
     COMPRESS=Y     -- default
     FULL=N          -- default
     OWNER=(x,y,z)     -- comma delimited list
     TABLES=(a,b,c)     -- comma delimited list
     RECORDLENGTH     -- only used when moving between operating systems
     INCTYPE=     -- valid values are COMPLETE, CUMULATIVE, & INCREMENTAL
               -- default is none
     HELP          -- displays help info
     PARFILE=     -- parameter file containing these items
     LOG=LOG.LOG     -- default is NONE
     CONSISTENT=N     -- default
     STATISTICS=     -- valid values are ESTIMATE, COMPUTE, & NONE
               -- default is NONE
 
EXP system/manager file=llink.dmp LOG=llink.LOG statistics=COMPUTE
 
SOLAR,LIVELINK,OPS\$ORACLE,OPS\$TECHINFO,POSTERHOUT,WWW_DBA,WWW_USER,AWHALEN,DOCDIST,MRASMUSSEN,KMACKEY,OTTER,VSTARK,SSOUTH,WEBSYS,PROJMAN,PROJMAN1
 
TO specify an OPS$ schema owner IN UNIX WRITE AS OPS\$xxxxxxxx


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 241 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?