Hi,
This is what I get.

SQL> select sum(bytes) from dba_free_space where tablespace_name='TEMPORARY_DATA';

SUM(BYTES)
----------
104855552

I have increased the initial and next extent to 1MB and also made the pctincrease to 0.


Even then I am getting the error
SQL> analyze table test compute statistics;
analyze table test compute statistics
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 512 in tablespace TEMPORARY_DATA.

Thanks
Anurag