database link name

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? Received on Fri Dec 08 2006 - 06:00:50 CST