SAP Knowledge Base Article - Preview

3599928 - Error "ORA-00942: table or view does not exist" from HANA SDA connection

Symptom

When running SqlStatement via SDA remote connection to an Oracle database, below error occurred: 

[Oracle][ODBC][Ora]ORA-00942: table or view does not exist

In the meantime, from Hana indexserver trace, below error occurred:

[Oracle][ODBC][Ora]ORA-01031: insufficient privileges

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP HANA Platform edition 1.0 
  • SAP HANA Platform edition 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

SDA, Oracle, ORA-00942, ORA-01031, insufficient privileges, table or view does not exist , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.