decrease number of extents on large tables (export/import) 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



    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.


  2. #2
    Join Date
    Nov 2000
    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
    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,

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