Hello all,

I have moved all tables and indexes from a tablespace inorder to defragment
it. Now there are 2 datafiles one big and one small. I want to eliminate
the small one, by resizing to a small value BUT SURPRISE..i am not able to
resize even after i coalesced it!!! why?

Whats the way around. if nothing, now the tablespace has no objects, i am
thinking of dropping the tablespace and the datafile and recreating a new
tablespace and datafile. Is it safe enough?

Waiting for your inputs
Ganesh


Oracle LazyDBA home page