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