Oracle Bulk Load in DataStage

Error message:

ora_write_SOR_RI,10: [IIS-CONN-ORA-001003] The OCI function OCIDirPathPrepare returned status -1. Error code: 2,373, Error message: ORA-02373: Error parsing insert statement for table UAT_SOR.RI.

ORA-01502: index 'UAT_SOR.RI_PK' or partition of such index is in unusable state. (CC_OraLoad::prepareDirectPathLoad, file CC_OraLoad.cpp, line 1,039)

Cause:

Bulk load into Oracle table with index and/or constraint and/or trigger

Solution:

Disable index and/or constraint and/or trigger before loading and enable them back.
Setting bulk load option in Oracle Connector Stage as follow.