Oracle 9i intorudcuces functionality to rename table columns online (alter table rename column). Shareplex does not support Alter Table rename column
Use this procedure if you are only renaming a source table in an active configuration.
1 Run sp_ctrl.
2 Copy the active configuration, but do not deactivate it. Use the show config or list
config command if you are unsure of the name.
sp_ctrl(sysA)> copy config filename to newname
3 Open the new configuration using the edit config command. This command opens
the configuration file in the default text editor for SharePlex (vi for UNIX, WordPad
for Windows).
sp_ctrl(sysA)> edit config newname
4 Edit the new configuration to change the name of the source table.
5 Save the new configuration with either the :wq command if using vi or with Save on
the File menu if using WordPad.
6 Stop user access to the table.
7 Rename the source table in Oracle.
8 In sp_ctrl, activate the new configuration using default multi-threaded activation.
sp_ctrl(sysA)> activate config newname
9 Restore user access to the table.
