Creating materialized view on remote database

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 Received on Thu May 12 2005 - 17:16:44 CDT