Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

UNABLE TO ACCESS TABLE THROUGH DB_LINK.

Srikanta MohapatraDec 26 2019 — edited Dec 31 2019

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.

Comments

Post Details

Added on Dec 26 2019
2 comments
1,752 views