CATNOADT.SQL  

Objects 

SYS 

Drops views and synonyms on dictionary metadata that relate to object types 

CATNOAUD.SQL  

Security 

SYS 

Drops views and synonyms on auditing metadata 

CATNOHS.SQL  

Heterogeneous Services 

SYS 

Removes Heterogeneous Services dictionary metadata 

CATNOPRT.SQL  

Partitioning 

SYS 

Drops views and synonyms on dictionary metadata that relate to partitioned tables and indexes 

CATNOQUEUE.SQL  

Advanced Queuing 

SYS 

Removes Advanced Queuing dictionary metadata 

CATNORMN.SQL  

Recovery Manager 

Owner of recovery catalog 

Removes recovery catalog schema 

CATNOSVM.SQL  

Server Manager 

SYS 

Removes Oracle7 Server Manager views and synonyms 

CATNSNMP.SQL  

Distributed management 

SYS 

Drops the DBSNMP user and SNMPAGENT role