This is what I get when i run the query.

SQL> select tablespace_name, max(bytes) "largest free extent" from dba_free_space
2 group by tablespace_name
3 /

TABLESPACE_NAME largest free extent
------------------------------ -------------------
REC_DATA 103821312
ROLLBACK_DATA 3008512
SYSTEM 1261568
TEMP 1054720
TEMPORARY_DATA 112195584
USERS 10240
USER_DATA 1392640


Also please note that Now I have assigned the TEMP tablespace to the user and its largest free extent is 1054720.

I am still getting the error.

BTW whats the best way to size the temporary tablespace rather than to keep on increasing its size every now and then. There should be some way where I can predict the temporary tablespace size requirements by doing some calculations.

Thanks
Anurag

Thanks
Anurag

[Edited by anuragmin on 05-30-2001 at 01:57 PM]