SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating a database link to another schema in the same database

RanieriOct 14 2009 — edited Oct 14 2009

Hello,

I'm trying to create a database link to another schema in the same database. It was created without errors, but when I try to use it I receive "ORA-12154: TNS:could not resolve the connect identifier specified" message...

I'm trying to do it because on my production enviroment the databases are separated, so there I can use database links without problem, but in my development environment it's all in one database separated by schemas...
So I'm trying to simulate the same system to not need to rewrite the query every time I move from development to production environment.

Any ideas?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 11 2009

Added on Oct 14 2009

7 comments

4,888 views