Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Problems with Snapshot (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?
Thanks
-- André KlosReceived on Mon Nov 19 2001 - 07:40:40 CST
![]() |
![]() |