SPACE ISSUE

[bgill]

I have a tablespace with one datafile of 450mb in size.
This datafile contains 8 objects. Only 200mb of the
datafile space is used by these objects (all tables).

I had tried to shrink the datafile to 250mb in size but got
an ORA 03297 error (blocks of data beyond requested
resize value). I checked all the objects extents and found
that most had multiple extents.

I exported the tables, truncated them, dropped them
and imported them back, and coalesced the tablespace.
Now all objects have only one extent each, yet I still get
ORA 03297 when I try to shrink the datafile.
What must I do to reclaim the space?


Thanks in advance

[SANJAY_G]

The steps should be EXPORT, DROP, COALESCE and IMPORT.
Somehow you still have data beyong the size you want to resize.

HTH
Sanjay

[bgill]

Thanks again SANJAY

Everything is ok now. All tables dropped, tablespace coalesced
and tables re-imported. I have now been able to shrink
the datafile and reclaim space.

[SANJAY_G]

Great !!