The "NO" Scripts

The scripts in Table B-3 are used to remove dictionary information for various optional services or components.

Table B-3 The NO Scripts

Script Name	Needed For	Run By	Description
`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
`catnoclust.sql`	Real Application Clusters	`SYS`	Drops views that are specific to Oracle Real Application Clusters (Oracle RAC)
`catnodrdaas.sql`	DRDA Application Server	`SYS`	Drops all DRDA Application Server objects from the database
`catnogwm.sql`	Global Data Services	`SYS`	Drops users, roles, and other objects created for Global Data Services.
`catnohs.sql`	Heterogeneous Services	`SYS`	Removes Heterogeneous Services dictionary metadata
`catnojav.sql`	Java	`SYS`	Drops the RDBMS Java classes and system triggers created by the `catjava.sql` script.
`catnoprt.sql`	Partitioning	`SYS`	Drops views and synonyms on dictionary metadata that relate to partitioned tables and indexes
`catnosvm.sql`	Server Manager	`SYS`	Removes Oracle7 Server Manager views and synonyms
`catnowrr.sql`	Database Replay	`SYS`	Master script that drops the entire schema related to Database Replay - calls the drop schema scripts for Workload Capture, Database Replay, Workload Replay, and Workload Intelligence
`catnowrrc.sql`	Database Replay	`SYS`	Drops the schema related to Workload Capture
`catnowrrp.sql`	Database Replay	`SYS`	Drops the schema related to Workload Replay
`catnowrrwitb.sql`	Database Replay	`SYS`	Drops the schema related to Workload Intelligence
`catnsnmp.sql`	Distributed management	`SYS`	Drops the DBSNMP user and SNMPAGENT role