mview over private database link
From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Tue, 27 Sep 2011 10:16:56 +0200
Message-ID: <4E818678.30206_at_nordea.com>
hi,
let's assume we have a schema MIDDLE within the DEST database on which we defined a private remote link to remote database SRC. I am able to create in the MIDDLE schema materialized views and views based on tables from the SRC db.
I have also another schema TARGET, where I am able to create materialized view on materialized views from MIDDLE schema. I am not able however to create mviews based on views from the MIDDLE schema, even though I am able to select those views as the TARGET user.
Date: Tue, 27 Sep 2011 10:16:56 +0200
Message-ID: <4E818678.30206_at_nordea.com>
hi,
let's assume we have a schema MIDDLE within the DEST database on which we defined a private remote link to remote database SRC. I am able to create in the MIDDLE schema materialized views and views based on tables from the SRC db.
I have also another schema TARGET, where I am able to create materialized view on materialized views from MIDDLE schema. I am not able however to create mviews based on views from the MIDDLE schema, even though I am able to select those views as the TARGET user.
So it seems the TARGET user can select on rights of the MIDDLE user, but can not select for building a mview.
Do You know how looks the big picture behind this?
Regards
Remigiusz
-- 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-lReceived on Tue Sep 27 2011 - 03:16:56 CDT