SQL>
SQL>
SQL> CREATE OR REPLACE TRIGGER change_schema AFTER logon ON DATABASE
2 begin
3 execute immediate('alter session set current_schema=app_master');
4 end;
5 /
Trigger created.
SQL>
SQL> drop trigger change_schema;
Trigger dropped.