RE: Droping System User

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Thu, 04 Oct 2001 05:57:55 -0700
Message-ID: <F001.003A1BA1.20011004060019@fatcity.com>

Gholam,

The best way to tell if this hurts is to create a test database for yourself, and try it.

You may not get many experienced replies for this probably because the question is so far out of reality that nobody thought to try it. I would think that if anyone "accidently" did this to their own database, they quickly followed the command with a "Restore From Backup and Rebuild" command.

Hope this helps

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Thursday, October 04, 2001 5:25 AM To: Multiple recipients of list ORACLE-L

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: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

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