12cR2 CDB Database Components Clean Up | Oracle 12.2.0.1 - CDB Database Registry Components Removal!

#OracleF1 #Oracle12c #RegistryComponents

In this video discussed all about Oracle 12cR2 - CDB Database Registry Components Removal.

alter system set "_exclude_seed_cdb_view"=false scope=both;

set line 200
set pages 1000
col COMP_ID format a8
col COMP_NAME format a34
col SCHEMA format a12
col STATUS format a10
col VERSION format a12
col CON_ID format 99

select CON_ID, COMP_ID, comp_name, schema, status, version from CDB_REGISTRY order by 1,2;

set line 200
set pages 1000
col owner format a12
col object_type format a12
col object_name format a30
col STATUS format a8
col CON_ID format 9

select con_id, owner, object_type, object_name, status from CDB_OBJECTS where status='INVALID' order by 1,2,3;

Following Components Removed.

Oracle Workspace Manager (OWM) Clean Up in Oracle Database 12.2
Oracle Label Security (OLS) Clean Up in Oracle Database 12.2
Oracle Spatial (SDO) Clean Up in Oracle Database 12.2
Oracle Text (CONTEXT) Clean Up in Oracle Database 12.2
Oracle Multimedia (ORDIM) Clean Up in Oracle Database 12.2
Oracle OLAP (XOQ, APS, AMD) Clean Up in Oracle Database 12.2

hope this helps!

Cheers!
Ramesh.

Follow Me On: