title: How to query tables and pull data into an Oracle APEX application from another schema?
body: <p>I am working in an Oracle APEX application and am trying to query tables in another schema (that another Oracle APEX application sits on) to pull in data to my application.</p>
  
  <p>The applications are hosted within the same APEX workspace and on the same Oracle 11g instance. Our application have tables that are structurally the same as the tables we're trying to query in the other schema.</p>
  
  <p>Using the schema prefix (SELECT * FROM "SCHEMA2".TABLE1;) when querying is throwing an error that the tables do not exist (ORA-00942: table or view does not exist)</p>
  
  <p>The second thing I tried is creating a database link between the two schemas, but when trying to establish the connection I'm getting the following error: ORA-01031: insufficient privileges</p>
  
  <p>Can someone identify where I'm going wrong here / help me figure out how to query the other schema?</p>