1.connect to sys/pw
2.Grant create database link to scott.
3.grant create materialized view to scott.
4.then i connected to the scott/pw
5.Next i created a database link using the follo syntax
Create database link am.world connect to scott identified by tiger using 'AM.WORLD';
6.DATABASE LINK IS CREATED.
7.When i tried to create a materialized view using the syntax
CREATE MATERIALIZED VIEW emp_mv
SELECT * FROM firstname.lastname@example.org;
8.i got the error tns could not resolve the service name.
Pls help me i am working on 8.1.7/win2000.
when i queried the global_name...
sql>select * from global_name;
As u said i checked the sqlnet.ora
NAMES.DEFAULT_DOMAIN = world
I changed it to
NAMES.DEFAULT_DOMAIN = PRAS.COM
After that i am even unable to make the database link...it give me the follo error
ERROR at line 1:
ORA-02082: a loopback database link must have a connection qualifier.
Pls tell me what will be the prob and where i am going wrong..i will be thankful.
Thanks a lot.The database link is created successfully but i am still not able to create the materialized view as mentioned.At the same time i am able to create another table using the database link.
Why am i not able to create the materialized view.