Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: is rebuilding indexes necessary after import?

RE: is rebuilding indexes necessary after import?

From: Eric Buddelmeijer <Eric.Buddelmeijer_at_elegant.nl>
Date: Wed, 22 Dec 2004 11:21:56 +0100
Message-Id: <20041222102201.JPIV1537.amsfep14-int.chello.nl@wst116>


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
Received on Wed Dec 22 2004 - 04:18:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US