Sam,
Autoextend caused tablespace corruption for me once, but it was over 5
years ago with Personal Oracle 7.3.2.3 on Win95 - not the most reliable OS
that Oracle has ever ported to. ;-)
We have several 8.1.7 databases here, on both Win2k and HPUX. Autoextend,
even on System, has caused no problems that I'm aware of.
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715
[EMAIL PROTECTED]
Sam Bootsma
<[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: System Tablespace and Autoextend
om
10/24/2002
01:26 PM
Please respond
to ORACLE-L
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
[EMAIL PROTECTED]
--
Author: Sam Bootsma
INET: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [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).
