Oracle write mode failure

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
sureshabbisetti
Participant
Posts: 21
Joined: Thu Oct 04, 2007 4:34 am
Location: India
Contact:

Oracle write mode failure

Post by sureshabbisetti »

Hi,

I am facing problem with oracle truncate & load. My source is coming from one database and target is another database. The tnsnames entries for two databases were stored in same directory ds_home. Eventhough I am getting error: Write mode failure.
But I have tried to load the target by the scenario like oraclestage-Dataset-Oracle stage. In this way my job was successfully loading the target table.

Please any one could you help to reslove this issue.

Regards
Suresh
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Do you have relevant permissions to load?
dipanzan
Participant
Posts: 5
Joined: Thu Mar 19, 2009 12:33 pm

Post by dipanzan »

please post the exact error as seen in the director log..
Dipanjan
Post Reply