SQL & PL/SQL

Hi all,

In the below query i used the remote database table in the join. if run the table individualy i am able to see the results.

While joing the remote database table to my query , i facing the below error.

I have tried to create the view for the table as below

Error:

ORA-02070: database  does not support  in this context

02070. 00000 -  "database %s%s does not support %s in this context"

*Cause:    The remote database does not support the named capability in

           the context in which it is used.

*Action:   Simplify the SQL statement.

Error at Line: 1 Column: 516

Tried to create the views doesn't helps:

------------

CREATE OR REPLACE FORCE VIEW winq20 as

select * from all_tab_cols@q20.world;

--------------

I facing the error for the situation.

     1.joining the remote database table to the query.

     2.try creating the view for the table. getting the same error.

----------------------------------------------------------------------------------------------

select * from all_tab_cols@q20.world a, all_tab_cols b where a.table_name=b.table_name;

------------------------------------------------------------------------------------------------

Need your assistance to resolve this issue.

Thanks,

Senthur