-
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
-
-
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
_________________________
Joe Ramsey
Senior Database Administrator
dbaDirect, Inc.
(877)687-3227
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|