Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie Q: Does Create Index Lock Table?
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:966725376.15074.0.nnrp-13.9e984b29_at_news.demon.co.uk...
>
> So long as they are not:
>
> function-based,
> descending,
> reverse,
> the index segments to LOBs
> secondary indexes on IOTs
>
> But I THINK that ONLINE first appeared in 8.0
>
Well, your list kind of confirms what I thought -this facility is not the world's most useful!! Thanks for the clarification.
Maybe there's a difference between 'create...online' and 'rebuild...online'. It's just that the training materials for the 'rebuild...online' specifically state that it wasn't available in 8.0. I'll bow to your thinking on the 'create' option.
Regards
HJR
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Howard J. Rogers wrote in message <399f09a9$1_at_news.iprimus.com.au>...
> >
> >
> >Also, I think you'll find that it's only b-tree indexes that can be
rebuilt
> >online in any case.
> >
>
>
>
Received on Sat Aug 19 2000 - 22:44:50 CDT