dba_registry
shows all database components that are loaded into the component registry. CID | ||
APEX | Oracle Application Express | |
APS | OLAP Analytic Workspace | |
CATALOG | Oracle Catalog Views | $ORACLE_HOME/rdbms/admin/catalog.sql |
CATJAVA | Oracle Java Packages | $ORACLE_HOME/rdbms/admin/catjava_sql |
CATPROC | Oracle Packages and Types | $ORACLE_HOME/rdbms/addmin/catproc.sql |
CONTEXT | Oracle Text | |
DV | Oracle Database Vault | $ORACLE_HOME/rdbms/admin/catmacpre.sql |
EM | Oracle Enterprise Manager Repository | |
JAVAVM | JServer JAVA Virtual Machine | |
OLS | Oracle Label Security | $ORACLE_HOME/rdbms/admin/catols.sql , catolsd.sql |
ORDIM | Oracle Multimedia | |
OWM | Oracle Workspace Manager | |
RAC | Real Application Clusters | $ORACLE_HOME/rdbms/admin/catclust.sql |
SDO | Oracle Spatial | |
XDB | Oracle XML Database | ORACLE_HOME/rdbms/admin/catqm_int.sql |
XML | Oracle XDK for Java | |
XOQ | Oracle OLAP API | $ORACLE_HOME/rdbms/admin/initxml.sql |
ODM | Data Mining | |
MGW | Messaging Gateway | |
WK | Oracle Ultra Search |
select comp_id, comp_name, schema, procedure, version, status, modified, namespace, other_schemas from dba_registry order by lower(comp_name);