RE: Ora 1652

I would guess that a user is defined to the instance with its default and or temporary tablespace a "system".

-----Original Message-----
From: Kristen Cameron [mailto:cameronkgd_at_inac.gc.ca] Sent: Wednesday, July 19, 2000 4: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.

Thanks.

• Kristen Cameron Indian and Northern Affairs Canada Yellowknife, NT

-- 
Author: Kristen Cameron
  INET: cameronkgd_at_inac.gc.ca

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).