Oracle Database Discussions

Hi,

I did a defragmentation in a particular table in prod

create table ......... as select * from ........

drop

create table .......... as select * from ...........


I reclaimed space in tablespace level,but could not in OS level.

I used script checking HWM but cudnt shrink.

It says error as data is there.

Please help