{"id":105,"date":"2009-10-01T14:09:00","date_gmt":"2009-10-01T12:09:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2009\/10\/01\/oracle-scripts\/"},"modified":"2010-08-24T22:38:28","modified_gmt":"2010-08-24T20:38:28","slug":"oracle-scripts","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2009\/10\/01\/oracle-scripts\/","title":{"rendered":"ORACLE SCRIPTS"},"content":{"rendered":"

podane za Oracle\u00ae Database Reference 10g<\/i> Release 2 (10.2)<\/b><\/a> Part Number B14237-04<\/p>\n

Table B-1 Creating the Data Dictionary Scripts<\/p>\n\n<\/col>\n<\/col>\n<\/col>\n\n\n\n\n\n\n
Script Name<\/th>\nNeeded For<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
\n

<\/a><\/a>catalog.sql<\/code><\/p>\n<\/td>\n

\n

All databases<\/p>\n<\/td>\n

\n

Creates the data dictionary and public synonyms for many of its views<\/p>\n

Grants PUBLIC<\/code> access to the synonyms<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>catproc.sql<\/code><\/p>\n<\/td>\n

\n

All databases<\/p>\n<\/td>\n

\n

Runs all scripts required for, or used with PL\/SQL<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>catclust.sql<\/code><\/p>\n<\/td>\n

\n

Real Application Clusters<\/p>\n<\/td>\n

\n

Creates Real Application Clusters data dictionary views<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n

Table B-2 Creating Additional Data Dictionary Structures<\/p>\n\n<\/col>\n<\/col>\n<\/col>\n<\/col>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Script Name<\/th>\nNeeded For<\/th>\nRun By<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
\n

<\/a><\/a>catblock.sql<\/code><\/p>\n<\/td>\n

\n

Performance management<\/p>\n<\/td>\n

\n

SYS<\/code><\/p>\n<\/td>\n

\n

Creates views that can dynamically display lock dependency graphs<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>catexp7.sql<\/code><\/p>\n<\/td>\n

\n

Exporting data to Oracle7<\/p>\n<\/td>\n

\n

SYS<\/code><\/p>\n<\/td>\n

\n

Creates the dictionary views needed for the Oracle7 Export utility to export data from the Oracle Database in Oracle7 Export file format<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>caths.sql<\/code><\/p>\n<\/td>\n

\n

Heterogeneous Services<\/p>\n<\/td>\n

\n

SYS<\/code><\/p>\n<\/td>\n

\n

Installs packages for administering heterogeneous services<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>catio.sql<\/code><\/p>\n<\/td>\n

\n

Performance management<\/p>\n<\/td>\n

\n

SYS<\/code><\/p>\n<\/td>\n

\n

Allows I\/O to be traced on a table-by-table basis<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>catoctk.sql<\/code><\/p>\n<\/td>\n

\n

Security<\/p>\n<\/td>\n

\n

SYS<\/code><\/p>\n<\/td>\n

\n

Creates the Oracle Cryptographic Toolkit package<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>catqueue.sql<\/code><\/p>\n<\/td>\n

\n

Advanced Queuing<\/p>\n<\/td>\n

<\/td>\n\n

Creates the dictionary objects required for Advanced Queuing<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>catrep.sql<\/code><\/p>\n<\/td>\n

\n

Oracle Replication<\/p>\n<\/td>\n

\n

SYS<\/code><\/p>\n<\/td>\n

\n

Runs all SQL scripts for enabling database replication<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>catrman.sql<\/code><\/p>\n<\/td>\n

\n

Recovery Manager<\/p>\n<\/td>\n

\n

RMAN<\/code> or any user with GRANT_RECOVERY_CATALOG_OWNER<\/code> role<\/p>\n<\/td>\n

\n

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<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>dbmsiotc.sql<\/code><\/p>\n<\/td>\n

\n

Storage management<\/p>\n<\/td>\n

\n

Any user<\/p>\n<\/td>\n

\n

Analyzes chained rows in index-organized tables<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>dbmspool.sql<\/code><\/p>\n<\/td>\n

\n

Performance management<\/p>\n<\/td>\n

\n

SYS<\/code> or SYSDBA<\/code><\/p>\n<\/td>\n

\n

Enables DBA to lock PL\/SQL packages, SQL statements, and triggers into the shared pool<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>userlock.sql<\/code><\/p>\n<\/td>\n

\n

Concurrency control<\/p>\n<\/td>\n

\n

SYS<\/code> or SYSDBA<\/code><\/p>\n<\/td>\n

 <\/p>\n

Provides a facility for user-named locks that can be used in a local or clustered environment to aid in sequencing application actions<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a><\/a><\/a>utlbstat.sql<\/code> and utlestat.sql<\/code><\/p>\n<\/td>\n

\n

Performance monitoring<\/p>\n<\/td>\n

\n

SYS<\/code><\/p>\n<\/td>\n

\n

Respectively start and stop collecting performance tuning statistics<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlchn1.sql<\/code><\/p>\n<\/td>\n

\n

Storage management<\/p>\n<\/td>\n

\n

Any user<\/p>\n<\/td>\n

\n

For use with the Oracle Database. Creates tables for storing the output of the ANALYZE<\/code> command with the CHAINED ROWS<\/code> option. Can handle both physical and logical rowids.<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlconst.sql<\/code><\/p>\n<\/td>\n

\n

Year 2000 compliance<\/p>\n<\/td>\n

\n

Any user<\/p>\n<\/td>\n

\n

Provides functions to validate that CHECK<\/code> constraints on date columns are year 2000 compliant<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utldtree.sql<\/code><\/p>\n<\/td>\n

\n

Metadata management<\/p>\n<\/td>\n

\n

Any user<\/p>\n<\/td>\n

\n

Creates tables and views that show dependencies between objects<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlexpt1.sql<\/code><\/p>\n<\/td>\n

\n

Constraints<\/p>\n<\/td>\n

\n

Any user<\/p>\n<\/td>\n

\n

For use with the Oracle Database. Creates the default table (EXCEPTIONS<\/code>) for storing exceptions from enabling constraints. Can handle both physical and logical rowids.<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlip.sql<\/code><\/p>\n<\/td>\n

\n

PL\/SQL<\/p>\n<\/td>\n

\n

SYS<\/code><\/p>\n<\/td>\n

\n

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<\/code> and DBMS_STANDARD<\/code>, which are necessary for any PL\/SQL compilations.<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlirp.sql<\/code><\/p>\n<\/td>\n

\n

PL\/SQL<\/p>\n<\/td>\n

\n

SYS<\/code><\/p>\n<\/td>\n

\n

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<\/code> and DBMS_STANDARD<\/code>, which are necessary for using PL\/SQL. Finally, it triggers a recompilation of all PL\/SQL modules, such as packages, procedures, and types.<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utllockt.sql<\/code><\/p>\n<\/td>\n

\n

Performance monitoring<\/p>\n<\/td>\n

\n

SYS<\/code> or SYSDBA<\/code><\/p>\n<\/td>\n

\n

Displays a lock wait-for graph, in tree structure format<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlpwdmg.sql<\/code><\/p>\n<\/td>\n

\n

Security<\/p>\n<\/td>\n

\n

SYS<\/code> or SYSDBA<\/code><\/p>\n<\/td>\n

\n

Creates PL\/SQL functions for default password complexity verification. Sets the default password profile parameters and enables password management features.<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlrp.sql<\/code><\/p>\n<\/td>\n

\n

PL\/SQL<\/p>\n<\/td>\n

\n

SYS<\/code><\/p>\n<\/td>\n

\n

Recompiles all existing PL\/SQL modules that were previously in an INVALID<\/code> state, such as packages, procedures, and types.<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlsampl.sql<\/code><\/p>\n<\/td>\n

\n

Examples<\/p>\n<\/td>\n

\n

SYS<\/code> or any user with DBA role<\/p>\n<\/td>\n

\n

Creates sample tables, such as emp<\/code> and dept<\/code>, and users, such as scott<\/code><\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlscln.sql<\/code><\/p>\n<\/td>\n

\n

Oracle Replication<\/p>\n<\/td>\n

\n

Any user<\/p>\n<\/td>\n

\n

Copies a snapshot schema from another snapshot site<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utltkprf.sql<\/code><\/p>\n<\/td>\n

\n

Performance management<\/p>\n<\/td>\n

\n

SYS<\/code><\/p>\n<\/td>\n

\n

Creates the TKPROFER role to allow the TKPROF profiling utility to be run by non-DBA users<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlvalid.sql<\/code><\/p>\n<\/td>\n

\n

Partitioned tables<\/p>\n<\/td>\n

\n

Any user<\/p>\n<\/td>\n

\n

Creates tables required for storing output of ANALYZE TABLE ...VALIDATE STRUCTURE<\/code> of a partitioned table<\/p>\n<\/td>\n<\/tr>\n

<\/p>\n

<\/a><\/a>utlxplan.sql<\/code><\/p>\n<\/td>\n

\n

Performance management<\/p>\n<\/td>\n

\n

Any user<\/p>\n<\/td>\n

\n

Creates the table PLAN_TABLE<\/code>, which holds output from the EXPLAIN PLAN<\/code> statement<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n

Table B-4 Upgrade and Downgrade Scripts<\/p>\n\n<\/col>\n<\/col>\n<\/col>\n\n\n\n\n\n\n\n
Script Name<\/th>\nNeeded For<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
\n

<\/a><\/a>catdwgrd.sql<\/code><\/p>\n<\/td>\n

\n

Downgrading<\/p>\n<\/td>\n

\n

Provides a direct downgrade path from the new Oracle Database 10g<\/span> release<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>catupgrd.sql<\/code><\/p>\n<\/td>\n

\n

Upgrading<\/p>\n<\/td>\n

\n

Provides a direct upgrade path to the new Oracle Database 10g<\/span> release<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlu102i.SQL<\/code><\/p>\n<\/td>\n

\n

Pre-Upgrade Information<\/p>\n<\/td>\n

\n

Analyzes the database to be upgraded, detailing requirements and issues for the upgrade to release 10.2<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>utlu102s.SQL<\/code><\/p>\n<\/td>\n

\n

Post-Upgrade Status<\/p>\n<\/td>\n

\n

Displays the component upgrade status after an upgrade to release 10.2<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n

Table B-5 Java Scripts<\/p>\n\n<\/col>\n<\/col>\n\n\n\n\n\n\n
Script Name<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
\n

<\/a><\/a>initjvm.sql<\/code><\/p>\n<\/td>\n

\n

Initializes JServer by installing core Java class libraries and Oracle-specific Java classes<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>rmjvm.sql<\/code><\/p>\n<\/td>\n

\n

Removes all elements of the JServer<\/p>\n<\/td>\n<\/tr>\n

\n

<\/a><\/a>catjava.sql<\/code><\/p>\n<\/td>\n

\n

Installs Java-related packages and classes<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

podane za Oracle\u00ae Database Reference 10g Release 2 (10.2) Part Number B14237-04 Table B-1 Creating the Data Dictionary Scripts Script Name Needed For Description catalog.sql All databases Creates the data dictionary and public synonyms for many of its views Grants PUBLIC access to the synonyms catproc.sql All databases Runs all scripts required for, or used […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[22],"class_list":["post-105","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-scripts"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=105"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/105\/revisions"}],"predecessor-version":[{"id":180,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/105\/revisions\/180"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}