check high wate mark on tables??
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 17 May 2007 07:53:39 -0700 (PDT)
we have ORACLE on version 184.108.40.206. after we truncate sever tables, we still can NOT shrink data file due to high water mark did not change. Does there has way to check which table after truncate high water mark no chage? Thanks. ____________________________________________________________________________________ Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center. http://autos.yahoo.com/green_center/ -- http://www.freelists.org/webpage/oracle-l