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. |
Oracle DBA FAQ >
Oracle DBA FAQ >
How to change current schema without changng userposted Sep 10, 2010, 1:12 PM by Sachchida Ojha
|