write fail to oracle table

krisna · Post by **krisna** » Mon May 03, 2010 5:04 am

Hi All,

I have two instances for source(CLMGMDDB) and for target(GMSOWNER). For this iam using oracle enterprise stage as both source and target. Its compiling successfully. But job execution is aborted because of this error.
Oracle_Enterprise_10: Write mode failure: SRVC_TEST does not exist.

I have given all the privileges to target user.
write method = load
write mode = append.

Thanks in advance

chulett · Post by **chulett** » Mon May 03, 2010 6:36 am

SRVC_TEST would be what, your target table? If it "does not exist" then you've either spelled it wrong, not specified the proper owner/schema or don't have the grants you need.

krisna · Post by **krisna** » Mon May 03, 2010 6:57 am

The table exists, I have given permissions also.

chulett · Post by **chulett** » Mon May 03, 2010 7:12 am

Keep looking. Since you didn't mention it, have you verified the owner is properly specified? Involved your DBA to see if they can help?

samratisking · Post by **samratisking** » Thu May 20, 2010 7:05 am

krisna wrote:Hi All,

I have two instances for source(CLMGMDDB) and for target(GMSOWNER). For this iam using oracle enterprise stage as both source and target. Its compiling successfully. But job execution is aborted because of this error.
Oracle_Enterprise_10: Write mode failure: SRVC_TEST does not exist.

I have given all the privileges to target user.
write method = load
write mode = append.

Thanks in advance

Hi Krisna,

Please let me know how this issue was resolved. Getting the same error here too. Thanks Buddy..

ray.wurlod · Post by **ray.wurlod** » Thu May 20, 2010 7:32 am

Maybe you need to qualify the table name with a schema (owner) name.

kartbeat2001 · Post by **kartbeat2001** » Thu Jun 24, 2010 1:30 pm

I am also getting the same error . Please see below

ORA_GSOS_ADT: Write mode failure: SOS_ADT_ODS_TEMP does not exist.

But actually this table exists and i am able to query/insert through Toad

Actually the same job works well in Development server . But when I export/import into UAT Server , its not working . Someone please help ASAP

Thanks,
Karthick B

ray.wurlod · Post by **ray.wurlod** » Thu Jun 24, 2010 5:04 pm

We don't do ASAP. If you need a rapid response, sign up for priority service with your official support provider and learn just how much "urgent" costs. DSXchange is an all-volunteer site whose members post as and when they can.

You have also hijacked an already resolved thread, another practice that is frowned upon in DSXchange. You should have opened a new thread for your problem (after all your version, etc., may be different). Even before that, you should have performed a Search of DSXchange, or simply read this thread with a bit more care.

keshav0307 · Post by **keshav0307** » Thu Jun 24, 2010 6:53 pm

Actually the same job works well in Development server . But when I export/import into UAT Server , its not working . Someone please help ASAP

are you using the same Oracle user and same database in UAT server also??

DSXchange

write fail to oracle table

write fail to oracle table

Re: write fail to oracle table

Write Mode failure