may i know how to set the global_names to false?
where to set it?
thanks...
fitzjarrell_at_cox.net wrote:
> 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 - 20:42:59 CST
