Oracle DBA FAQ‎ > ‎

How to change current schema without changng user

posted Sep 10, 2010, 1:12 PM by Sachchida Ojha

alter session set current_schema=SCHEMA_NAME  /*without quotes*/

Verify: SELECT SYS_CONTEXT('USERENV','CURRENT_SCHEMA') from DUAL; 

logged in user must have alter session priv in order to run this command.
Comments