Re: database link name

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 8 Dec 2006 04:25:43 -0800
Message-ID: <1165580743.282075.256380@f1g2000cwa.googlegroups.com>

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. Received on Fri Dec 08 2006 - 06:25:43 CST