Dears,
I have two database servers, one with an application and another one with apex installed. Let's call it DB1 and DB2. I have created a dblink on DB1 and can do selects from DB2 tables successfully using sqlplus. But how can I attach remote database schema to my workspace in Apex?
For example during creating a simple form on table Apex asks me to select a schema and the table after. But I only see local schemas. How can I make remote schemas to be available in Apex?