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 |