Re: Where is the object (DBLINK) suffix come from?

"Jack Wang" <nospam_at_nospam.com> wrote in message news:<U1XTa.28921$xn5.4636499_at_news0.telusplanet.net>...
> set global_names = false in init.ora
>
> "Kin Ng" <kin_ng5_at_yahoo.com> wrote in message
> news:d5b3f600.0307241113.43baa05a_at_posting.google.com...
> > When I created a DBLINK, I got US.ORACLE.COM attached to the end of
> > the dblink name. Where is this suffix come from and how can I get rid
> > of it?
> >
> > Thanks for any help.

I have tried ALL the suggestions and still I am having problems.

Here's what I have:

• init.ora has no 'global_names' entry
• SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME = 'global_names' returns 'FALSE'. Thus no global name checking enforced
• SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME = 'db_domain' returns empty domain name.
• ALTER DATABASE RENAME GLOBAL_NAME To KINDB4 results in the same name i.e. if it was KINDB4.abc.com, then the result is the same.

Real problem is I can't change the domain name of the database name to nothing. I am able to change the domain name to something else. From I have read, the DBlink name's domain name comes from the Global_name's domain name. Thus I need to change the Global_name to get rid of the domain name. But I can't. Any idea? Received on Mon Jul 28 2003 - 15:08:22 CDT