Using an import as a defrag

Hello,

I was talking with fellow DBA that told me that I should export my schema, drop it, and re-import it.

The reason was that it would act as a defragment and would reorganize my extents and therefore I would gain better performance.

I have a small environment; the db is only 100GB. I would only retain about 10GB in recovered space if I did this in production.

Is this an accepted practice?

In 10g, I have worked with segment advisor and the reorganize tools, but they seem almost useless.

Thanks,

Howard Received on Tue Jan 22 2008 - 11:38:31 CST