Create Snapshot Error (Oracle 8.1.5)

Hi!

I try to create a Snapshot with the following statement:

create snapshot SNAPSHOT_NAME
storage (initial 100K next 100K pctincrease 0) tablespace SYSTEM
refresh complete
start with TO_DATE('11/18/2001 2:00', 'MM/DD/YYYY HH24:MI') next TO_DATE('11/18/2001 2:00', 'MM/DD/YYYY HH24:MI') + 7 with ROWID
as select * from TABLE_NAME_at_DB_LINK;

I get the following error-message:

ORA-01435: user does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 870
ORA-06512: in Zeile 1

Can someone help me?

Gruss

--
André Klos

PIKON Deutschland AG
Kurt-Schumacher-Str. 28-30
D - 66130 Saarbrücken

Tel: (0681) 37962-0
Fax: (0681) 37962-90

http://www.pikon.com
mailto:andre.klos_at_pikon.com
_______________________________________