Compare User Objects: Trigger can result in ORA-04095

[Bernhard S]

When you compare two schemas using PSDs Compare User Objects with Trigger of the same name in both schemas, but on different tables, with applying changes from one schema to another you get an error ORA-04095: trigger '[TR]' already exists on another table, cannot replace it.
PSDs adaption code just consists of a:

CREATE OR REPLACE TRIGGER [TR] ...

In such cases however it's necessary to drop the existing trigger on the wrong table first before being able to create the new on on the correct table.

BTW: What is your current schedule for releasing PSD 9.0 ?

 

[Marco Kalter]

We'll see how we can safely handle this situation. Dropping triggers on other tables might not always be the right course of action.

We have a beta version for 9.0 planned for this quarter.

 

[Bernhard S]

This issue still exists in the latest PSD version 9.0.1.1612