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

Thread: Reduce number of extents

  1. #1
    Join Date
    Dec 2000
    Posts
    2
    I have an Oracle 734 database with tablespaces which have 100s of extents.
    Is there a way to reduce the number of extents for a tablespace.

    Thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    change storage parameters of all tables in that tablespace using dynamic SQL, change to larger values than actual ones then exp with compress=n, drop tablespace (if no tables from other tablespace would reference the tablespace you are dropping), recreate tablespace, import

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