powercenter 工作流报错

来源:互联网 发布:淘宝宝马摩托车 编辑:程序博客网 时间:2024/05/18 00:49

问题

workflow运行的时候出现

ORA-26002: Table DATAPLAT_V152.DOCUMENT has index defined upon it.

解决

To bulk load into indexed tables, choose non-parallel mode. To do this, you must disable the Enable Parallel Mode option. Note that when you disable parallel mode, you cannot load multiple target instances, partitions, or sessions into the same table.
To bulk load in parallel mode, you must drop indexes and constraints in thetarget tables before running a bulk load session. After the session completes,you can rebuild them. If you use bulk loading with the session on a regularbasis, you can use pre- and post-session SQL to drop and rebuild indexes andkey constraints.



 

原创粉丝点击