Oracle Database Links
Creating a database link
The remote DB will then be accessible in the following way:
To test a database link connection without needing to know any of the object names in the linked database, use the following query:
To explicitly specify a domain for the linked database service, the domain name is added to the USING statement. For example:
If no domain name is explicitly specified, Oracle uses the domain of the database in which the link is being created.