Re: database link name

From: <fitzjarrell_at_cox.net>
Date: 8 Dec 2006 07:40:14 -0800
Message-ID: <1165592414.461891.106230@f1g2000cwa.googlegroups.com>

Charles Hooper wrote:
> skyloon wrote:
> > in oracle 9i, when I create database link, i put the name as CBSFAS,
> > after save it, the name will become CBSFAS.US.ORACLE.COM.
> >
> > when select * from <table name>@CBSFAS, it returns error
> > when select * from <table name>@CBSFAS.US.ORACLE.COM, it returns
> > result, any body know why? how to get only CBSFAS as my database link
> > name?
>
> If you create the database link using SQLPlus rather than OEM, you
> should be able to avoid this problem. For assistance with the syntax,
> see:
> http://www.oracle.com/pls/db102/ranked?word=create+dblink
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.

If you have global_names set to true you get this behaviour through OEM, and even with SQL*Plus you'll get an error if you don't use the fully qualified tns alias as a link name. Setting global_names to false 'corrects' this situation.

David Fitzjarrell Received on Fri Dec 08 2006 - 09:40:14 CST