When using Extract DDL to extract the text of a logon schema trigger, it does not show the prefix of the target schema.
SQL Navigator produces the following:
CREATE OR REPLACE TRIGGER test.test_user_after_login_trig
AFTER LOGON ON SCHEMA
begin
execute immediate 'alter session set current_schema=TEST';
end TEST_USER_AFTER_LOGIN_TRIG;
When it should be (extracted from metada):
CREATE OR REPLACE TRIGGER "TEST"."TEST_USER_AFTER_LOGIN_TRIG"
AFTER LOGON ON TEST_USER.SCHEMA
begin
execute immediate 'alter session set current_schema=TEST';
end TEST_USER_AFTER_LOGIN_TRIG;
The metadata shows "...after logon on TEST_USER.SCHEMA" where TEST_USER is a target schema. This is not extracted in the DDL in SQL Navigator.
WORKAROUND
Manually add the target schema name to the script.
STATUS
Waiting for fix in a future release of SQL Navigator for Oracle
