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

Home -> Community -> Usenet -> c.d.o.misc -> Problems with Snapshot (ORACLE 8.1.5)

Problems with Snapshot (ORACLE 8.1.5)

From: Andre Klos <Andre.Klos_at_pikon.com>
Date: Mon, 19 Nov 2001 14:40:40 +0100
Message-ID: <9tb1tu$omt$1@piesbach.saarnet.de>


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é Klos
Received on Mon Nov 19 2001 - 07:40:40 CST

Original text of this message

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