Oracle Fast Load

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
mab_arif16
Charter Member
Charter Member
Posts: 87
Joined: Sat Mar 18, 2006 11:45 pm

Oracle Fast Load

Post by mab_arif16 »

I am trying to use the fast load option in oracle enterprise stage ,are there any special things that need to taken care of before using it .
As I am getting index errors
Oracle_Enterprise_8: Indexes on table 'thk.track' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.,I coudnt find any option in stage to include or drop indexes.
Thanks
Arif
thompsonp
Premium Member
Premium Member
Posts: 205
Joined: Tue Mar 01, 2005 8:41 am

Post by thompsonp »

This stage uses Oracle's sql loader.
Under the 'Options' category in the 'Properties' tab you need to select 'Index Mode' and then specify what you want to do with the indexes on the table you are loading.

As the error message states you either need to do this or drop the indexes first.
Post Reply