Re: Using an import as a defrag
Date: Tue, 22 Jan 2008 20:07:34 -0600
"howard" <pkowal74_at_gmail.com> wrote in message
> 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?
That would be the question to ask your fellow DBA. No one here has the data to support his finding. Received on Tue Jan 22 2008 - 20:07:34 CST