Snapshot log problem
Date: Thu, 15 Jan 2009 05:58:09 -0800 (PST)
Recently we migrated an Oracle database from version 184.108.40.206.0 to
This database is replicated. This replication is performed by a job that runs this:
dbms_refresh.refresh('"USR_OWNER"."GROUP1"'); after this I have a function:
oldest_date DATE := (sysdate - 0.08333); oldest_log_date DATE;
- oldest_log_date is returned by the dbms_snapshot.get_log_age function. begin dbms_snapshot.get_log_age(oldest_log_date, snapowner, snaptable); if (oldest_date <= oldest_log_date) then RETURN NULL; else RETURN oldest_log_date; end if; end; The curious thing is that in the old database it returns NULL even if oldest_date is greater than oldest_log_date. In the new 10g it returns the oldest_log_date.
Ill appreciate your hellp.
Thanks Received on Thu Jan 15 2009 - 07:58:09 CST