Re: Snapshot Logs without Snapshots?

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
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)