Dropping and Recreating a Source Table

Dropping and recreating a source table requires caution when performed while Oracle GoldenGate is running.

1. Stop access to the table.

2. Allow Extract to process any remaining changes to that table from the transaction logs. To determine when Extract is finished, use the INFO EXTRACT command.

INFO EXTRACT *group*

1. Stop Extract.

STOP EXTRACT *group*

1. Drop and recreate the table.

2. If supported for this database, run the ADD TRANDATA command for the table.

3. If the recreate action changed the source table’s definitions so that they are different from those of the target, run the DEFGEN utility for the source table to generate source definitions, and then replace the old definitions with the new definitions in the existing source definitions file on the target system.

4. Permit user access to the table.