My Oracle Support Banner

Invalid Index During Direct Path Loading in REL (Doc ID 781169.1)

Last updated on AUGUST 28, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.0.0]
HP-UX PA-RISC (32-bit)


During REL execution in BRM 7.0, error messages being reported by various components of the application in the cm.pinlog indicating INVALID indexes on one of the EVENT_* tables. This has been traced to the direct path load option for IREL.

For example, in dm_oracle pinlog :

ORACLE error: do_sql_mr_select: OCIStmtExecute: code 1502, op -1
=ORA-01502: index 'PIN.I_EVENT_BI_ITEM_OBJ__ID' or partition of such index is in
unusable state

Steps To Reproduce

Try to load a large number of files via REL using SQLLDR "direct path".




To view full details, 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 a vibrant support community of peers and Oracle experts.