1 Reply Latest reply: Sep 10, 2013 3:29 PM by Jeff Smith Sqldev Pm-Oracle RSS

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

    user10730043

      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.