Lesson 8 | Running the CATPROC script |
Objective | Run CATPROC.SQL script against the COIN database. |
Running CATPROC Script
The purpose of CATPROC.SQL script
Another critical script that you need to run is CATPROC.SQL. You will find it in the same directory in which you found CATALOG. CATPROC.SQL's purpose is centered around PL/SQL.
It creates a number of PL/SQL-related data dictionary views, and an innumerable (well almost) number of built-in PL/SQL packages. Some of the highlights of what CATPROC.SQL creates are:
- The DBMS_STANDARD PL/SQL package
- PL/SQL related views such as DBA_SOURCE, USER_TRIGGERS, and ALL_TRIGGER_COLS
- A myriad of other built-in PL/SQL packages such as DBMS_SESSION, DBMS_UTILITY, and DBMS_SYSTEM
- Public synonyms for the above views and packages
How to run the script
If you look in the CATPROC.SQL file, you will see that it mostly just calls a bunch of other script files. Some of those, DBMSUTIL.SQL for example, call other files in turn. You run CATPROC.SQL by using Server Manager. Here's an example:
C:\Oracle\Ora81\RDBMS\ADMIN>svrmgrl
SVRMGR>connect internal
SVRMGR>@catproc
CATPROC takes even longer to run than CATALOG. On the production systems that I manage, where I have plenty of memory and fast SCSI disks, I allow at least 1 hour. On some slower systems, this can take well over two hours. You have to run it, though. Before you proceed, make sure that you run CATPROC.SQL against your COIN database.