Hi,

The TNSname entries are right . And i had created the DBlink in the second
schema , but i'm getting the same error .



Thanks,

Vinodh.





-----Original Message-----
From: Vijayakumar K - DBA(Data Center) - SIS
[mailto:oracledba-ezmlmshield-x64338109.[Email address protected]
Sent: Wednesday, March 05, 2008 1:11 PM
To: LazyDBA Discussion
Subject: RE: Regarding Database Schema .


Dear Nagaraj

The error shows that the tns entry is not there .
Try tnsping <servername> first and if it resolves

Regards
Vijayakumar K

-----Original Message-----
From: Nagarajan VinodhKumar [mailto:oracledba-ezmlmshield-x72841436.[Email address protected]
Sent: Wednesday, March 05, 2008 12:59 PM
To: LazyDBA Discussion
Subject: Regarding Database Schema .



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.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Visit us at www.sundaraminfotech.in

This E-mail may contain privileged information and is intended solely for the addressee, and any disclosure of this information is strictly prohibited, and may be unlawful. If you have received this mail by mistake, please inform us immediately and delete this mail. Any information expressed in this mail does not necessarily reflect the views of SUNDARAM INFOTECH SOLUTIONS. As per SUNDARAM INFOTECH SOLUTIONS's policy, unencrypted mail via Internet is not considered secure.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



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