ORA-01652: unable to extend temp segment by 128 in tablespace TS_LCT_TMP
I have the dtabase in oracle 9i running windowsxp.
I have the space in D reive has 40 GB. Oracke Installed in Cdrive which is also 40GB.
I have most of the tables have the clob columns
I create the temp Table space like below
TEMPORARY TABLESPACE TS_NMT_TMP TEMPFILE
'D:\ORACLE\ORADATA\LCT\TS_NMT_TMP.ora' SIZE 400M AUTOEXTEND
ON NEXT 512K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 10M
So I have one opration called UPdate All. It updates the 4000 clobs. each clob updated and comiited for each clob. first i will get the clob and update the clob and do commit.
after some time i am getting the exceprtion ORA-01652: unable to extend temp segment by 128 in tablespace TS_LCT_TMP
I look at the temp file size is 4GB. here in d drivre has 20GB free space and temp file has auto extend on still is giving the unable to extend the exception.
Why the temp file is growing the like that ??? and why it is not flush by oracle server even it is full?
pl give me advice???
Thanks & Regards
Venkata Vara Prasad Kosaraju