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: @OracleSK
"Storey, Robert (DCSO)" <RStorey@xxxxxxxxxxxxxxxxxx> 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?