Hi Gurus,
ODI fails due to
ORA-00968: missing INDEX keyword (from the W_ETL_EVENT_LOG), table, when I debug it, it's trying to execute the below command:
CREATE BITMAP UNIQUE INDEX DEV1_DW.WC_RECEIPT_F_U1 ON DEV1_DW.WC_RECEIPT_F (DATASOURCE_NUM_ID, INTEGRATION_ID) PARALLEL NOLOGGING;
SQL Error: ORA-00968: missing INDEX keyword
00968. 00000 - "missing INDEX keyword"
as we can see the command is not correct as BITMAP and UNIQUE cannot work together.
I did create the Index manually on the table removing the BITMAP command, but ODI generating the above command. Do we have any way where ODI while running the interface will not use the BITMAP command and use
CREATE UNIQUE INDEX DEV1_DW.WC_RECEIPT_F_U1 ON DEV1_DW.WC_RECEIPT_F (DATASOURCE_NUM_ID, INTEGRATION_ID) PARALLEL NOLOGGING;
Note: The same interface ran successfully in the other Development Environment from where I did a SMART Export Import.
Quick help will be much appreciated.
Thanks
Amit