Forum Stats

  • 3,782,743 Users
  • 2,254,682 Discussions
  • 7,880,151 Comments

Discussions

UNABLE TO ACCESS TABLE THROUGH DB_LINK.

User_0KP8D
User_0KP8D Member Posts: 1 Green Ribbon
edited Dec 31, 2019 8:30AM in Enterprise Manager

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.

Rafael Soler - One GoLive

Answers

  • sys_dba
    sys_dba Member Posts: 51
    edited Dec 31, 2019 2:22AM

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

    Rafael Soler - One GoLive
  • EdStevens
    EdStevens Member Posts: 28,611 Gold Crown
    edited Dec 31, 2019 8:30AM
    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;