Snapshot log problem

Recently we migrated an Oracle database from version “8.1.6.0.0” to “10.2.0.4.0”.
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.

I’ll appreciate your hellp.

Thanks Received on Thu Jan 15 2009 - 07:58:09 CST