Hi

Anyone knows how to create a view/materialized view of table in remote server thru database link.

I have created the following:

1. database link orcltst
SQL>create database link orcltst connect to tester identifed by tester using 'orcltst';

2. Try to create a view remotely from another server:
SQL>CREATE MATERIALIZED VIEW abcview
AS SELECT * FROM abc@orcltst;


But it failed to create the view.

Can anybody share the expertise on this

Thanks you so much for your help

Robby