ORA-1652: unable to extend temp segment by 32 in tablespace TEMP

[sivaramat]

I am getting the following message through Alert.log

ORA-1652: unable to extend temp segment by 32 in tablespace TEMP

How to fix this bugg?


TIA

[davey23uk]

ummm extend the tablespace?

alter database datafile 'xxx' resize xxxM;

or the tempfile if its s true temporary tablespace

[sivaramat]

more information:

1. Temp is not a Dictionary Managed Tablesapce
2. with Uniform Allocation
3. Extent management is "Locally"
4. Current size is 4 Gb

with the above points, how big that we can make this temp tablespace? If we make this around 10 G, are there any dependancy parameters? How to find out the what are the programs which consumes this temp tablespace memory?

[davey23uk]

You can make it as big as you want (or need)

take a look at this to see who is using it

http://www.jlcomp.demon.co.uk/faq/sort_user.html