4 Replies Latest reply: May 28, 2014 9:41 AM by Turloch O'Tierney-Oracle RSS

    Table data not migrated

    vinesh mashetty

      Hi to all,

      im getting some issue while migrating the table data from mysql to oracle.

      im using sql developer 4.0 for migration.

      here out of 720 tables i got data in 450 tables only,rest are empty.

      i have found some error in my log as follows

       

      Failed to move data: Streaming result set com.mysql.jdbc.RowDataDynamic@109f37d is still active.

      No statements may be issued when any streaming result sets are open and in use on a given connection.

      Ensure that you have called .close() on any active streaming result sets before attempting more queries.

       

      im running on windows 7 32bit os, oracle 10g.

       

      could anybody help me.