Renaming tables
You can use the ALTER TABLE RENAME command to rename a table. If the table is
in replication, SharePlex changes the name of the table in the active configuration file
by commenting out the old configuration line and adding a new line. If the target table
name is the same as the source table name, the new configuration line will reflect the
name change on both the source and target. Otherwise, the target name will not change.
For example, the source table, scott.table1, is replicating to scott.table1 on the target.
scott.table1 ====> scott.table1
If you rename the source table to scott.table2, the target table name will also change to
scott.table2.
scott.table2 ====> scott.table2
Capture will comment out the old entry in the configuration file by putting a pound sign
(#) in the first byte of the line, which might overwrite part of the name.
#scott.table1 scott.table1 sysA@o.ora555
Then a new entry is added to the end of the configuration file as follows:
# Table scott.table1 renamed to scott.table2 August 5, 2003 10:14
scott.table2 scott.table2 sysA@o.ora555
Renaming the source table can cause an error on the target if scott.table1 does not exist
on the target. Whether the Post process stops or not depends on the setting of the
SP_OPO_STOP_ON_DDL_ERR parameter. Refer to Chapter 2 in the SharePlex Reference
Guide for more information about this parameter.
