LMT and highwater Mark
If you are having problems resizing dictionary managed
tablespace and get this error "ERROR at line 1: ORA-03297"
which is due highwatermark of a datafile
SQL> alter database datafile '/ots3/oradata/v817/oradata/v817/temp01.dbf' resize 433000;
alter database datafile '/ots3/oradata/v817/oradata/v817/temp01.dbf'
* ERROR at line 1: ORA-03297: file contains used data beyond requested RESIZE value
Would this problem be avoided when you start using LMT?
Of course not.
This problem has nothing to do with extent management.
This error means you have data enough to make the datafile smaller.
file contains used data beyond requested RESIZE value
Though u use LMT, if the data exists in the datafile at the resized place the file will be not resized
Click Here to Expand Forum to Full Width