Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Where has my .world extension gone

Re: Where has my .world extension gone

From: Bob Bain <bob.bain_at_markelintl.com>
Date: Mon, 2 Apr 2001 15:05:09 +0100
Message-ID: <6J%x6.53$h45.838@news.uk.colt.net>

Yeah, apart from there is a documnetation bug, which states that DB_DOMAIN is defaulted to world.

What are you supposed to do in a situation like that.

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:tc71114dkse1d2_at_beta-news.demon.nl...
>
> "Bob Bain" <bob.bain_at_markelintl.com> wrote in message
> news:PxHw6.23$h45.515_at_news.uk.colt.net...
> > OK, don't know if this has been asked before but I'm going to ask it
 anyway
> >
> > On an Oracle 7.3.4.5.0 instance I do the following
> >
> > CREATE PUBLIC DATABASE LINK lnk
> > CONNECT TO user IDENTIFIED BY pwd USING 'db_link.world';
> >
> > I can then access remote tables by using either :-
> >
> > SELECT * FROM TABLE_at_lnk or SELECT * FROM TABLE_at_lnk.world
> >
> > Both work just as well, even if I define the database link with a .world
> > extension.
> >
> > If I look in DBA_DB_LINKS then my DB_LINK has automatically had a .world
> > extension added to it if I havn't used one.
> >
> > Now on to Oracle 8.1.6:-
> >
> > I do exactly as above but if I don't put the .world extension on then I
 can
> > only reference remote tables using @lnk, if I do put the .world
 extension
 on
> > the I can only reference remote tables using @lnk.world.I can't use
 both.
> >
> > DBA_DB_LINKS has or hasn't the .world extension depending on whether I
 have
> > or have not used it.
> >
> >
> > Could someone please tell me what is going on. I have checked my
 sqlnet.ora
> > file and NAMES.DEFAULT_DOMAIN is set to world. I can't see any init.ora
> > parameters that I have to set.
> >
> > Anyone got any ideas??
> >
> >
>
> .world has gone as documented in the release notes.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Mon Apr 02 2001 - 09:05:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US