ora-1652 on *undo* tablespace?

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Mon, 05 Mar 2007 22:04:37 GMT
Message-ID: <Vt0Hh.510$Ih.136@trnddc02>

ORA-1652: unable to extend temp segment by 8 in tablespace UNDO1

Today I saw in my alert log the above error. How does one create a *temp* segment in an *undo* tablespace? I've tried setting my temporary tablespace to UNDO1 and it failed with an error. I tried creating an index in UNDO1 and it failed with an error. So what caused this message in the alert log?

RDBMS version is 9.2.0.5.

Then about an hour later I user got an ora-30036 on the UNDO1 tablespace. The tablespace should have been no where near full. It has 7g of datafiles assigned to it. DBA_UNDO_EXTENTS was reporting about 2.5g unexpired, 60m expired, and < 1m active. Yet Grid control (10g r2) was saying the tablespace was 100% full. It was actually only about 35% full. What am I missing? Received on Mon Mar 05 2007 - 16:04:37 CST