# ss64.par - EXPORT parameter file -

# Execute this par file with the command:
#   exp system/manager@sid parfile=ss64.par

##   Always Export data using the Export utility of
##   the lowest database version involved. 

# The file to hold the export(check disk space on this drive)
File=G:\sid\sid_live.dmp
Log=G:\sid\sid_live.log

# What to include
ROWS=Y
INDEXES=Y
Grants=Y
Constraints=Y
STATISTICS=COMPUTE

# Performance options
#  COMPRESS is not file compression,
#  it reorganises each table into one large extent
COMPRESS=N
Buffer=90000
DIRECT=Y

# How the export will run OWNER, TABLES or FULL?
OWNER=sid
# TABLES=t_accounts,t_account_balances
# FULL=n


##### Other Export Options (commented out) ################

# CONSISTENT   Provide cross-table read-consistency for the entire export: default is N
# FEEDBACK=x         Display progress every x rows (0)
# FILESIZE           Maximum size of each dump file (2000M, 1G)
# FILE_FORMAT        Format of export file names
# FLASHBACK_time     Database time to be used for flashback export: no default
# FLASHBACK_SCN      System change number (SCN) to be used for flashback export,
#                    used to set session snapshot back to. No default 
# FLASHBACK_TIME     Time used to get the SCN closest to the specified time
# HELP               Display descriptions on export parameters, default is N
# impparfile         File to create as paramfile for IMP for transportable 
# INCTYPE=           Incremental export option: (incremental, cumulative or complete)
#                    -- default is none
# OBJECT_CONSISTENT    Provides consistency for registered objects during execution of procedural callback 
#                (transaction set to read only during object export ): default is N
#
# point_in_time_recover	  Point-in-time recover option: default is N
# QUERY                Select clause used to export a subset of a table
# RECORD               Option to record incremental/cumulative export: default is Y
# RECORDLENGTH	       Record length of file: optional, default is system dependent
# RESUMABLE            Suspend when a space related error is encountered(N)
# enable resumable session : default is N
# RESUMABLE_NAME       Resumable string: SQL statements to be resumable
# RESUMABLE_TIMEOUT    Wait time for RESUMABLE 
# SILENT               Display banner information, default is N
# TTS_FULL_CHECK       Perform full or partial dependency check for TTS
# TRANSPORT_TABLESPACE Export transportable tablespace metadata (N)
# TEMPLATE             Template name which invokes iAS mode export
# TRACE	               Enable sql_trace and timed_stat, default is N
# TRIGGERS     export triggers (Y)
# tts_full_check       TTS perform strict test for objects in recovery set: default is N
# USERID               user/password to connect to oracle: no default


# Note Generally you will run exports under SYSTEM or a specific DBA account.
# To run an export as SYSDBA: 

# Windows -
#   exp 'sys/change_on_install@sid as sysdba' parfile=ss64.par

# Unix - escape quote \'
#   exp \'sys/change_on_install@sid as sysdba\' parfile=ss64.par

# VMS - double_quote - single_quote
#   exp "'sys/change_on_install@sid as sysdba'" parfile=ss64.par