ora-03297 : Unable to resize value...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ora-03297 : Unable to resize value...

  1. #1
    Join Date
    Jun 2002
    Posts
    88

    ora-03297 : Unable to resize value...

    Dear Gurus,

    Unable to resize tablespace.

    I'm having problem while resizing tablespaces. For example,

    Tablespace allocation space : 2000m
    Used space : 50m.

    When I reduced it to 500m, I encountered this error message :
    ORA-03297 : file contains used data beyond requested RESIZE value.

    May someone helps?

    Thank you in advance,
    Iyyappan.M

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    There are some extents lying beyond the space you want to resize it. You can either export/import the objects or alter table move in the same tablespace. And in case of indexes rebuild them in the same tablespace.

    HTH
    Sanjay

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