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
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 pageThis 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.