Re: Creating a database link to itself?

Hi,

yes it is possible to use a db link to point itself, you just need to create the database link (eg db2) with the correct sqlnet descriptor in tnsnames.ora, and ensure that the global_names init.ora parameter is set to false

HTH NeilC
gmwils_at_zark.thedonkeys.org wrote in message <380ac804$0$252_at_quirk.zark.thedonkeys.org>...
>I am trying to create a database link that points to the current database
>using Oracle 8.0.5 under linux. What I'm wanting to do is to be able to
refer
>to the current database as a different name. Say the current database is
>called db1, then I want to be able to do something like:
>
>select * from table1_at_db2;
>
>Where db2 is a database link that points to db1. The reasoning behind this
is
>that we are developing an application for a client that has multiple
instances
>of Oracle running on multiple servers and would like to replicate this
>environment using a single Oracle instance.
>
>Is this possible at all?
>
>Geoff
>
>--
> a paranoid is just someone with all of the facts at his disposal
> - william seaward burroughs 1914-1997
>
>Geoff M. Wilson <gmwils_at_zark.thedonkeys.org>
www.zark.thedonkeys.org/~gmwils Received on Mon Oct 18 1999 - 02:56:49 CDT