Re: Set Current_Schema --- back to own schema

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" ?
>
> Thanks
> 10gR2

If you can't recall who the original schema was, check out

select sys_context('userenv','session_user') from dual;

jg

--
@home.com is bogus.
If you see a pile of bird poop, don't step over it and look up.