Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized View Log - do they shrink?
M Rothwell wrote:
>
> Given the following:
>
> Table XYZ on server A
> MViewLog MLOG$_XYZ on server A
> MView XYZ on server B
>
> If MView XYZ on server B is created as:
>
> Create Materialized view XYZ
> build immediate
> refresh fast with primary key
> as select * from xyz_at_serverA;
>
> when I refresh MView XYZ, does it do anything to the MVeiw log on server
> A? Does that log continue to grow and grow as table XYZ is updated even
> tho I have refreshed my MView on server B?
> If so, and I am concerned about space, then how would I go about keeping
> the MView log file small and not risk any data inconsitancies? I will
> have the MView in a refresh group updating 1 or maybe 2 times per day.
>
> Both server A and B are running O9i R2 on HP-UX boxes.
>
> Thanks
As rows are refreshed, the related entries should be removed from the materialised view log.
hth
connor
-- Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald_at_yahoo.com Coming Soon! "Oracle Insight - Tales of the OakTable" "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" ------------------------------------------------------------Received on Wed Sep 08 2004 - 20:41:08 CDT