Schema compare does not include Triggers in its results (4242447)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Schema compare does not include Triggers in its results
Description

There is an issue with Schema Compare not returning Triggers in the results. When schema compare is run including just Triggers, it works fine. It can even run the compare with Triggers and some other objects, like packages, and it works fine too. However, if the compare is run with Triggers and Tables or Views, it does not return any triggers in its results.
Resolution

WORKAROUND:
Run two compares. The first one being just with Triggers selected. The second one being all the other objects you want compared. The sync script from the first run will cover Triggers and the second sync script will cover everything else.

STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
Defect ID

ST109333
Additional Information

This seems to mostly happen with APPS schema.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title