Re: database link name

From: What's in a namespace <xml_at_ns.com>
Date: Mon, 11 Dec 2006 11:12:22 +0100
Message-ID: <457d2f06$0$320$e4fe514c@news.xs4all.nl>

"skyloon" <skyloon_at_gmail.com> schreef in bericht news:1165579250.530741.234220_at_80g2000cwy.googlegroups.com...
> 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?
>

Another post you might find helpfull:
news:1165588910.521207.77270_at_j44g2000cwa.googlegroups.com Received on Mon Dec 11 2006 - 04:12:22 CST