SAP Knowledge Base Article - Preview

3354789 - Invalid SAP_* SYNONYM

Symptom

You may find invalid object during SBP-catsbp step:

select owner, object_name, object_id, object_type, created, last_ddl_time, timestamp, status from dba_objects where status != 'VALID' order by object_name;
OWNER      OBJECT_NAME                         OBJECT OBJECT_TYPE  CREATED   LAST_DDL  TIMESTAMP           STATUS 
PUBLIC     SAP_DBDIFF                          144079 SYNONYM      06-NOV-20 06-NOV-20 2020-11-06:02:44:12 INVALID
PUBLIC     SAP_DD02L                           144074 SYNONYM      06-NOV-20 06-NOV-20 2020-11-06:02:44:12 INVALID
PUBLIC     SAP_DD09L                           144075 SYNONYM      06-NOV-20 06-NOV-20 2020-11-06:02:44:12 INVALID
PUBLIC     SAP_DD12L                           144076 SYNONYM      06-NOV-20 06-NOV-20 2020-11-06:02:44:12 INVALID
PUBLIC     SAP_DDNTT                           144077 SYNONYM      06-NOV-20 06-NOV-20 2020-11-06:02:44:12 INVALID
PUBLIC     SAP_IAORA                           144073 SYNONYM      06-NOV-20 06-NOV-20 2020-11-06:02:44:12 INVALID
PUBLIC     SAP_IGORA                           144070 SYNONYM      06-NOV-20 06-NOV-20 2020-11-06:02:44:12 INVALID
PUBLIC     SAP_TAORA                           144072 SYNONYM      06-NOV-20 06-NOV-20 2020-11-06:02:44:12 INVALID
PUBLIC     SAP_TGORA                           144069 SYNONYM      06-NOV-20 06-NOV-20 2020-11-06:02:44:12 INVALID
PUBLIC     SAP_TSORA                           144071 SYNONYM      06-NOV-20 06-NOV-20 2020-11-06:02:44:12 INVALID


Read more...

Product

SAP NetWeaver all versions

Keywords

SAP_DBDIFF,
SAP_DD02L,
SAP_DD09L,
SAP_DD12L,
SAP_DDNTT,
SAP_IAORA,
SAP_IGORA,
SAP_TAORA,
SAP_TGORA,
SAP_TSORA , KBA , BC-DB-ORA , Oracle , 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.