Oracle Enterprise load error

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

DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

In your enterprise stage. There has to be an option to specify whether the table has indexes on it or not. I think you need to set that to Yes. I dont have access to PX at the moment. Try to locate it in your properties.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
mab_arif16
Charter Member
Charter Member
Posts: 87
Joined: Sat Mar 18, 2006 11:45 pm

Post by mab_arif16 »

DSguru2B wrote:In your enterprise stage. There has to be an option to specify whether the table has indexes on it or not. I think you need to set that to Yes. I dont have access to PX at the moment. Try to locate it in your properties.
I used the rebuild index option ,but got the error
Oracle_Enterprise_8: Disk locality is impossible, as the target tablespace is not local to a node in the configuration file;
performance may not be optimal.
Oracle_Enterprise_8: APT_OraInstanceSet::setup() failed to find an Oracle instance on node node1;
the hostname is `admin1'.
Thanks
Arif
Post Reply