Help me: Snapshot problem

From: Changjin Lee <cjlee_at_www.kse.or.kr>
Date: Tue, 26 Oct 1999 10:29:23 +0900
Message-ID: <381503F3.3BB272BE@www.kse.or.kr>

Dear Oracle Experts,

I am finding an Oracle expert who can give me some clues on snapshots.

I made a snapshot as follows,

---

CREATE SNAPSHOT test
REFRESH complete
with rowid
START WITH sysdate
NEXT sysdate + (1/288) AS
select * from SS_GRP_ISU_COPY_at_foss_es2;

---

and execute sql commands like these,

---

exec dbms_refresh.refresh('"FOGAMRI"."TEST"');
exec dbms_snapshot.refresh('TEST','?');
exec dbms_job.run(241);


--------------------------------------------------

and then execute these commands as follows in order to check whether the snapshot works well or not.

---

alter session set nls_date_format = 'yyyy-mm-dd:hh:mi:ss'; select job,this_date,next_date,failures,broken,what from dba_jobs;

---

However, the result is not correct as follows. The NEXT_DATE column is showing
quite strange value, 1800-00-01:01:08:13, which makes me crazy.

---

JOB THIS_DATE NEXT_DATE FAILURES BROKEN

--- ------------------- ------------------- ---------- ------

WHAT

---

241 1999-10-26:09:51:51 1800-00-01:01:08:13 0 N dbms_refresh.refresh('"FOGAMRI"."TEST"');

---

I can't understand why it doesn't work correctly. I think there was no problem
in the snapshot createon clause.
My system is a HP N4000 Class and is running on the HP-UX 11.0 and Oracle 8.0.5.1.0
64-bit production.

Please give some solutions that can save me from this terrible situation.
My e-mail address is

cjlee_at_www.kse.or.kr

Thank you. Received on Mon Oct 25 1999 - 20:29:23 CDT