Snapshot problem on Oracle 8.0.5.1 (urgent)

From: Ho Yat-Fan <fanho_at_my-deja.com>
Date: Mon, 16 Aug 1999 17:17:30 GMT
Message-ID: <7p9h2t$da8$1@nnrp1.deja.com>

Hello all,

I created a snapshot using a database link from Oracle 8.0.5.1 (on WinNT) to Oracle 7.3.4 using the following statement:

CREATE SNAPSHOT BUS_DEVICE_HISTORY
TABLESPACE STAB_TS
REFRESH FORCE
START WITH SYSDATE
NEXT SYSDATE+1
WITH ROWID
AS SELECT * FROM BUS_DEVICE_HISTORY_at_kcerop_link.WORLD;

It's successful and there is also no errors when I issue (using SYS) "exec dbms_snapshot.refresh_all;"

However, if I use "select to_char(start_with,'YYYYMMDD') from dba_snapshots". I observer the strange thing that the date appears to be 00000000. I tried methods like altering the snapshot with "start_with" being '17-AUG-1999' but something strange such as 19627968 (something like this) appears and also that the dbms_snapshot.refresh_all did not really successfully get the remote data.

Any advice??

Many thanks and if possible, please cc: a copy of your reply to my another account fan.ho_at_alumni.ust.hk

--
Yat-Fan Ho
Software Support Analyst
KCRC, Hong Kong

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 16 1999 - 12:17:30 CDT