Re: error in refreshing materlized view
Date: Fri, 14 Mar 2008 05:43:50 -0700 (PDT)
On 14 Mar, 12:38, sameer <sameer.dhy..._at_gmail.com> 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.
What Oracle version?
Why are you refreshing the MV in a package? What is the syntax that you use to create the MV?
HTH -g Received on Fri Mar 14 2008 - 07:43:50 CDT