how to clear tablespaces
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to clear tablespaces

  1. #1
    Join Date
    Aug 2001
    Posts
    267
    I have a tablespace size 4GB . This tablespace contains only one rollback segment ,no tables etc. Currently no transactions pending for a week . I just dropped that tablespace and recreated , still it occupied 4gb . How to clean that 4GB rollback information ..And it the temporary table space is filled up with 3 GB . How to clean it . Currently no user's connected ,no transactions ..


    Raghu
    Raghu

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Drop and recreate it. On the other did you drop the RBS before dropping the Tablespace? The RBS could be having the allocation specs of 4GB.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Aug 2001
    Posts
    267
    Thanks .... I didn't look at the script to create RBS . It has initial 250 M with min.extents 10 ...


    Raghu
    Raghu

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