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

Thread: How to Decrease the High Water mark..

  1. #1
    Join Date
    Feb 2001
    Posts
    184
    Does any one know is there a way to Decrease the High water mark...

    I don't want to Truncate or Drop that table...
    What about Alter Table Deallocate Unused, Will it Bring the HWM down or any other statement or is any Disadvantage for that Statement.

    Thanks

  2. #2
    Join Date
    Mar 2001
    Posts
    45

    Thumbs up

    Why dont you try that, and get it confirmed by querying user_tables after running analyze table command.

    There is no harm in running alter table deallocate ...
    I hope so.

    --
    Thanx
    Ramesh.
    ______________________________
    There is nothing Impossible.
    Even Impossible says
    I M POSSIBLE

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Using the deallocate wouldn't reduce the hig water mark. What it would do is that it would release the unused space that are above the high water mark. Also consider using the KEEP.

    To release the space below the high-water mark even if the high water mark is below MINEXTENTS use KEEP 0

    Hope this would help you. Good luck,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    DEALLOCATE will not bring down HWM.
    You need to truncate or recreate the table again.

  5. #5
    Join Date
    Jul 2000
    Posts
    296
    In 8i you can reduce the high water mark with ALTER TABLE ... MOVE:

    ALTER TABLE emp MOVE TABLESPACE users;

    The table is recreated, you have to rebuild the indexes (they are unusable), but grants, triggers etc. are still there.

  6. #6
    Join Date
    Feb 2001
    Posts
    389
    If 8.1.6 , use alter table <table_name> move .....

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