DBA Data[Home] [Help]

SYS.PATCH_XDB$RESOURCE_T dependencies on DBA_INDEXES

Line 19: select count(*) into found_XDBHI from DBA_INDEXES

15: and ATTR_NAME = 'CHECKEDOUTBYID';
16: select attr_no into attr_no_BV from DBA_TYPE_ATTRS
17: where owner = 'XDB' and TYPE_NAME = 'XDB$RESOURCE_T'
18: and ATTR_NAME = 'BASEVERSION';
19: select count(*) into found_XDBHI from DBA_INDEXES
20: where owner = 'XDB' and TABLE_NAME = 'XDB$RESOURCE'
21: and INDEX_NAME = 'XDBHI_IDX';
22:
23: -- correct attribute order: RCLIST < CHECKEDOUTBYID < BASEVERSION