2 Replies Latest reply on Dec 31, 2019 1:30 PM by EdStevens

    UNABLE TO ACCESS TABLE THROUGH DB_LINK.

    3886476

      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.

        • 1. Re: UNABLE TO ACCESS TABLE THROUGH DB_LINK.
          sys_dba

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

          • 2. Re: UNABLE TO ACCESS TABLE THROUGH DB_LINK.
            EdStevens

            3886476 wrote:

             

            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.

            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;