Oracle: DBA_EXPORT_OBJECTS

HET_TYPE stores the name of the heterogeneous object type.

In 19c, there are for such heterogeneous object types:

select
-- count(*),
   het_type
from
   dba_export_objects
group by
   het_type;
--
-- DATABASE_EXPORT
-- SCHEMA_EXPORT
-- TABLE_EXPORT
-- TRANSPORTABLE_EXPORT

The value of NAMED is either Y or N and specifies if the objects of the given type have names, i.e. if the last element of the path is a type with a name filter (which is the case if the regular expression [A-Z_]+$ matches).

table_export_objects, schema_export_objects, database_export_objects, tablespace_export_objects, transportable_export_objects

data dictionary