2 Replies Latest reply: Jan 11, 2011 4:23 AM by jmorate21 RSS

    How to call a table with oracle dblink

      Hi, I need to select data from a table in Oracle which is linked by dblink:

       

       

      SELECT *

      FROM "MYSCHEMA"."VIEW01@OTHER_SCHEMA";



       

      When I try to reload script, it throws an Oracle error:

      SQL Error:[Oracle][ODBC][Ora]ORA-00942: table or view doesn't exist

      I'm trying to avoid the creation of more views inside MYSCHEMA.

      Is that possible?

      Thank you!