Re: Creating materialized view on remote database

HJ wrote:

> Well, I'm only creating it on the fly because I want to test out a
> concept to see if it's even feasible. So, no worries. I'm not
> wreaking havoc on the database. :)
>
> I don't have any issues with the general concepts of materialized views
> but given our current connectivity configuation, we can't simply
> disallow 'create materialized view' privileges. I need to figure a way
> to push the materialized view to the remote database because of our
> connectivity configuration.
>
> Anyway, I'm contacting Oracle to get the definitive word to see if it's
> even feasible to do this.
>
> Thanks for your feedback,
> -- HJ

Your statement makes no sense. There is not a single justification I can think of for doing what you say is essential.

So either you could explain to us why your situation is so completely unique or perhaps acknowledge that we might be able to supply a far better methodology: I suspect the later to be the case.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)