Obviously, this error tells you that Oracle cannot extend segment. Oracle
can fail to extend a segment only because of the lack of the necessary space
in the tablespace. A common wisdom (and OFA, which is anything but the
tells you to separate different object types into the different tablespaces.
Tablespace system should be used for DICTIONARY TRANSACTIONS ONLY. If you
see somebody to use the tablespace SYSTEM as the temporary tablespace (see
CREATE LUSER command options) please fell free to shoot the DBA. It would
be advisable to put the rollback segments into their separate tablespace and
(I know I'm asking too much now!) to separate tables and indexes not only to
separate disks but to the separate controllers as well. When it comes to the
system safety, words like RAID-5, EMC, Legato Networker and DLT7000 robot
come into my mind. Running a well designed database with 95% uptime is an
If you were an internet company, like let's say E-Bay, then you couldn't
not to install patches, not to have a hot standby system and not have even a
proper backup and keep your systems down for a week, could you?
From: Kristen Cameron
Sent: Wednesday, July 19, 2000 5:06 PM
To: Multiple recipients of list ORACLE-L
Subject: Ora 1652
When I checked yesterday's alert logs, I found the following error:
ORA-01652 unable to extend temp segment by (num) in tablespace SYSTEM.
I've forgotten what the actual number was. The recommended action is to add
a datafile. However, when I checked the existing datafile, it is less than
50% full, with 20 MB remaining, and 11 MB in the next available extent.
Does anyone have any idea what is causing this? For now, I plan to see if
the error occurs again, and then add another datafile if necessary. The
error occurred during business hours (ie. when the database was in use) and
we also have developers working on an update, although they are supposed to
be working on the development database.
Indian and Northern Affairs Canada
Author: Kristen Cameron
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).