Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    7

    Lightbulb Unanswered: onload/onunload

    As far as I know you can use the onunload/onload routines to get rid of tables that spread over more then one extends.

    To check if you got more then one extends use the oncheck -pe |more

  2. #2
    Join Date
    Mar 2002
    Posts
    19
    if you use dbexport (-ss option) you can then drop
    your database and then import .
    If you have sufficient contiguous space
    all tables will have exactly one extent allocated for them
    Surely , new inserts will allocate another extent just immediatelly
    If you dont want it to happen
    you´ll have to modify the "next extent size" in your <database>.sql
    as well as first extent size to give room for the table to grow
    without allocating new extents
    Tables that have more than 6 extents will cause a lower
    performance in your apliccation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •