-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|