LMT and highwater Mark

[clinton]

Hello folks,

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?

regards,
Clinton

[Mnemonical]

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

F

[tharakab]

Though u use LMT, if the data exists in the datafile at the resized place the file will be not resized