Dear Sir,
we observed duplicate index unique/nonunique as well from oracle dictionary tables with the following query.
Is there any discrepencies ????, Pls. correct me if I am wrong and also guide me, due to the following dictionary statistics
oracle allowed/kept duplicate rows ????...
In unique index key columns got duplicate rows since, index rebuild got failed while doing our compression activity.
FYI : MANDT,DOCUNUM,LOGDAT,LOGTIM,COUNTR is the unque index key columns
13:28:07 20-JUL-2014 at rbq> select dc.index_name,dc.column_name,di.table_name,di.uniqueness,di.owner
13:28:07 2 from dba_ind_columns dc, dba_indexes di
13:28:07 3 where di.table_name = 'EDIDS' AND di.owner = 'SAPSR3' and dc.index_owner = 'SAPSR3'
13:28:07 4 --and dc.index_name = di.index_name
13:28:07 5 and dc.index_name = 'EDIDS~0'
13:28:07 6 and di.table_name = dc.table_name
13:28:07 7 /
INDEX_NAME COLUMN_NAM TABLE_NAME UNIQUENES OWNER
------------ ---------- ---------- --------- ------------------------------
EDIDS~0 MANDT EDIDS NONUNIQUE SAPSR3
EDIDS~0 MANDT EDIDS NONUNIQUE SAPSR3
EDIDS~0 MANDT EDIDS UNIQUE SAPSR3
EDIDS~0 DOCNUM EDIDS NONUNIQUE SAPSR3
EDIDS~0 DOCNUM EDIDS NONUNIQUE SAPSR3
EDIDS~0 DOCNUM EDIDS UNIQUE SAPSR3
EDIDS~0 LOGDAT EDIDS NONUNIQUE SAPSR3
EDIDS~0 LOGDAT EDIDS NONUNIQUE SAPSR3
EDIDS~0 LOGDAT EDIDS UNIQUE SAPSR3
EDIDS~0 LOGTIM EDIDS NONUNIQUE SAPSR3
EDIDS~0 LOGTIM EDIDS NONUNIQUE SAPSR3
EDIDS~0 LOGTIM EDIDS UNIQUE SAPSR3
EDIDS~0 COUNTR EDIDS NONUNIQUE SAPSR3
EDIDS~0 COUNTR EDIDS NONUNIQUE SAPSR3
EDIDS~0 COUNTR EDIDS UNIQUE SAPSR3
Thanks in Advance,
Sivakumar KS.