sqlloader parallel调用报ORA-26002: table has index defined upon it.解决方法

ORA-26002: table has index defined upon it.

This issue is caused when using the bulk load option in parallel to load an Oracle target that has an index on it. An Oracle limitation.

To resolve this issue do one of the following:

• Change the target load option to Normal.
• Disable the enable parallel mode option in relational connection browser.
• Drop the indexes before loading.
• Or create a pre- and post-session sql to drop and create indexes and key constraints.