UNABLE TO ACCESS TABLE THROUGH DB_LINK.

User_0KP8D

when

select * from [email protected]_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.

sys_dba

Have you checked permissions on the source tables?   This might be visibility related issue.

EdStevens

3886476 wrote:whenselect * from [email protected]_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_RPL00942. 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.

MSSQL treats case-sensitivity of object names differently that does Oracle.  We find that when querying MSSQL via an Oracle DB link, we need to enclose the object names in double-quotes, and make sure it is in the same case as defined in MSSQL.

select *

from "table_name"@db_link;