Re: Set Current_Schema --- back to own schema
From: gazzag <gareth_at_jamms.org>
Date: Thu, 6 Mar 2008 02:39:40 -0800 (PST)
Message-ID: <627ff514-a0cf-42de-be25-c16a1460a091@n75g2000hsh.googlegroups.com>
Date: Thu, 6 Mar 2008 02:39:40 -0800 (PST)
Message-ID: <627ff514-a0cf-42de-be25-c16a1460a091@n75g2000hsh.googlegroups.com>
On 5 Mar, 22:37, 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
Yes.
HTH -g Received on Thu Mar 06 2008 - 04:39:40 CST