Set Current_Schema --- back to own schema
From: webtourist <webtourist_at_gmail.com>
Date: Wed, 5 Mar 2008 14:37:12 -0800 (PST)
Message-ID: <b110bd8e-e4fe-4978-8562-35600165e342@p25g2000hsf.googlegroups.com>
Date: Wed, 5 Mar 2008 14:37:12 -0800 (PST)
Message-ID: <b110bd8e-e4fe-4978-8562-35600165e342@p25g2000hsf.googlegroups.com>
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
Received on Wed Mar 05 2008 - 16:37:12 CST