If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Oracle automatic deletes the rows form mlog$_tablename.
when snapshot is refreshed

Your problem may due to

i) Snapshot is not configured for automatic refreshes
and it has been not refreshed manually since log time.
ii) Multiple snapshots use the same log and one of them
is not refreshed. Oracle does not delete rows from the log
until all snapshots have used them.
iii) Due to Network failure, master site is unaware that
snapshot has been dropped.

so pls. check if any such problem.

Log can be manually purged using inbuilt procedure DBMS_SNAPSHOT.PURGE_LOG