Re: is rebuilding indexes necessary after import?

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Tue, 21 Dec 2004 23:43:31 -0800 (PST)
Message-ID: <Pine.LNX.4.58.0412212340370.25550@shell2.speakeasy.net>

On Wed, 22 Dec 2004, Jaffar_DBA wrote:

> My question is, do we really need to rebuild/recreate indexes after
> importing them into another database?

Probably the reason they recommend this is that they hope you will import without indexes, then build them in some more efficient way (parallel, unrecoverable) with the export completed, saving yourself time.

Also, your nickname for this list - Active DBA (from the To: header) - is this is contrast to Lazy DBA? If so I like the distinction!

--
Jeremiah Wilton
Independent Oracle Professional
Oracle Certified Master
Disaster Recovery - Seminars - Technical Interviews
http://www.speakeasy.net/~jwilton
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 22 2004 - 01:38:53 CST