395: SELECT di.OWNER,
396: di.index_name,
397: di.table_name,
398: decode(di.uniqueness, 'UNIQUE', ' UNIQUE ', ' ')
399: FROM dba_indexes di
400: WHERE di.table_owner = tableOwner
401: AND di.owner = indexOwner
402: AND di.table_name = tableName;
403:
2128:
2129: CURSOR dbaIndexes(tabName varchar2,
2130: tabOwner varchar2) is
2131: SELECT INDEX_NAME
2132: FROM DBA_INDEXES
2133: WHERE TABLE_NAME = tabName
2134: AND TABLE_OWNER = tabOwner;
2135:
2136:
2259:
2260: CURSOR dbaIndexes(tabName varchar2,
2261: tabOwner varchar2) is
2262: SELECT INDEX_NAME
2263: FROM DBA_INDEXES
2264: WHERE TABLE_NAME = tabName
2265: AND TABLE_OWNER = tabOwner;
2266:
2267: l_partitionID NUMBER;
2420: is
2421: CURSOR dbaIndexes(tabName varchar2,
2422: tabOwner varchar2) is
2423: SELECT INDEX_NAME
2424: FROM DBA_INDEXES
2425: WHERE TABLE_NAME = tabName
2426: AND TABLE_OWNER = tabOwner;
2427:
2428: