Creating materialized view thru db link?
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
Click Here to Expand Forum to Full Width