Duplicate owner name when export user objects

Ameen

Member²
Please remove this:

Viewing trigger text (connect as the owner BUDG):
CREATE OR REPLACE TRIGGER
BUDG.BUDGET_LITEMS_AUPD_TRAN AFTER UPDATE ON BUDGET_LITEMS FOR EACH ROW BEGIN
MANAGE_API.INS_FUNCTION_TRANS(USER,'UPDATE','BUDGETS',SYSDATE); END;

Export user objects result:
CREATE OR REPLACE TRIGGER BUDG.
BUDG.BUDGET_LITEMS_AUPD_TRAN AFTER UPDATE ON BUDGET_LITEMS FOR EACH ROW BEGIN
MANAGE_API.INS_FUNCTION_TRANS(USER,'UPDATE','BUDGETS',SYSDATE); END;

The name (BUDG.) duplicated after (CREATE OR REPLACE TRIGGER) statement.
This situation exists with objects created with owner name imbedded inside the text.
This error did not exist in previous version :(
 
Update:
I have noticed that if the trigger created with something like this:

create or replace trigger
BUDG.BUDGET_LITEMS_AUPD_TRAN ....

i.e. there is an (enter) or (end-of-line) character after the word (trigger), then the export fail with duplicate owner name, it exports like:

create or replace trigger BUDG.
BUDG.BUDGET_LITEMS_AUPD_TRAN ....

but if the trigger created like this:
create or replace trigger BUDG.BUDGET_LITEMS_AUPD_TRAN
after update ....

i.e. the first line contains the trigger name before it ends, then the export succeed.
 
Back
Top