Re: mview over private database link

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Fri, 7 Oct 2011 08:01:33 +0200
Message-ID: <4E8E95BD.7090906_at_nordea.com>

I thought the mview log is a must if I need a fast refresh and here I need simple complete one.

W dniu 06.10.2011 20:26, Joel.Patterson_at_crowley.com pisze:
> I could be off, but maybe it will point to something. The reason being is that I have never created a MV on a view. Doesn't there need to be a MV log on src?
>
> In my mind I see a table on src. And a MV log on src for that table. Then I create a MV on Middle selecting from table_at_src on say primary key (verses rowid).
>
> When querying middle, I would see a MV, a Table also, a dbms_job, (at least). So, now if I wish to create a MV on middle.'table', I would repeat the scenario.
>
> .... hope that hit the right points in a relatively succinct way, and helps.
>
> Joel Patterson
> Database Administrator
> 904 727-2546

-- 
Pole nakazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedzib� w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisan� do Rejestru Przedsi�biorc�w Krajowego Rejestru S�dowego pod numerem: 0000021828, 
dla kt�rej dokumentacj� przechowuje S�d Rejonowy Gda�sk - P�noc w Gda�sku, 
VIII Wydzia� Gospodarczy Krajowego Rejestru S�dowego, 
o kapitale zak�adowym i wp�aconym w wysoko�ci: 277.493.500,00 z�otych, 
NIP: 586-000-78-20, REGON: 190024711--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 07 2011 - 01:01:33 CDT