I believe the problem is in syntax you define db link. Another:
you can't create objects on other side of db link.

So:
- create dblink on instance where you want to create objects:

"create database link <dbln-name> connect to <remote-user> identified by
<remote-password> using '<remote-service-name>';"

( <remote-service-name> should be equal as it appears in your
tnsnames.ora )

- create table by table:

"create table <table-1> as select * from <table-1>@<dbln-name>;"

Now you have all tables with their data and not null constraints, but
nothing else.
All other constraints, triggers, views, indexes, program modules ... are
missing.

Advice:

Use exp / imp!

KAzi

Nagarajan VinodhKumar wrote:
> 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.
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>



Oracle LazyDBA home page