Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> check high wate mark on tables??

check high wate mark on tables??

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Thu, 17 May 2007 07:53:39 -0700 (PDT)
Message-ID: <470287.1077.qm@web60822.mail.yahoo.com>


we have ORACLE on version 9.2.0.8. 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
Received on Thu May 17 2007 - 09:53:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US