• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1141
  • Last Modified:

Database link to local machine

There are 2 databases, A and B on 2 machines in production.
We need to export/import these two databases on one single machine.
Production database A has a database link to B.
I would like to create the database link on test system in the database A so that it will point to database B on this same machine. I hope to avoid reports at importing by doing this and to make PL/SQL using the database link working on the test system.
Is possible to create a database link to the localhost database?
1 Solution
Theres no problem doing this - you can even point the database link back into the same instance if you so desire.
Your database link will have an alias specified that tells it where to connect to - this will be the bit specified in the USING clause of the CREATE DATABASE LINK command, or the HOST column in DBA_DB_LINKS view.

If you have sure you have this alias in your tnsnames.ora file (in the Oracle home that holds database A), that points to database B, it will be seamless.

You will need to build and import database B first if you wish to avoid errors at import time, so that the import of database A can verify any references to remote objects.

matejak, sure you can. You can create any link to other dbs.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now