Help

[sureshgane]

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

[manjunathk]

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

[Halo]

Or resize the dbf.

[sureshgane]

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??????

[marist89]

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.

[sureshgane]

Thanks Manju & Maris for the suggestions

[wjramsey]

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