Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating materialized view on remote database
HJ wrote:
> I did look up the semantics and I only saw examples of the dblink being
> references in the query. But I was looking at an Oracle manual, and I
> was hoping someone had figured a way to push the materalized view from
> the local database to the remote database. We want to maintain full
> control of the mv scripts, so that the users on the other end will only
> get the views.
>
> Yes, I am creating them on the fly -- for now. Why? Is that
> problematic?
>
> -- HJ
A huge problem. You should NEVER build schema objects on-the-fly.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Fri May 13 2005 - 09:56:07 CDT