PL/SQL Developer 10 - "Compare User Objects..." - triggers

[Andrew Lacwik]

PL/SQL Developer version 10.0.1.1694
When "Compare User Objects" triggers are prefixed with schema name. For example, I compare two schemas: COMMON_1 and COMMON_2. All trigger names are prefixed in "Compare User Objects..." with schema name like this (trigger TriggerTest) -

 

[Marco Kalter]

Are you connected as the owner of the triggers?

 

[Andrew Lacwik]

Yes, I am connected as the owner of the triggers.
Are you going to fix it in the next build? Please let us know.
Now when I compare 2 schemas there is a lot of tables with triggers on the differences list - in fact tables are identical in both schemas.
Generated script lists the triggers to be dropped in target schema, and
those triggeres should not be dropped!!!

 

[Marco Kalter]

We'll check it out.

 

[Bernhard S]

Any idea when this problem will be fixed? It's quite annoying.

 

[Marco Kalter]

We have not yet been able to reproduce the schema prefix issue.

The dropped trigger issue will be resolved in 10.0.3. A pre-release of this fix is available here.

 

[AdamG]

I've noticed that schema prefix issue has something in common how oracle stores trigger definition. For some unknown reason, when I do select description from user_triggers I get some triggers in normal format like t_my_trigger before insert.... but some of them are stored with schema owner like "SCOTT".t_my_trigger before insert....
Maybe it will give some light on problem.

 

[Bernhard S]

The pre-release fix does indeed solve the dropped trigger issue. Thank you for the quick fix.

 

[Andrew Lacwik]

However, the pre-release version still generates schema prefixes in triggers. It causes the problem when schema names to compare are different:
- compare identical triggers in schema_A and schema_B:
schema_A.Test schema_B.Test
Triggers are identical - however, trigger Test is included to the list of different objects and it should not...