Re: error in refreshing materlized view

From: Frank van Bortel <>
Date: Fri, 14 Mar 2008 19:55:51 +0100
Message-ID: <12343$47daca38$524b5c40$>

sameer wrote:
> hello friends
> i have a problem
> we have two different database d1 and d2
> in d2 we have atable t1 on tht we made materlized view m1
> when i refresh m1 in simple block it refresh bt when i refresh tht in
> package it giving me error nt enough priveleges.

I'm rather picky on friends - for one, I know them personally.

Next time you try things out, use a 'set role none' command before running anything, that should end up in PL/SQL.

If you do not understand why, try documentation.


Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Fri Mar 14 2008 - 13:55:51 CDT

Original text of this message