Assign Schema from another Database

Soofi

Hi Experts,

I am using APEX 5 in Oracle 12c Database (db version 1).

I have two TNS Configured db too.

I have a query regarding workspace to schema assignments.

In that screen I usually see the schema installed in my db.

As I know APEX have a direct relationship with DB, and wont allow other db schema's to get interfered by any means.

Is that possible to have the schemas from another db and assign the same to a workspace?

Kiran Pawar

Hi Soofi,

Soofi wrote:

Hi Experts,

I am using APEX 5 in Oracle 12c Database (db version 1).
I have two TNS Configured db too.

I have a query regarding workspace to schema assignments.
In that screen I usually see the schema installed in my db.
As I know APEX have a direct relationship with DB, and wont allow other db schema's to get interfered by any means.
Is that possible to have the schemas from another db and assign the same to a workspace?

     No, you cannot assign schemas from another database. This is possible using DB links.

     Refer :

• http://docs.oracle.com/cd/E59726_01/doc.50/e39151/adm_mg_wrkspc.htm#AEADM245
• Accessing database/schema on another server...
• express - Can OracleXE's APEX access another Oracle Database (10g) on the same Server, or is it Restricted to those User…
• http://docs.oracle.com/cd/E59726_01/doc.50/e39147/advnc_db_link.htm#HTMDB13001

Regards,

Kiran

Jitendra

Hi Soofi,

Soofi wrote:

Hi Experts,

I am using APEX 5 in Oracle 12c Database (db version 1).
I have two TNS Configured db too.

I have a query regarding workspace to schema assignments.
In that screen I usually see the schema installed in my db.

As I know APEX have a direct relationship with DB, and wont allow other db schema's to get interfered by any means.

Is that possible to have the schemas from another db and assign the same to a workspace?

You can access the data by creating database link to the other database.

Check this link : Accessing Data with Database Links

if you want to access data from other database then check this blog :  APEX application running on "another" database

Hope this helps you,

Regards,

Jitendra