ORA-1652: unable to extend temp segment by 8 in tablespace DATA01
What can be done to avoid this error.I AM SEEING A LOT OF TABLESPACE IS FREE.STILL I AM GETTING THIS ERROR
Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace or create the object in another tablespace.
Actually I guess i need not add any datafiels as I am seeing now itself lot of space is available.Then why to add datafile??????
You may have enough free space, but the free space you have may be fragmented. In other words, you have a bagfull of pennies but can't buy a coke from the machine because you don't have a quarter.
Thanks Manju & Maris for the suggestions
Run the following query as sys and post the output:
where Segment_Type = 'TABLE'
and owner not in ('SYS','SYSTEM')
order by Owner, Segment_Name, Segment_Type, Max_Extents
Senior Database Administrator
Click Here to Expand Forum to Full Width