Nice thing in oracle 11.2
From: Mladen Gogala <no_at_email.here.invalid>
Date: Thu, 11 Aug 2011 23:08:12 +0000 (UTC)
Message-ID: <pan.2011.08.11.23.08.12_at_email.here.invalid>
Materialized view logs can now be purged automatically. It is possible to specify something like 'PURGE REPEAT INTERVAL '5' DAY. Wow! That really makes my life a lot easier! Also, materialized views which contain count do not necessarily have to contain sum, as in 10g. I am impressed.
Date: Thu, 11 Aug 2011 23:08:12 +0000 (UTC)
Message-ID: <pan.2011.08.11.23.08.12_at_email.here.invalid>
Materialized view logs can now be purged automatically. It is possible to specify something like 'PURGE REPEAT INTERVAL '5' DAY. Wow! That really makes my life a lot easier! Also, materialized views which contain count do not necessarily have to contain sum, as in 10g. I am impressed.
-- http://mgogala.byethost5.comReceived on Thu Aug 11 2011 - 18:08:12 CDT