Create DB Link To From Apex To Another Oracle Database

A database link is a schema object in one database that enables you to access objects on another oracle database. Once you have created the database link you can access the remote objects by appending @dblink to the table or view name where dblink is the name of the link you specify on this page. Below are the steps for creating dblink from oracle apex


1- Login to your apex instance

2- Go to object browser



3- From right side open drop down menu as shown in image and select "Database Link"



4- Afterwards enter details for the connection , click next then click Create Db Link



5- You can test your link afterwards by clicking Test button as shown below

  • dblink, apexdb
  • 31 Users Found This Useful
Was this answer helpful?

Related Articles

Get Client IP Address

To get the IP address of client accessing the Apex application through browser you can use below...

Error: Invalid Websheet Objects

If you try to create Oracle Apex Websheet application for first time in your apex account you may...

Resetting Workspace Password

Go to your_registered_domain.com/apex click on Reset Password link highlighted in below image...