Re: Creating materialized view on remote database

HJ wrote:

> Hi, all.
>
> I'm trying to create a materalized view but I want to stay logged into
> my local database and create a view on a remote database. So, the
> syntax would look something like this:
>
> create materialized view EMP_MAT_VIEW_at_REMOTE_DB
> tablespace SNAPSHOT
> refresh fast
> start with sysdate next sysdate + 1
> with rowid
> as
> select * from EMPLOYEE;
>
> I was hoping that would work, but it's giving me an error. Can this be
> done? Is there another way to do this?
>
> Thanks,
> HJ

And the error message is a secret. Why?
And the racle version number is a secret. Why?

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