Re: Index rebuilds

Neil Emery wrote:

>In the "olden" (or should that be golden?) days we were all recommended to
>regularly export and import
>tables where a large number of inserts/deletes occurred to 'tidy' them up.
>Am i correct in saying that this is no longer required with oracle 7/8/9 ?
>
>TIA
>
>Neil
>
>

You would not be correct as you stated it.

What I would say is that you should not need to do it provided you are using locally managed rather than
dictionary managed tablespaces and that all hard and fast rules are always wrong.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)