i'm having this error message
while trying for the first time to read a DB2 as source and writing to an Oracle Target table
ORA- 17030. READ_COMMITTED and SERIALIZABLE are the only valid transaction levels ...
Can you please help
mor kane 06000220B6
Pinned topic ora-17030; error Message = READ_COMMITTED and SERIALIZABLE are the only..
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-01-27T18:52:07Z at 2011-01-27T18:52:07Z by mor kane
JP_Parkin 100000R2WA128 Posts
Re: ora-17030; error Message = READ_COMMITTED and SERIALIZABLE are the only..2011-01-26T14:34:47ZThis is the accepted answer. This is the accepted answer.Hi
Do you have some more detail about how you are implementing this solution? Are you using the Design Studio to create a data flow to perform the copy? Are you using a Table Target operator to write to Oracle? Do you have a sample data flow you can share to illustrate what you are trying to do?
mor kane 06000220B612 Posts
Re: ora-17030; error Message = READ_COMMITTED and SERIALIZABLE are the only..2011-01-27T18:52:07ZThis is the accepted answer. This is the accepted answer.
- JP_Parkin 100000R2WA
It was a setting problem at the Database level.
I mixed up the SQL Execution Schema, it s ok now!