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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
