Hi Julian,

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.

Thanks
pras