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 7.0.0.0.0 to 7.0.0.0.1 [Release 7.0.0]
HP-UX PA-RISC (32-bit)

Symptoms

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".

Changes

 

Cause

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.