Try alter table tab_name move in the same TS (for all segments in that TS).. and then do shrink of datafiles.. Abhay.
funky... "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail." "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Forum Rules
Reply With Quote