Re: Read-only snapshot problem with service name

I think you have problems with your db-link definition, not with the snapshot. Check your init parameter GLOBAL_NAMES and see if it is set to TRUE. If it is, you must name your db-link with the name of the database your link is pointing to.

Regards,

Jurij Modic				Republic of Slovenia
tel: +386 61 178 55 14			Ministry of Finance
fax: +386 61  21 45 84			Zupanciceva 3
e-mail: jurij.modic_at_mf.sigov.mail.si	Ljubljana 1000

On Wed, 28 May 1997 10:01:13 +0200, Jan-Olav Eide <Jan.Olav.Eide_at_nr.no> wrote:

>I am trying to create a read-only snapshot, using the following
>commands:
>
>SQL > create database link austin connect to janolav identified by
>janolav using 'austin';
>SQL > create snapshot test as select * from test_at_austin;
>
>giving the error message ORA-12154: TNS:could not resolve service name.
>
>I am, however, able to connect to the other database using the same
>service name from
>SQL*Plus : SQL> connect janolav/janolav_at_austin
>
>so the tnsnames.ora file seems to be OK ?
>
> [SNIP]
>
>Jan-Olav Eide Research Scientist
>Norwegian Computing Center Phone : 22852646, Fax : 22697660
>Gaustadalléen 23, P.O Box 114 Email : Jan.Olav.Eide_at_nr.no
>Blindern, 0314 Oslo, Norway http://www.nr.no/home/janolav/joe.html
>
Received on Wed May 28 1997 - 00:00:00 CDT