Re: LOB index creation/

From: Stefan Koehler <contact_at_soocs.de>
Date: Thu, 7 Jan 2016 17:52:08 +0100 (CET)
Message-ID: <1830055951.59201.1452185528263.JavaMail.open-xchange_at_app01.ox.hosteurope.de>

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?

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 07 2016 - 17:52:08 CET