Changing your Oracle Session Schema Use the following code to alter your session's current schema: ALTER SESSION SET current_schema = SYSADM This will change the current schema to SYSADM when you are logged in as a different schema.