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