Re: alter session

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Wed, 08 Oct 2003 18:39:24 -0800
Message-ID: <F001.005D26F7.20031008183924@fatcity.com>

it raises the DBA's blood pressure by 50 mm Hg. if found, it prevents the user from having an unlocked account. if found, it is possible that it gets the user a termination notice.  

you're in the sys schema for what purpose? testing recovery from dictionary corruption?  

Pd

bulbultyagi_at_now-india.net.in wrote:
List, what does the following do ?

alter session set current_schema=sys;
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: INET: bulbultyagi_at_now-india.net.in

Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services

---

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

---

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Paul Drake
  INET: discgolfdba_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Oct 08 2003 - 21:39:24 CDT