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