Creating Additional Data Dictionary Structures
Oracle AI Database supplies other scripts that create additional structures you can use in managing your database and creating database applications.
These scripts are listed in Table B-2.
See Also: Your operating system-specific Oracle documentation for the exact names and locations of these scripts on your operating system
Table B-2 Creating Additional Data Dictionary Structures
| Script Name | Needed For | Run By | Description |
|---|---|---|---|
catblock.sql |
Performance management | SYS |
Creates views that can dynamically display lock dependency graphs See Also: Oracle AI Database Administrator's Guide |
caths.sql |
Heterogeneous Services | SYS |
Installs packages for administering heterogeneous services See Also: Oracle AI Database Gateway for APPC Installation and Configuration Guide for Microsoft Windows |
catio.sql |
Performance management | SYS |
Allows I/O to be traced on a table-by-table basis |
catqueue.sql |
Advanced Queuing | Creates the dictionary objects required for Advanced Queuing | |
catrep.sql |
Oracle Replication | SYS |
Runs all SQL scripts for enabling database replication |
catwrr.sql |
Database Replay | SYS |
Main script that creates the entire schema related to Database Replay - calls the create schema scripts for Workload Capture, Database Replay, Workload Replay, and Workload Intelligence |
catwrrwitb.sql |
Database Replay | SYS |
Creates the schema for Workload Intelligence |
dbmsiotc.sql |
Storage management | Any user | Analyzes chained rows in index-organized tables |
dbmspool.sql |
Performance management | SYS or SYSDBA |
Enables DBA to lock PL/SQL packages, SQL statements, and triggers into the shared pool See Also: Oracle AI Database PL/SQL Packages and Types Reference |
userlock.sql |
Concurrency control | SYS or SYSDBA |
Provides a facility for user-named locks that can be used in a local or clustered environment to aid in sequencing application actions |
utlbstat.sql and utlestat.sql |
Performance monitoring | SYS |
Respectively start and stop collecting performance tuning statistics |
utlchn1.sql |
Storage management | Any user | For use with Oracle AI Database. Creates tables for storing the output of the See Also: Oracle AI Database Administrator's Guide |
utlconst.sql |
Year 2000 compliance | Any user | Provides functions to validate that CHECK constraints on date columns are year 2000 compliant |
utldtree.sql |
Metadata management | Any user | Creates tables and views that show dependencies between objects See Also: Oracle AI Database SecureFiles and Large Objects Developer's Guide |
utlexpt1.sql |
Constraints | Any user | For use with Oracle AI Database. Creates the default table ( See Also: Oracle AI Database Administrator's Guide |
utlfixdirs.sql |
Moving a database to a new Oracle home | SYS |
Used after moving a database to a new Oracle home. Updates directory objects to use the new path names for the Oracle home and Oracle base directories, as defined by the new values for the When you run this script in the root container of a CDB, it updates directory objects in the root, as well as any Oracle-maintained directory objects in the PDBs; you must manually update any PDB directory objects that are not Oracle-maintained. |
utlip.sql |
PL/SQL | SYS |
Used primarily for upgrade and downgrade operations. It invalidates all existing PL/SQL modules by altering certain dictionary tables so that subsequent recompilations will occur in the format required by the database. It also reloads the packages STANDARD and DBMS_STANDARD, which are necessary for any PL/SQL compilations. |
utlirp.sql |
PL/SQL | SYS |
Used to change from 32-bit to 64-bit word size or vice versa. This script recompiles existing PL/SQL modules in the format required by the new database. It first alters some data dictionary tables. Then it reloads the packages STANDARD and DBMS_STANDARD, which are necessary for using PL/SQL. Finally, it triggers a recompilation of all PL/SQL modules, such as packages, procedures, and types. |
utllockt.sql |
Performance monitoring | SYS or SYSDBA |
Displays a lock wait-for graph, in tree structure format See Also: Oracle AI Database Administrator's Guide |
utlpwdmg.sql |
Security | SYS or SYSDBA |
Creates PL/SQL functions for default password complexity verification. Sets the default password profile parameters and enables password management features. See Also: Oracle AI Database Security Guide |
utlrp.sql |
PL/SQL | SYS |
Recompiles all existing PL/SQL modules that were previously in an INVALID state, such as packages, procedures, and types. |
utlsampl.sql |
Examples | SYS or any user with DBA role |
Creates sample tables, such as emp and dept, and users, such as scott |
utlscln.sql |
Oracle Replication | Any user | Copies a snapshot schema from another snapshot site |
utltkprf.sql |
Performance management | SYS |
Creates the TKPROFER role to allow the TKPROF profiling utility to be run by non-DBA users |
utlvalid.sql |
Partitioned tables | Any user | Creates tables required for storing output of ANALYZE TABLE ... VALIDATE STRUCTURE of a partitioned table |
utlxplan.sql |
Performance management | Any user | Creates the table |