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

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle error 955 - creating snapshot

Re: oracle error 955 - creating snapshot

From: oem <eliang_at_asiansources.com>
Date: 28 May 1998 08:27:37 GMT
Message-ID: <01bd8a14$1dc57220$8c01a8c0@Ellen.sg.asiansources.com>


It needs not be a snapshot. Any object with the name can't be re-used, eg. tables, procedure, etc..

vasank_at_my-dejanews.com wrote in article <6khi86$o5m$1_at_nnrp1.dejanews.com>...
> I am trying to set up replication on Oracle 8.0.3 on Windows NT servers.
> Going thru the simple example (the first one) on the Oracle8 Server
> Replication manual, I have created the snapshot logs on the master. When
> trying to create the snapshot at the snapshot site I get the following
error:
>
> create snapshot "SCOTT"."DEPT" refresh fast with primary key as
> select * from "SCOTT"."DEPT"@ORACLE.WORLD
>
> /*****
>
> ORA-00955: name is already used by an existing object
>
> *****/
>
> I do not have any snapshots created at the snapshot site.
>
> Looking for any suggestions.
>
> Vasan.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Thu May 28 1998 - 03:27:37 CDT

Original text of this message

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