DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Help

  1. #1
    Join Date
    Sep 2000
    Posts
    56
    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

  2. #2
    Join Date
    Oct 2000
    Posts
    211
    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

  3. #3
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Or resize the dbf.

  4. #4
    Join Date
    Sep 2000
    Posts
    56
    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??????

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    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.

  6. #6
    Join Date
    Sep 2000
    Posts
    56
    Thanks Manju & Maris for the suggestions

  7. #7
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    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
  •  


Click Here to Expand Forum to Full Width