Re: Create Snapshot Error (Oracle 8.1.5)

"Andre Klos" <Andre.Klos_at_pikon.com> wrote in message news:9tafcm$82d$1_at_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?
>
> 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
> _______________________________________
>
>

There is a problem with the user specified in the db_link definition

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address