DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2012

    Can i reduce the size of UNDO tablespace datafile..??

    the actual size

    SQL> select tablespace_name,sum(bytes) from dba_data_files group by tablespace_name;

    ------------------------------ ----------
    UNDO 3

    space occupied
    SQL> select tablespace_name,sum(bytes) from dba_segments group by tablespace_name;

    ------------------------------ ----------
    UNDO 198

    now when i am resizing the datafile to 1GB i am getting this error..

    SQL> ALTER DATABASE DATAFILE '/oradata/u01/undo01.dbf' RESIZE 1024M;
    ALTER DATABASE DATAFILE '/oradata/u01/undo01.dbf' RESIZE 1024M
    ERROR at line 1:
    ORA-03297: file contains used data beyond requested RESIZE value

    can someone help me with this.

  2. #2
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    Create a new UNDO tablespace, drop the old one.

    For details check Metalink Note 431652.1
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Oct 2012
    thank you ..!! PAVB

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.