index problem in oracle

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
siva4joy
Premium Member
Premium Member
Posts: 34
Joined: Fri Apr 14, 2006 6:10 am
Location: London

index problem in oracle

Post by siva4joy »

i am loading the data in to oracle using oracle stage.
i am uisng the properties disable constraints and index rebuild.
but i am getting the following warning.

Tgt_Bada_Consistency_Res: When checking operator: There are no indexes on table 'BADA_OWNER.BADA_CONSISTENCY_RES' and an index option was included. The index option will be ignored.

even though the index was dropped and recreated.

can anybody tell me why this is happening.

thanks for your help.
Post Reply