The "NO" Scripts

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

See Also: Oracle9i Database Migration for more information about these scripts

Table 5-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