It's just what it sounds like. It's an index on the LOB. Yes, you can specify a different
tablespace for it. Look up the syntax for create table. If you've already created the table,
look up the alter table syntax for the modify lob clause.
- Chuck Hamilton <chuck_hamilton_at_yahoo.com> wrote:
>
> When I create a CLOB data type, oracle automatically creates a LOBSEGMENT and LOBINDEX segment.
> I understand the the LOBSEGMENT contains the LOB data. But what the heck is in the LOBINDEX? Why
> is it needed. Do I need to do anything with it? Is there some way to store it in a different
> tablespace than the LOBSEGMENT?
>
>
>
> ---------------------------------
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
Received on Wed Jul 05 2000 - 14:28:56 CDT