LMT and highwater Mark
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: LMT and highwater Mark

  1. #1
    Join Date
    Jan 2001
    Posts
    157

    LMT and highwater Mark

    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

  2. #2
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282
    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

  3. #3
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32

    RESIZE DATAFILE

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width