Please follow the below steps
col COMP_ID for a15
col COMP_NAME for a45
col STATUS for a20
set lines 100 pages 100
select COMP_ID,COMP_NAME,STATUS from dba_registry;
COMP_ID COMP_NAME STATUS
————— ——————————————— ——————–
CATALOG Oracle Database Catalog Views VALID
CATPROC Oracle Database Packages and Types VALID
JAVAVM JServer JAVA Virtual Machine VALID
XML Oracle XDK VALID
CATJAVA Oracle Database Java Packages VALID
APS OLAP Analytic Workspace OPTION OFF
RAC Oracle Real Application Clusters OPTION OFF
XDB Oracle XML Database VALID
OWM Oracle Workspace Manager VALID
CONTEXT Oracle Text VALID
ORDIM Oracle Multimedia VALID
SDO Spatial VALID
XOQ Oracle OLAP API OPTION OFF
OLS Oracle Label Security VALID
APEX Oracle Application Express VALID
DV Oracle Database Vault VALID
Query to check whether APEX is being used by the database:
select workspace, view_date, seconds_ago from apex_workspace_activity_log;
Remove Oracle Application Express:-
@?/apex/apxremov.sql
Drop the APEX user if still exists:-
SQL> select username from dba_users where username like ‘%APEX%’;
USERNAME
—————————————————————————————————-
APEX_PUBLIC_USER
APEX_030200
APEX_040200
drop user APEX_040200 cascade;
drop user APEX_030200 cascade;
drop user APEX_PUBLIC_USER cascade;
drop package sys.wwv_dbms_sql;
Check the invalids and compile using utlrp.sql:-
select count(*) from dba_objects where status=’INVALID’;
@?/rdbms/admin/utlrp.sql
