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

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


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