temp segment in non-temp tablespace??

temp segment in non-temp tablespace??

Post by Ed Steven » Sun, 31 Dec 1899 09:00:00

 I hope I'm overlooking the obvious here . ...

One of my alert logs turned up an ora-1652, unable to extend temp
segment ... in tablespace xyz.  What puzzles me is that there are no
users that specify tablespace xyz as their temporary tablespace.  That
being the case, why would the need arise to extend a temp segment in
that tablespace?

Ed Stevens
(Opinions are not necessarily those of my employer)

Sent via Deja.com http://www.deja.com/
Before you buy.