The "NO" Scripts

The "NO" Scripts

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

See Also:

Oracle Database Upgrade Guide for more information about these scripts

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
`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
`catnoque.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