Use dblink IP access to the same period of another former, you can access the table, but the view error ora - 02072 distributed database network protocol match error, TNS configuration can get onto the former, please comment, thank you

CodePudding user response:

What version of the database on both sides, and not through the dblink, directly connected to the former database query whether this view is an error, whether the query all view an error

CodePudding user response:

A direct link is 11 g, no problem, take the other view is also no problem, now take this view is platform through dblingk taking the view of other users

CodePudding user response:

reference 1st floor js14982 response:

on both sides is what version of the database, the other is not through the dblink, directly connected to the former database query whether this view is an error, whether the query all view error

A direct link is 11 g, no problem, take the other view is also no problem, now take this view is platform through dblingk taking the view of other users

CodePudding user response:

Through the dblink query other views are no problem? There is something wrong with just this one view? Is connected directly to the same query statements, it is not simple is the select * from...

CodePudding user response:

reference 4 floor js14982 response:

by dblink query other views are no problem? There is something wrong with just this one view? Is connected directly to the same query statements, it is not simple is the select * from...

For just such a view has a problem, the other no problem

CodePudding user response:

This view has a problem, may be related in the table or index has a bad block