Oh I think Marlene once did an "alter tablespace system offline" just
to try it.... :)
it worked.. she then altered it back online.
- JOE TESTA <JTESTA_at_longaberger.com> wrote:
> I'm with ya but dont have a recent backup of the play database to try
> it, its scheduled for backup tomorrow night :)
>
> joe
>
>
> >>> dgoulet_at_vicr.com 10/04/01 11:05AM >>>
> Tom,
>
> Think again!!! But at least it was a play area.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Mercadante; Thomas F" <NDATFM_at_labor.state.ny.us>
> Date: 10/4/01 6:00 AM
>
> 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
> --------------------------------------------------------------------
> 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
> --------------------------------------------------------------------
> 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!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
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).
Received on Thu Oct 04 2001 - 09:57:48 CDT