Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

SQL Scripts, 3 of 6


Creating Additional Data Dictionary Structures

Oracle supplies other scripts that create additional structures you can use in managing your database and creating database applications. These scripts are listed in Table 5-2.

See Also:

Your operating system specific Oracle documentation for the exact names and locations of these scripts on your system. 

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

CATEXP7.SQL  

Exporting data to Oracle7 

SYS 

Creates the dictionary views needed for the Oracle7 Export utility to export data from Oracle8i in Oracle7 Export file format 

CATHS.SQL  

Heterogeneous Services 

SYS 

Installs packages for administering heterogeneous services 

CATIO.SQL  

Performance management 

SYS 

Allows I/O to be traced on a table-by-table basis 

CATOCTK.SQL  

Security 

SYS 

Creates the Oracle Cryptographic Toolkit package 

CATPARR.SQL  

Oracle Parallel Server 

SYS or SYSDBA 

Creates parallel server data dictionary views 

CATQUEUE.SQL  

Advanced Queuing 

 

Creates the dictionary objects required for Advanced Queuing. 

CATREP.SQL  

Advanced Replication 

SYS 

Runs all SQL scripts for enabling database replication 

CATRMAN.SQL  

Recovery Manager 

RMAN or any user with GRANT_RECOVERY_CATALOG_OWNER role 

Creates recovery manager tables and views (schema) to establish an external recovery catalog for the backup, restore, and recovery functionality provided by the Recovery Manager (RMAN) utility 

DBMSIOTC.SQL  

Storage management 

Any user 

Analyzes chained rows in index-organized tables 

DBMSOTRC.SQL  

Performance management 

SYS or SYSDBA 

Enables and disables generation of Oracle Trace output 

DBMSPOOL.SQL  

Performance management 

SYS or SYSDBA 

Enables DBA to lock PL/SQL packages, SQL statements, and triggers into the shared pool 

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 Oracle8i. Creates tables for storing the output of the ANALYZE command with the CHAINED ROWS option. Can handle both physical and logical rowids. 

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 

UTLEXPT1.SQL 

Constraints 

Any user 

For use with Oracle8i. Creates the default table (EXCEPTIONS) for storing exceptions from enabling constraints. Can handle both physical and logical rowids. 

UTLHTTP.SQL  

Web access 

SYS or SYSDBA 

PL/SQL package to retrieve data from Internet or intranet web servers via HTTP protocol 

UTLIP.SQL  

PL/SQL 

SYS 

Used primarily for migration, 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 

UTLPG.SQL  

Data conversion 

SYS or SYSDBA 

Provides a package that converts IBM/370 VS COBOL II 

UTLPWDMG.SQL  

Security 

SYS or SYSDBA 

Creates PL/SQL function for default password complexity verification. Sets the default password profile parameters and enables password management features. 

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  

Advanced Replication 

Any user 

Copies a snapshot schema from another snapshot site 

UTLTKPROF.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 table required for storing output of ANALYZE TABLE ...VALIDATE STRUCTURE of a partitioned table 

UTLXPLAN.SQL  

Performance management 

Any user 

Creates the table PLAN_TABLE, which holds output from the EXPLAIN PLAN command 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index