Oracle Database Discussions

Hi All,

         We are facing  issue with ADG. when we use multiple dblinks in join condition it returns an error with ORA-16000.

My Requirement is create one view using one db link and create another view using another one db link. then create new with using these two views.

ex:

   create view v1 as select 'x' a from test1@dblink1;

   create view v2 as select 'X' b from test2@dblink2;

   create view v3 as select * from v1,v2;

for this requirement i am getting ORA-16000 error.

Regards,

Madhan