Error while trying to create a Mview based on a remote Mview
Date: Mon, 28 Feb 2011 16:23:12 -0600
Message-ID: <AANLkTi=9LDomRp6BWqD0eDCgWedJ9gnJQSikQAkVWcTY_at_mail.gmail.com>
Hi list,
I have the following scenario (I don't know if what I'm trying here is possible at all) :
Oracle 11G 11.2.0.1.0 on AIX for both databases
Remote DB
Application Owner: Two base tables, one MView (joining the two tables) using
refresh fast on commit.
Read only user: With select privilege (granted directly) on the base table
and the mview.
Local DB
db link connecting to the read only user. Queries against the remote mview work fine.
Tried to create a mview based on the remote mview (using the query that works in the previous step) but it fails with ORA-00942 table or view does not exist.
Have you guys faced this situation before? I was browsing this error and looks like it may be related to a bug..but not sure.
Thanks in advance for your help.
Regards,
GBA
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 28 2011 - 16:23:12 CST