write fail to oracle table
Moderators: chulett, rschirm, roy
write fail to oracle table
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
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
-
- Participant
- Posts: 37
- Joined: Tue Jan 29, 2008 6:03 am
- Location: Guntur
- Contact:
Re: write fail to oracle table
Hi Krisna,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
Please let me know how this issue was resolved. Getting the same error here too. Thanks Buddy..
Samratisking
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 5
- Joined: Wed Jun 18, 2008 8:50 am
Write Mode failure
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia