hI,

You can use the DBMS_SPACE.UNUSED_SPACE Prc to see where the High Water Mark
has been set for a Table.

That is the Total Blocks - Unused Blocks.

To Reset the High Water Mark u need to truncate the table.

Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019


-----Original Message-----
From: Zhang Wei-P1962C [mailto:[Email Address Removed] Friday, December 14, 2001 6:53 PM
To: LazyDBA.com Discussion
Subject: Where to find table's high water mark?


Hi list,

Where to find the high water water mark of a table and how to reset it?
thanks,

Wei

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page