|
Catalog & Utility scripts for Oracle 9.2.0 (supplied in Oracle_Home/RDBMS/Admin)
bdemobld.sql - Build Oracle Data Browser Demonstration Tables build_db.sql - Example database creation script CATALOG.SQL - Create data dictionary views. CATAUDIT.SQL - Data dictionary views for auditing. (CATNOAUD.SQL will remove) catblock.sql - Create views of oracle locks catclust.sql - Create CLUSTer database specific views definitions catdbsyn.sql - catalog dba synonyms (dba_synonyms.sql) Create DBA only dictionary views - obsolete as DBA is now a role. All DBA_% views have a corresponding public synonym, and are accessible to any user with SELECT ANY TABLE privilege. catexp7.sql - Create v7 style export/import views CATEXP81.SQL - Create internal views for Export/Import utility catio.sql - Collect I/O per table/object stats by statistical sampling catjava.sql - CATalog scripts for JAVA catjobq.sql - Catalog views for the job queue catjvm.sql - create USER|DBA|ALL_JAVA_* views catldap.sql - CATalog for LDAP pl/sql API catldr.sql - Views for the direct path of the loader catlsby.sql - Logical Standby tables and views CATPART.SQL - Creates data dictionary views for the partitioning table. (catnoprt.sql Will remove) catoctk.sql - CATalog - Oracle Cryptographic ToolKit catol.sql - outline views and synonyms catparr.sql - Parallel-Server specific views, performance queries, etc catpatch.sql - Script to apply CATalog PATCH set CATPITR.SQL - Tablespace Point in Time specific views CATPLUG.SQL - Pluggable Tablespace check views CATPRC.SQL - Creates data dictionary views for types, stored procedures, and triggers. catproc.sql - Run all sql scripts for the procedural option catqm.sql - Creates the tables and views needed to run the XDB system catqueue.sql - contains the queue dictionary information catrep.sql - Run all sql scripts for replication option catrepc.sql - repcat tables, views, and sequences catrepm.sql - catalog script for master replication packages catrepr.sql - CATalog REPlication Remove catreps.sql - installs PL/SQL packages for snapshot functionality. catrls.sql - Catalog views for Row Level Security catrm.sql - packages for the DBMS Resource Manager catrpc.sql - RPC procedural option catrule.sql - Rules Catalog creation catsnap.sql - data dictionary views for snapshots CATSNMP.SQL - Creates an SNMPAgent role catspace.sql - CATalog SPACE management (remove with catspaced.sql) catsum.sql - data dictionary views for summary management catsvrmg.sql - Create the views and tables required for Server Manager csminst.sql - Create tables for Database Character Set Migration Utility d0801070.sql - downgrade Oracle RDBMS from current release to 8.1.7 d0900010.sql - downgrade Oracle RDBMS from current release to 9.0.1 dbmsalrt.sql - Blocking implementation of DBMS "alerts" dbmsapin.pls - dbms_application_info package spec for applications. nothing.sql - does nothing migrate.bsq - script for the migration utility scott.sql - Create scott/tiger sample data (UTLSAMPL.SQL) spauto.sql - SQL*PLUS collection of STATPACK statistics spcpkg.sql - SQL*PLUS command file to create statistics package spcreate.sql - creates the STATSPACK user spctab.sql - STATSPACK tables spcusr.sql - User for the STATSPACK database objects. spdoc.txt - STATSPACK documentation spdrop.sql - drop user spdtab.sql - drop STATSPACK tables spdusr.sql - DROP user which contains the STATSPACK database objects. sppurge.sql - STATSPACK Purge sprepins.sql - StatsPack Report Instance spreport.sql - Statspack report for current instance sprepsql.sql - SQL report to show resource usage, SQL Text and any SQL Plans sptrunc.sql - STATSPACK - Truncate tables spuexp.par - Export parameter file used to export the whole STATSPACK user. spup90.sql - Upgrades the Statspack schema to the 9.2 schema format userlock.sql - locking routines available for user-side client use UTLBSTAT.SQL - Gather start statistics UTLCHAIN.SQL - Table for the analyze list chained rows utlconst.sql - Script to check for valid date constraints. utldtree.sql - Show objects recursively (deptree.sql) utledtol.sql - Outline editing utility file utlenc.sql - PL/SQL Package for ENCODE (UTL_ENCODE) UTLESTAT.SQL - Gather Ending Statistics utlexcpt.sql - create exceptions table (except.sql) utlfile.sql - Routines to perform File I/O utlgdk.sql - Routines for Globalization utlhttp.sql - HTTP requests from stored programs utlinad.sql - Routines to perform Internet address resolution. utlincmp.sql - check for INCoMPatible objects before a downgrade utlirp.sql - UTiLity script to Invalidate & Recompile Pl/sql modules utljavarm.sql - Remove all java objects UTLLOCKT.SQL - Print lock wait-for graph tree utlpwdmg.sql - script for Default Password Resource Limits utlraw.sql - Routines to manipulate raws. utlrcmp.sql - dependency-based recompilation in parallel. utlrp.sql - UTiLity script Recompile invalid Pl/sql modules ** UTLSAMPL.SQL - Create scott/tiger sample data (Scott.sql) utlsmtp.sql - PL/SQL Package for Simple Mail Transfer Protocol (SMTP) utltcp.sql - PL/SQL Package for TCP/IP communication UTLTKPRF.SQL - Grant public access to all views used by TKPROF utlurl.sql - PL/SQL package to escape/unescape URLs. UTLVALID.SQL - Table for Analyze Validate (partitioned tables) utlxmv.sql - UTiLity for eXplain MView UTLXPLAN.SQL - create table PLAN_TABLE utlxplp.sql - UTiLity eXPLain Parallel plans utlxpls.sql - UTiLity eXPLain Serial plans utlxrw.sql - Create the output table for EXPLAIN_REWRITE xmlu901.sql - Upgrade from 9.0.1 database
Related Commands: