Re: error in refreshing materlized view
From: gazzag <gareth_at_jamms.org>
Date: Fri, 14 Mar 2008 05:43:50 -0700 (PDT)
Message-ID: <f9bad50d-906a-4a4e-8bf5-4d89e2ea237f@s13g2000prd.googlegroups.com>
Date: Fri, 14 Mar 2008 05:43:50 -0700 (PDT)
Message-ID: <f9bad50d-906a-4a4e-8bf5-4d89e2ea237f@s13g2000prd.googlegroups.com>
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