Topic
  • 2 replies
  • Latest Post - ‏2011-01-27T18:52:07Z by mor kane
mor kane
mor kane
12 Posts

Pinned topic ora-17030; error Message = READ_COMMITTED and SERIALIZABLE are the only..

‏2011-01-21T16:23:52Z |
Hi guys,

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

Thanks
Updated on 2011-01-27T18:52:07Z at 2011-01-27T18:52:07Z by mor kane
  • JP_Parkin
    JP_Parkin
    128 Posts

    Re: ora-17030; error Message = READ_COMMITTED and SERIALIZABLE are the only..

    ‏2011-01-26T14:34:47Z  
    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?

    Best regards,
    JP
  • mor kane
    mor kane
    12 Posts

    Re: ora-17030; error Message = READ_COMMITTED and SERIALIZABLE are the only..

    ‏2011-01-27T18:52:07Z  
    • JP_Parkin
    • ‏2011-01-26T14:34:47Z
    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?

    Best regards,
    JP
    Hi Jean Paul,
    It was a setting problem at the Database level.
    I mixed up the SQL Execution Schema, it s ok now!
    Thanks

    MKane