Silly question about GENERATED column of DBA_INDEXES

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Fri, 12 Aug 2016 21:08:27 +0100
Message-ID: <4A3A3C44-634B-4C02-A85E-8A92B1DA8902_at_dunbar-it.co.uk>



Try as I might, I cannot get the "generated" column on user/all/dba _ indexes to take on any value other than 'N'.

I thought it was set to 'Y' if the index was system created, and indeed, that's what the docs state. However, I have run a few tests creating pk and unique constraints, without pre creating the supporting index, and the value remains stubbornly set to 'N'.

Ditto when the creation of an MVIEW crews a new primary key, the underlying index still flags as not system generated.

I admit to being puzzled! Can someone please enlighten me? Thanks.

Cheers,
Norm.

--

Sent from my Android device with K-9 Mail. Please excuse my brevity.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 12 2016 - 22:08:27 CEST

Original text of this message