3046614 - Duplicate Invalid Types | SAP Knowledge Base Article

Symptom

dba_objects.object_name shows two same type, one is invalid, the other is valid.

For example, below sql:

select owner, object_name, object_type, status from dba_objects where object_name in
(select distinct object_name from dba_objects where object_type='TYPE' and status='INVALID')
order by owner, object_name

Environment

Oracle >=10.2.0.1

Product

SAP NetWeaver all versions

Keywords

type, AWR_OBJECT_INFO_TABLE_TYPE, AWR_OBJECT_INFO_TYPE, AQ$_AGENT, ALERT_TYPE, SQL_PLAN_ALLSTAT_ROW_TYPE, SQL_PLAN_STAT_ROW_TYPE, SQL_PLAN_TABLE_TYPE , 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.

3046614 - Duplicate Invalid Types