RE: Ora 1652

From: Kristen Cameron <cameronkgd_at_inac.gc.ca>
Date: Wed, 19 Jul 2000 18:16:38 -0400
Message-Id: <10563.112466@fatcity.com>

Yes, that was exactly it. Thank you.

I seem to be at the stage of learning where I sometimes know how to fix an identified problem, but I haven't yet=20 learned how to identify the problem!

Kristen

>>> rlsmith_at_kmg.com 7/19/2000 >>>

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

-----Original Message-----
Sent: Wednesday, July 19, 2000 4:06 PM
To: Multiple recipients of list ORACLE-L

When I checked yesterday's alert logs, I found the following error:

ORA-01652 unable to extend temp segment by (num) in tablespace SYSTEM. =20

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

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

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). --=20
Author: Smith, Ron L.
INET: rlsmith_at_kmg.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------