Clarification on BRM Table Index (Doc ID 2100428.1)

Last updated on FEBRUARY 25, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

On : 7.5.0.9.0 version, Event Management

Clarification on BRM(Billing and Revenue Management) table index

In event_t, event_essentials_t and event_item_transfer_buf_t there are unique indexes which doesn't link to a column:

INDEX_NAME INDEX_ TABLE_NAME UNIQUENESS STATUS
------------------------------ ------ ------------------------------ ------------ ------------
SYS_IL0000133095C00003$$ LOB EVENT_ESSENTIALS_T UNIQUE N/A
SYS_IL0000133431C00003$$ LOB EVENT_ITEM_TRANSFER_BUF_T UNIQUE N/A
SYS_IL0000133275C00084$$ LOB EVENT_T UNIQUE N/A


select COL.* from USER_INDEXES IND, USER_IND_COLUMNS COL
where IND.table_owner='PIN'
and IND.index_name like '%SYS%'
and IND.table_name ='EVENT_T'
and IND.INDEX_NAME=COL.INDEX_NAME;

I_EVENT_EVENT__NO EVENT_T EVENT_NO 1 60 60 ASC
I_EVENT__SERVOBJ_END_T EVENT_T END_T 2 22 0 ASC
I_EVENT__SERVOBJ_END_T EVENT_T SERVICE_OBJ_ID0 1 22 0 ASC
I_EVENT__ACCTOBJ_END_T EVENT_T END_T 2 22 0 ASC
I_EVENT__ACCTOBJ_END_T EVENT_T ACCOUNT_OBJ_ID0 1 22 0 ASC
I_EVENT_ITEM_OBJ__ID EVENT_T ITEM_OBJ_ID0 1 22 0 ASC
I_EVENT__ID EVENT_T POID_ID0 1 22 0 ASC

But for index SYS_IL0000133275C00084$$, no rows found


Are we using these indexes ?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms