table highwatermark
In principle it is simple : the query calcuate for each table how many blocks do I need for storing the data and how many blocks are allocated.
Be aware the statistics on the tables are recent.
When cppy past this SQL the statement can give an error ORA-00911 due to a wrong ‘ sign. In this case plase replace the ’sign by a valid one.
Tables with CLOB and LONG field are not covered.
When you have the tables apply the resolution to repair the HWMS.
Resolution :
– alter table TALE_NAME move ;
– alter index INDEX_NAME rebuild ; ( rebuild invalid indexes after table move)
