Results 1 to 3 of 3

Thread: reorg a table

  1. #1
    Join Date
    Nov 2002

    Question Unanswered: reorg a table

    I have deleted lot of rows from one table, and then I need to shrink the table size by using alter index to cluster command. It failed because I did not have enough dbspace for the job.

    How could I know how much free space I need for the table reorg?

    Any bright idea will be welcome.

  2. #2
    Join Date
    Oct 2002
    you can try:

    ALTER FRAGMENT ON TABLE tablename INIT IN dbspacename_or_fragment_expression;

    This will, oddly enough, work for both fragmented and non-fragmented tables and tends to be faster than CLUSTERing an index since it does not have to sort the data.

    It might work - I never tryed it


  3. #3
    Join Date
    Mar 2002


    there is another way Unload-Drop-Create Table-Load-Build Index-Upstat
    you have to re-calculate table's extent,next extent or create by fragment for optimization
    the table is very clean but it takes quite long time

Posting Permissions

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