| Query Temp Tablespace allocation problem [message #64795] |
Mon, 02 February 2004 21:37 |
Raju KVG
Messages: 13
Registered: January 2004
|
Junior Member |
|
|
Hi All,
Iam using Oracle 9i release 2 version. I have written one proc which has a input of CLOB(coma seperated values passed in) and inside the proc i convert this CLOB into a PL/SQL table and did some normal insert and update stuff. When i run this it gives me a error saying ORA-01652: unable to extend temp segment by 512 in tablespace TEMP
i checked the sort usage for the session which is running this proc. and found that it is using almost the entire temp tablespace.(298MB) the whole schema put together is not more than 150MB. to top it all there is no Order by or Group by clause used in the proc, still this happens can any 1 help giving a solution or let me know what is the probable cause for this.
Regards,
Raju
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
