Error when creating a snapshot.

[MarkWilliamson]

I am trying to create a snapshot, selecting from view MYWIEW. I am receiving error "ORA-00955 name is already used by an existing object."

I do not have duplicate object names and am at wits end on how to get this to run. Any help would be greatly appreciated !!!




CREATE SNAPSHOT SCHEMA.MYSNAP
PCTFREE 2 PCTUSED 60 STORAGE ( INITIAL 256K NEXT 256K MAXEXTENTS UNLIMITED ) NOLOGGING
TABLESPACE "MYTABLESPACE"
BUILD IMMEDIATE
USING INDEX TABLESPACE "MYTABLESPACE"
REFRESH COMPLETE
ON DEMAND
AS
SELECT FIELD1, FIELD2
FROM SCHEMA.MYVIEW
/

 

[SantaMufasa]

Mark,

Logged in as the owning schema, try this:

select object_name, object_type
from user_objects
where object_name = 'MYSNAP';

If it results in "no rows selected", then try your code again, but with this wording:

CREATE [B]OR REPLACE[/B] SNAPSHOT...

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA @ 17:51 (06Oct04) UTC (aka "GMT" and "Zulu"), 10:51 (06Oct04) Mountain Time)

 

[MarkWilliamson]

Nope. Having the same problem. I even tried renaming the view in which the snapshot uses.