Onwer name missed when export user objects

[Ameen]

Hello again.
when export a trigger with (include owner) option:

prompt
prompt Creating trigger BUDGET_LITEMS_AINS_TRAN
prompt ========================================
prompt
CREATE OR REPLACE TRIGGER BUDG.BUDGET_LITEMS_AINS_TRAN AFTER INSERT ON BUDGET_LITEMS FOR EACH ROW BEGIN..... END;
/

the schema name (owner) "BUDG" does not exist before table-name (... ON BUDGET_LITEMS FOR ...) but exist before the trigger name only.

This error could have a relation with previous error I have posted that explain how export user object duplicate owner name in some cases (triggers too).

 

[Marco Kalter]

We'll check it out.

 

[Ameen]

This bug still exist in 11.03

 

[Ameen]

Sadly This bug still exist in 11.04

 

[Ameen]

The following case could help you:

if I leave (target schema) option blank, and the current connected user is different from table-owner, then table-name should preceded by its owner name.

if I put a name in (target schema) option, then table-name should preceded by this name even if it is different from owner-name.

if I leave (target schema) option blank, and the current connected user is the table-owner itself, then no need to add owner-name.

This is useful for me when I connect as SYS or as the owner itself in order to generate a script that is install-able in 2 cases.

 

[Ameen]

Sadly this error still exists in v11.06 !!!