SAP Knowledge Base Article - Preview

2499836 - ORA-00942: table or view does not exist - SLT

Symptom

  • When setting up replication from Non-SAP source (Oracle) system, using System Landscape Transformation (SLT). in transaction LTRC | MT_ID (mass transfer ID) | Table Overview the load for a table is not starting because the trigger status is missing.  Though when checking the database the trigger is there.  The following error message is shown in the worker process logs:
  • OCIStmtExecute() failed with -1=OCI_ERROR, SQL error 942:
    ORA-00942: table or view does not exist
    Error 942 reading V$DATABASE


Read more...

Environment

SAP Landscape Transformation replication server

Product

SAP Landscape Transformation replication server all versions

Keywords

SLT, Oracle, Error 942 reading V$PDBS , KBA , CA-LT-SLT , SAP Landscape Transformation Replication Server (SLT) , Problem

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.