1 Reply Latest reply on Sep 10, 2013 8:29 PM by thatJeffSmith-Oracle

    Copying table DB2 data to Oracle fails with reference to 'fullyMaterializeLobData' property


      Copying table data from DB2 to Oracle fails with the following error message: Table xxxx Failed. Message: Attempt to fully materialize lob data that is too large for the JVM.  Disable data source property "fullyMaterializeLobData" for locator-based lob implementation.


      Specs on the computer are the following:
      java version "1.7.0_07"
      Java(TM) SE Runtime Environment (build 1.7.0_07-b11)
      Java HotSpot(TM) 64-Bit Server VM (build 23.3-b01, mixed mode)

      Windows 7 Professional
      System type: 64-bit Operating System
      Installed memory (RAM):    2.00GB

      The largest blob found is 1 GB.  Do we need to increase the heap size?  Any comments would be appreciated - thanks.