Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Wed Dec 22 2004 - 04:18:09 CST