Re: Using an import as a defrag

From: Bob Jones <email_at_me.not>
Date: Tue, 22 Jan 2008 20:07:34 -0600
Message-ID: <Gjxlj.937$>

"howard" <> wrote in message
> 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?

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

Original text of this message