RE: ** mv log
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <ajoshi977@xxxxxxxxx>
- Date: Tue, 23 Nov 2004 23:24:23 +0100
Hi
> I did find the table mlog$_<table_name>. I assume this
> gets created when the mv log is created.
Yes.=20
> When I delete the mv log then I assume all objects that
> depend on the mv log have to be complete refreshed.
Yes, you should perform a complete refresh for all dependent =
materialized views.
> There could be objects in other databases that depend on it=20
> and I do not know how to find those. What would happen if I
> delete the mv log and recreate it and after that one of the
> dependent objects tries to do a refresh. Will it get an error
> or will it just changes after the re-creation.
It depends on the refresh type:
a) COMPLETE --> don't care (such MV are not really dependent from the MV =
log)
b) FAST --> you get an error
c) FORCE --> no valid MV log is found, therefore complete refresh is =
automatically performed
HTH
Chris
--
//www.freelists.org/webpage/oracle-l
Other related posts:
