RE: LOB index creation/

From: Storey, Robert (DCSO) <"Storey,>
Date: Thu, 7 Jan 2016 16:53:33 +0000
Message-ID: <FE4C2B093843BB4B873D754E5E0BE4DB01998C491F_at_DCSOSVMS02.dcso.org>

Much to my chagrin, I have determined that the index was created. A check of user_segments found it there. However, it was not being listed under the index tab for the applicable table, which is probably a permissions issue.

A new thing learned today.

-----Original Message-----
From: Stefan Koehler [mailto:contact_at_soocs.de] Sent: Thursday, January 07, 2016 10:52 AM To: Storey, Robert (DCSO); Oracle L
Subject: Re: LOB index creation/

Hi Robert,
sounds like "Deferred Segment Creation": http://docs.oracle.com/database/121/ADMIN/tables.htm#ADMIN13319

SYS and SYSTEM users are special in case of "Deferred Segment Creation (and many other things too). The segments are immediately associated.

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK

> "Storey, Robert (DCSO)" <RStorey_at_DCSO.nashville.org> hat am 7. Januar 2016 um 17:26 geschrieben:
>
> Curious.
>
> I have a create table statement that has one column of type SYS.XMLTYPE.
>
> I logged in as SYS and created this table as BOB.logtable. Table created fine but I noticed that a LOB index had been created at the same time.
>
> I dropped the table and then logged in as Bob. I ran the same create table script. No LOB index created.
>
> Is this expected action? How would user Bob put the LOB index on there…..and is it needed?

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Thu Jan 07 2016 - 17:53:33 CET