Monday, 19 September 2016

Informatica Error: ORA-26002

Sometime we may get an error while running a Informatica Session.

Error:

ORA-26002: Table XX_TABLE_NAME has index defined upon it.

Reason: Mode is set to Bulk.

Solution: Change the mode to Normal.

Enjoy and stay well !!




-
Labels:

1 comment:

  1. hameed20 December 2021 at 09:30

    I find same workflow completes in DB1 and it fails with error "ORA-26002: Table XX_TABLE_NAME has index defined upon it" when using Bulk mode.
    Can someone explain this ?

    ReplyDelete

Subscribe to: Post Comments (Atom)

Power BI: Show Last Data Refresh on Dashboard

 To show last data refresh on Power BI report follow the below steps. 1. Open Report Query Editor Mode. 2. Clink on Get Data -> Blank...