Recently I got the following error in my alert.log file

ORA-1652: unable to extend temp segment by 128 in tablespace TEMPORARY

My temproray tablespace is 300M and is Localy managed with uniform extents of 1M each.

How will this effect the database or the query/statement because of which this error occurred.

Should I just keep on increasing the tablespace till this error goes away even if the temp tablespace has to be of 10G. I mean how much is enough. How do I find out.

How to size the temporary tablespace.

Also is there a way to find out which statement triggered this error?

Please suggest.


[Edited by ronnie on 06-13-2002 at 05:28 PM]