Re: System Tablespace and Autoextend

Hello Sam

I do not know specifically about SYSTEM tablespace but from a bitter experience beware of the 4GB limit. if a datafile on NT/2000 autoextend beyond a multiple of 4GB (8,12...) then that datafile is GONE. We had a production database crashing on this problem and had to call in Oracle with the DUL utility to help get the data out and rebuild the database.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, October 24, 2002 8:26 PM

> Hello All,
>
> I have heard several times that if the SYSTEM tablespace runs out of space
> and needs to autoextend (assuming autoextend is turned on for the data
> file), then you run the risk of the database crashing and of data
dictionary
> corruption. I have never personally encountered this problem, so I have
no
> experience on what actually does happen.
>
> I looked in metalink for documents on this, but turned up nothing. Does
> anybody have experience on the dangers of allowing the SYSTEM tablespace
to
> autoextend and also any documents on Metalink or OTN that describe this
> problem?
>
> We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our
Oracle
> versions are running on Windows NT (or Windows 2000).
>
> Thanks for any feedback.
>
> Sam Bootsma, OCP
> samb_at_cpas.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sam Bootsma
> INET: SamB_at_cpas.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).