RE: is rebuilding indexes necessary after import?

I just stumbled upon www.lazydba.com. No idea if it is any good. The banners and terms & conditions look sound enough. I'll get an email address and give it a try.  

-----Oorspronkelijk bericht-----
Van: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Namens Jeremiah Wilton
Verzonden: woensdag 22 december 2004 8:44 Aan: Jaffar_DBA
CC: Active DBA
Onderwerp: Re: is rebuilding indexes necessary after import?

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


--
http://www.freelists.org/webpage/oracle-l