OWNER          COUNT(*)
rem ------------   ----------
rem OPS$ORACLE     64
rem SYS            70
rem SYSTEM         62
rem Add check that all Primary keys are unique ...
rem
set heading off
set feedback off
SELECT   ind.uniqueness, COUNT(*)
FROM     all_indexes ind
WHERE    ind.table_owner = 'OPS$ORACLE'  /* TABLE_OWNER */  
AND      ind.index_name  LIKE '%_PK'
GROUP    BY ind.uniqueness ;
rem Use Table Owner to avoid retrieving details of System and
other Tables ...
SELECT        
ind.table_name,tab.column_id,ind.index_name,col.column_name
FROM     all_ind_columns col, all_indexes ind,all_tab_columns
tab
WHERE    ind.table_owner = 'OPS$ORACLE'  /* TABLE_OWNER */
AND      ind.table_name  =  col.table_name 
AND      ind.table_name  =  tab.table_name 
AND      ind.table_name  = 'BW_CONTRACTS'  
AND      tab.table_name  = 'BW_CONTRACTS'  
AND      col.column_name =  tab.column_name 
AND      ind.index_name  =  col.index_name 
AND      ind.index_name  LIKE '%_PK'
AND      col.index_name  LIKE '%_PK'
ORDER    BY ind.table_name ,tab.column_id ,ind.index_name ;