SAP Knowledge Base Article - Preview

3046614 - Duplicate Invalid Types

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


Read more...

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 ONE Support launchpad (Login required).

Search for additional results

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