I suggest you review a presentation by Tom Kyte on reorganizing objects that he gave yesterday at RMOUG. I expect it should be on his website somewhere.
Short version: you probably don't need to do anything. Dan Sent from my iPhoneOn Feb 12, 2009, at 3:00 PM, Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx> wrote:
I wanted to get recommendations on tools for online reorg/defrag of multi-terrabyte Oracle database.Thanks in advance for your feedback. -Deepak