Troubleshooting AdaptDDL Issues

This section describes common issues encountered when using AdaptDDL and provides recommended resolutions.

Index defined on a column in the target table

Issue

When an index (either functional or bitmap join) is defined on a column in the target table, and a DDL modifies that same column on the source, HVR attempts to apply the same modification to the target.

However, the operation fails because the index prevents the column modification, and Capture will fail with an error similar to the following:

F_JD20DB: DBMS error ORA-30556: either functional or bitmap join index is defined on the column to be modified.

Resolution

A preferred way to resolve this issue is to manually delete or disable the index on the target table, run Capture, and then recreate or rebuild the index.

Alternatively, you can instruct HVR to recreate the table when it encounters this issue by adding the Environment action with values:

• Name: "HVR_ALTER_TABLE_RECREATE_ERROR"
• Value: "*ORA-30556*"