ora-03297 : Unable to resize value...

[iyyappan]

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

[SANJAY_G]

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