Page 1 of 1
write fail to oracle table
Posted: Mon May 03, 2010 5:04 am
by krisna
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
Posted: Mon May 03, 2010 6:36 am
by chulett
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.
Posted: Mon May 03, 2010 6:57 am
by krisna
The table exists, I have given permissions also.
Posted: Mon May 03, 2010 7:12 am
by chulett
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?
Re: write fail to oracle table
Posted: Thu May 20, 2010 7:05 am
by samratisking
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..
Posted: Thu May 20, 2010 7:32 am
by ray.wurlod
Maybe you need to qualify the table name with a schema (owner) name.
Write Mode failure
Posted: Thu Jun 24, 2010 1:30 pm
by kartbeat2001
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
Posted: Thu Jun 24, 2010 5:04 pm
by ray.wurlod
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.
Posted: Thu Jun 24, 2010 6:53 pm
by keshav0307
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??