Snapshot log problem

From: CenturionX <>
Date: Thu, 15 Jan 2009 05:58:09 -0800 (PST)
Message-ID: <>


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

I’ll appreciate your hellp.

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

Original text of this message