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