I want to create mview from mysql to Oracle using DBLink via odbc driver with Linux 64 bit os. but due to large number of Records around 2.5 cr records it raise the error

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][MySQL][ODBC 5.3(a)
Driver][mysqld-5.7.25-log]MySQL client ran out of memory (SQL State: HY000; SQL
Code: 2008)
ORA-02063: preceding 2 lines from dblink1

I am Using Oracle Database 12c Standard Edition Release - 64bit Production .

mview Syntax :-


I know the question was repeated , but tried all things but result is zero that's why i posted my scenario.

Is there any solution for this ?

let me know if any extra detail required

  • Sounds like some kind of space limitation in odbc or mview or oracle. MySQL will happily stream an arbitrarily large table requested via SELECT * FROM m2. The MATERIALIZED VIEW on the other side needs storage somewhere. (I don't know those details.) – Rick James Apr 21 '19 at 18:47
  • @RickJames , i already checked at oracle side & given full space & everything but i think issue is at the odbc space limitation . – vvs Apr 24 '19 at 10:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.