Preserve scripts, statistics and analysis information before uninstall/reinstall (4311329)

Before upgrading Space Manager you want to make sure that none of your history is lost. Upgrading Space Manager Server Side Objects WILL preserve all these objects but sometimes you need to deinstall these objects before reinstalling them.

Use the following export parameter file. Replace username "quest" with the installing user for Space Manager objects.

exp parfile=spc_exp.ctl file=spc.dmp log=spc_exp.log

# -- beginnning of file spc_exp.ctl
userid = quest
tables = (quest_script, quest_script_statement, quest_script_history,
quest_spc_analysis_group, quest_spc_analysis_error,
quest_spc_long_col_stat, quest_spc_stat)
grants = N
indexes = N
rows = Y
constraints = N
statistics = none
# -- end of file spc_exp.ctl