################################################################
# DataPump Export Parameter File: RefreshSHTables.dpictl
#
# Imports data back into selected tables in the SH schema using
# the nightly disaster recovery export dump files as the data
# source. Note that:
# 1.) Multiple dump files will be utilized using the %U directive
# 2.) 3 tables in the SH schema are the only tables to be refreshed
# 3.) These tables will be truncated before loading
#
# Maintenance Log:
# 04-15-2005  JSC  Initial version
################################################################
DIRECTORY=export_dir
JOB_NAME=RefreshSHTables
DUMPFILE=export_dir:fulldb_%U.dmp
LOGFILE=export_dir:RefreshSHTables.implog
STATUS=30
CONTENT=DATA_ONLY
SCHEMAS=SH
INCLUDE=TABLE:"IN('COUNTRIES','CUSTOMERS','PRODUCTS','SALES')"
TABLE_EXISTS_ACTION=TRUNCATE