ALTER SESSION SET CURRENT_SCHEMA = [ USER NAME]

ALTER SESSION SET CURRENT_SCHEMA = [ USER NAME]


The ALTER SESSION SET CURRENT_SCHEMA = [USER NAME] allows you to switch your current session to that schema user.
Usually you will log in as sys or system to execute the above. In short this gives you the option to act as a schema user
without knowing the schema user password. The settings persists for the duration of the
session or until you issue another
ALTER SESSION SET CURRENT_SCHEMA statement.

e.g.

ALTER SESSION SET CURRENT_SCHEMA = OE