-
Creating materialized view thru db link?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|