Here are some more excepts I found.

17. Finish converting the catalog to a full ORACLE8 catalog by running cat8000.sql, usually located in the $ORACLE_HOME/rdbms/admin subdirectory on UNIX. Then run catalog.sql located in the same place. Finally, run catproc.sql to rebuild the PL/SQL and utility packages. If needed, also run any other "cat".sql scripts to install any purchased options as required.



Scripts run by CATPROC.SQL

All of these scripts are located in the $ORACLE_HOME/rdbms/admin directory or its equivalent on your platform. These scripts build virtually the entire set of Oracle utilities including PL/SQL.

Scripts run by catproc.sql are:

SCRIPT PURPOSE

catprc.sql This creates data dictionary views for types, stored procedures, and triggers. This script must be run while connected to sys or internal.

catjobq This script creates the catalog views for the job queue. This script must be run while connected as SYS or INTERNAL.

catrpc This script creates internal views for RPC (Remote Procedural Calls). These views are needed only for databases with the procedural option that are accessed by remote databases. This script must be run as SYS.

dbmsstdx.sql This package provides kernel extensions to package standard. Routines in this package do not need to be qualified by the owner or package name, similar to the behavior of package 'standard'. This package mostly contains utility routines for triggers.

pipidl.sql This creates the package Portable IDL.

pidian.sql This creates the package Diana.

diutil.sql This creates Diana application routines.

pistub.sql This script generates the subprogram stub generator.

plitblm.sql This is PL/sql Index-TaBLe Methods Package for index-table operations. This package must be loaded by catproc.sql script. This file needs to be kept in sync with its .pls version (icd/plitblm.pls) currently.

MH