Re: Set Current_Schema --- back to own schema
Date: Thu, 6 Mar 2008 11:53:16 -0800 (PST)
On Mar 5, 2:37 pm, webtourist <webtour..._at_gmail.com> wrote:
> If my schema is say "scott" and I do "alter session set
> current_schema=<some other user>"
> How should I set it BACK to my schema ? "alter session set
> current_schema=scott" ?
If you can't recall who the original schema was, check out
select sys_context('userenv','session_user') from dual;
-- @home.com is bogus. If you see a pile of bird poop, don't step over it and look up.Received on Thu Mar 06 2008 - 13:53:16 CST