Oracle to MYSQL database link Out-Of-Memory

[Roshan Bisnath]

Hello Team,

Happy New Year 2019!

when querying a table with 3.5 billion records from Oracle to MYSQl databsase using database link, I am getting error below

SQL> create table bireport.data_charging2018 as (select * from mt.data_charging2018@bikwik);
create table bireport.data_charging2018 as (select * from mt.data_charging2018@bikwik)
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[MySQL][ODBC 8.0(a) Driver][mysqld-5.5.24]MySQL client ran out of memory
{HY000,NativeErr = 2008}
ORA-02063: preceding 2 lines from BIKWIK


Oracle database platform: Linux 6
SQL platform: Windows server 2008 R2

Please advise.

Regards,

Roshan