Re: Snapshot Logs without Snapshots?

Giganews Newsgroups
Subject: Re: Snapshot Logs without Snapshots?
Posted by:  Daniel Morgan (damorg…@x.washington.edu)
Date: Mon, 26 Jan 2004

K Brown wrote:

> Greetings all.  I'm wondering if anyone has tried to use Snapshot Logs
> without actually setting up a Snapshot.  Here's my situation, and bear
> in mind that I'm a datawarehouse designer with substantial ETL
> experience against Oracle, but not an actual Oracle DBA.
>
> We're creating a datamart with Oracle as the source.  There are
> multiple locations around the world so there's no true down time for a
> mart load, and we need relatively current (but not real time) data.
> So we're trying to implement a changed data capture using snapshot
> logging but we have no real need or desire for true replicated
> snapshots.  But from what I can tell, the snapshot log date
> (SNAPTIME$$) is always the 1/1/4000 unless it's been updated by the
> actual snapshot, which we don't have.  We were hoping to use that
> SNAPTIME$$ as a timestamp but it doesn't look that way.  So we're
> casting about, trying to figure some way to make the snapshot log
> capture the true SYSDATE of when the log record gets written, rather
> than the default 1/1/4000.
>
> Any thoughts out there?  All information, guesses, or just plain
> noodling gratefully pondered.
>
> Thanks,
> K Brown

Why not use DBMS_JOB and let SYSDATE or SYSTIMESTAMP provide the date
and time?

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorg…@x.washington.edu
(replace 'x' with a 'u' to reply)

Replies

None

In response to

Snapshot Logs without Snapshots? posted by katrzy…@hotmail.com on 26 Jan 2004