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

Thread: tablespace problem

Threaded View

  1. #4
    Join Date
    Oct 2000
    Posts
    467
    Which Oracle version ?
    Check for any hung or active transactions which might have occupied space from v$sort_segment, v$sort_usage.
    Try to coalesce. If no usage and still no free space, try to take it offline and then online again else add more space.
    Last edited by vinit; 01-21-2004 at 03:07 AM.
    Vinit

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