when
select * from table_name@db_link;
getting below error:-
ORA-00942: table or view does not exist
[Oracle][ODBC SQL Server Driver][SQL Server]Invalid object name 'table_name'. {42S02,NativeErr = 208}[Oracle][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. {42000,NativeErr = 8180}
ORA-02063: preceding 2 lines from AXISMF_RPL
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Error at Line: 7 Column: 40.
we can access the another table through db link but one specifc table we can't access.
table present in the sql sever. Table have all db permissions.
please help me if anyone knows the solution for the above error.