Solved

Database link to local machine

Posted on 2004-07-30
2
1,123 Views
Last Modified: 2013-12-11
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?
0
Comment
Question by:matejak
2 Comments
 
LVL 7

Accepted Solution

by:
BobMc earned 125 total points
ID: 11685352
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.

HTH
Bob
0
 
LVL 8

Expert Comment

by:baonguyen1
ID: 11722719
matejak, sure you can. You can create any link to other dbs.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now