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 *



      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!