Re: error in refreshing materlized view
Date: Fri, 14 Mar 2008 19:55:51 +0100
> 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.
-- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me upReceived on Fri Mar 14 2008 - 13:55:51 CDT