Re: Newbie Q: Does Create Index Lock Table?

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

--

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.

>