Hi All
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
I have a partitioned table, when the application developes they have made a GLOBAL indexes on this table. Previously whenever we use to run 'Alter Table add partition..' the global indexes becomes unusable and I used to rebuild the same. But since few months whenever we add partition (Alter Table ..ADD Partition ..) on this table, indexes won't get to unusable stat instead it shows as LOCAL indexes in data dictionaries (Lacality =Local in USER_PART_INDEXES). Also partitioned indexes are creating automatically with each table partition creation.
But the below query output shows Indexes are GLOBAL.
Select dbms_metadata.get_ddl('INDEX','ABCD','USER_A') from dual;
Can anybody helps me on this what actually happened here.