Copying tables from one DB to another via database link

I want to set up a database link to copy tables from one database to another. I followed all the steps: changed global_name to TRUE in init.ora, modified the TNSNAMES.ORA file, setup remote database link. However when I want to copy the tables using the link, it still comes out: ORA-12154: TNS: could not resolve service name. My question is after I change the parameter in these files, should I restart the database? Or are there any other steps I should do? Could you please help me?

    Requires Free Membership to View

    Login

You do not need to restart the database to fix your problem. But you must correctly configure your TNSNAMES.ORA file. One thing that people don't understand about database links is that it will only look in $ORACLE_HOME/network/admin for a TNSNAMES.ORA file. And this file must reside on the server that the database is running! So correctly configure this file in this location for your database links. I always test database links by issuing the following query: 

SELECT sysdate FROM dual@remotedb;
If I get the results back, then the link is working fine. Otherwise, fix the corresponding error.

For More Information


This was first published in September 2002

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top