Re: error in refreshing materlized view

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.

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up