unable to extend TEMP tablespace error
Posted on 2007-03-30
I am getting 'ORA-01652: unable to extend temp segment by 64 in tablespace TEMP' this error when trying to create a table in my database.
The create table stmt is :
create table t1
as select a.c1, sum(a.c2)......avg(b.c3)....
from table1 a, table2 b
where .... ;
So i want to know which program/user/session is using the space allocated to TEMP tablespace currently. I want this info. so that i can kill that program/session or talk to other user about this. We are in situation where we cannot go and request for extra space in TEMP tablespace at the moment.
I know that we need to increase the TEMP tablespace storage but that will happen in a weeks time. But i want this table to get created as this is a bit urgent.