Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Ora 1652

RE: Ora 1652

From: Gogala, Mladen <>
Date: Wed, 19 Jul 2000 19:35:56 -0400
Message-Id: <>

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 common wisdom)
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 also
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 and RMAN
come into my mind. Running a well designed database with 95% uptime is an expensive proposition.
If you were an internet company, like let's say E-Bay, then you couldn't afford
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?

-----Original Message-----
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.


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: (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 Wed Jul 19 2000 - 18:35:56 CDT

Original text of this message