Hi all ,

I had two schemas both in different systems, the db_src1 and db_src2.

In which i want to get the tables from db_src1 to db_src2 . I had tried this by
creating dblink . But i get the TNS error while i try to access the table .

This is the error .

ORA-12154: TNS:could not resolve the connect identifier specified

help me to get rid of this.


Thanks

Vinodh,

Confidential: This electronic message and all contents contain information from Syntel, Inc. which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee only. If you are not the addressee, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify the sender immediately and destroy the original message and all copies.

Confidential: This electronic message and all contents contain information from Syntel, Inc. which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee only. If you are not the addressee, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify the sender immediately and destroy the original message and all copies.

Oracle LazyDBA home page