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
Venkata vara Prasad Kosaraju
its not the temp tablespace, it is tablespace TS_LCT_TMP which needs to be bigger
and windows has limit on size of file,create more dbfiles on tablespace.
I dont know what xp's limit is
Able was I ere I saw Elba
It's not the version of Windows, but the type of file system. W2K and XP can use NTFS.
Click Here to Expand Forum to Full Width