5 Replies Latest reply on Sep 22, 2021 4:15 AM by Rajan Rath

    Moving BLOB data between Oracle tables

    Gopinath Vijayan Guru

      Hello,

       

      I have two tables with BLOB data type.

      I need to create a mapping/integration to load Table 1 into Table 2.

       

      Data Integration:

      When I imported table A into mapping, I see the data type for BLOB column as 'binary'. After running the program, I don't see BLOB data moved to Table B

       

      Application Integration:

      I tried to create a process . I am able to load few BLOB records but eventually failing with error

       

       

       

      Appreciate your help to move BLOB data between oracle tables either using Data Integration or Application Integration

       

      Thanks,

        This content has been marked as final.  Show 5 replies