Using an import as a defrag

From: howard <>
Date: Tue, 22 Jan 2008 09:38:31 -0800 (PST)
Message-ID: <>


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.


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

Original text of this message