decrease number of extents on large tables (export/import)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: decrease number of extents on large tables (export/import)

  1. #1
    Join Date
    Aug 2000
    Posts
    7

    Question

    Hi,

    i want to export/import some database-tables to decrease the number of extents. The problem is that one of the tables is about 4 GByte (BAAN-Table).
    What will happen to the initial extent when i use the compress option ?
    How can i set the size of the extents manually ?
    I'm using oracle 7.3 on hp_ux.

    Thanks
    Hubertus

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    COMPRESS=Y will set your initial extent to the size necessary to fit the entire table into one extent. Once the table is imported back in, you can change the next extent size by:
    alter table xys storage (next 1280K);
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    I would not recommend an extent size gretear than 1Gb.
    If you use compress=y initial will be 4Gb and you will need a datafile greater than that.
    You can "set it manually" if you create first the table and in the import put ignore=y
    Ramon Caballero, DBA, rcaballe@yahoo.com

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