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
Printable View
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.
manjunath
Or resize the dbf.
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:
select Owner,
Segment_Name,
Segment_Type,
Bytes,
Max_Extents,
Extents
from DBA_SEGMENTS
where Segment_Type = 'TABLE'
and owner not in ('SYS','SYSTEM')
order by Owner, Segment_Name, Segment_Type, Max_Extents