My Oracle Support Banner

DBA_REGISTRY Shows Oracle OLAP Components in Status REMOVED (Doc ID 1064322.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle OLAP - Version and later
Information in this document applies to any platform.


After removing Oracle OLAP from the database, the DBA_REGISTRY shows
- the Oracle OLAP components APS and XOQ are in status REMOVED
- no entry for the Oracle OLAP AMD component

select comp_id, comp_name, version, status,schema from dba_registry;

COMP_ID  COMP_NAME                    VERSION     STATUS     SCHEMA
-------- ---------------------------- ----------- ---------- -------
APS      OLAP Analytic Workspace   REMOVED    SYS
CATALOG  Oracle9i Catalog Views   VALID      SYS
CATPROC  Oracle9i Packages and Types   VALID      SYS
OWM      Oracle Workspace Manager   VALID      WMSYS
XOQ      Oracle OLAP API       REMOVED    SYS


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.