Re:Droping System User

From: <dgoulet_at_vicr.com>
Date: Thu, 04 Oct 2001 06:56:39 -0700
Message-ID: <F001.003A1D2F.20011004070525@fatcity.com>

There are some things that you can do in Oracle, but that you pay quite a price for. This is one of those. Can you drop the system user, yes I've done so just because I wanted to see for myself what would happen. There were a lot of odd things that happen thereafter, like packages that no longer worked, synonyms that responded weirdly, and the inevitable crash that followed. Don't do it. It falls into the line of what happens when you drop the system tablespace. It does as you ask & then does what it must. Doing things like this are only good exercises in exploring a computers mentality, namely that chunk of silicon known as a CPU will do anything you tell it no matter if it's smart or not. It's one of the tricks I enjoy using in high school computer classes when I get called. Seems some kids have this idea that the computer is so smart that it cannot make a mistake. I just love asking a CPU to commit suicide & watch the look on the kids faces!!

Dick Goulet

____________________Reply Separator____________________
Author: Ahmed Gholam Hussain <ahussain_at_gisqatar.org.qa>
Date:       10/4/01 1:25 AM

Hi list ,

Sorry for posting this strange question , but I am hopeful that I will get some explanation ...

Question : Can we drop user SYSTEM ? How we will recover that ?( I know that nobody should do that !!!!!!! )

Any response would be appreciated

TIA
Gholam

--

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

Author: Ahmed Gholam Hussain
INET: ahussain_at_gisqatar.org.qa

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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).
--

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

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------