Re: System Tablespace

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 03 Aug 2000 16:15:27 -0400
Message-Id: <10578.113789@fatcity.com>

You need to recreate the SYSTEM tablespace when you have had a system = crash and the SYSTEM tablespace are destroyed. The only way to "recreate" = the SYSTEM tablespace is to restore from the last backup and roll forward = the recovery.
Just another interpretation to the question. Ron Rogers
DBA OCP
Atl.GA

>>> Winnie_Liu_at_infonet.com 08/03/00 02:40PM >>>

There is no way you can recreate the system tablespace without recreate = the
whole database.

If there is any other way, I do really want to know! :)

Winnie

Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com> on 08/02/2000 03:42:19 PM

To: oracledba_at_quickdoc.co.uk, ORACLE-L_at_fatcity.com=20 cc: (bcc: Winnie Liu/HQ/ISC)

DBAs,

When do we need to recreate System tablespace?

This is a question asked in an interview....

TIA, Sandeep.

---

If you're bored, then visit the list's website: http://www.lazydba.com=20 (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk= =20
to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk=20

--=20
Author:=20
  INET: Winnie_Liu_at_infonet.com=20

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 Aug 03 2000 - 15:15:27 CDT