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
>

If you'd just care to lookup the semantics, you'll see a dblink can only be specified in the query part. So your mv would need to be created on the other side, and query EMPLOYEE_at_LOCAL_DB.

Apart from all that - you're not creating these on the fly - are you?

-- 
Regards,
Frank van Bortel