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
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
ummm extend the tablespace?
alter database datafile 'xxx' resize xxxM;
or the tempfile if its s true temporary tablespace
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?
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