How to Set Different Schema in Current Session in oracle

<<Back to DB Administration Main Page

Working with Different Schema User Than The Connect User Shema In Oracle

You can set the current schema as some other schema than the connected schema. Doing so will help you to query the tables of other schema without qualifying them as SCHEMA.TABLE_NAME

SQL> ALTER SESSION SET CURRENT_SCHEMA=TEST_USER;
Session altered.

SQL> select sys_context('USERENV', 'SESSION_USER')  as "Connected_User" from dual;
Connected_User
------------------------------------------------------------------------------------------
SYS
1 row selected.

SQL> select sys_context('USERENV', 'CURRENT_SCHEMA') as "Session_User" from dual;
Session_User
---------------------------------------------------------------------------------------------------
TEST_USER
1 row selected.