oracle rdms目录,ORACLE_HOME/rdbms/admin/目录下utl*.sql文件的说明

$grep

".sql -" utl*.sqlutlchn1.sql:Rem utlchn1.sql -

utlconst.sql:Rem utlconst.sql - constraint check utility

utlcxml.sql:Rem utlcxml.sql - PL/SQL wrapper over COREs C-based

XML/XSL processor

utldst.sql:Rem utldst.sql - Downgrade System Types

compatibility

utldtree.sql:Rem deptree.sql - Show objects recursively dependent

on given object

utledtol.sql:Rem utledtol.sql - Outline editing utility file

utlenc.sql:REM utlenc.sql - PL/SQL Package for ENCODE

(UTL_ENCODE)

utlexcpt.sql:Rem except.sql -

utlexpt1.sql:Rem utlexpt1.sql -

utlfile.sql:REM utlfile.sql - PL/SQL Package of File I/O

routines

utlgdk.sql:Rem utlgdk.sql - Globalization Development Kit

utlhttp.sql:REM utlhttp.sql - HTTP requests from stored

programs

utlinad.sql:REM utlinad.sql - PL/SQL Package for Internet

address

utlincmp.sql:Rem utlincmp.sql - UTiLity scrīpt to check for

INCoMPatible

utlip.sql:Rem utlip.sql - UTiLity scrīpt to Invalidate

& Recompile Pl/sql modules

utlirp.sql:Rem utlirp.sql - UTiLity scrīpt to Invalidate

& Recompile Pl/sql modules

utlirp.sql:Rem * change name utlrpls.sql -->

utlirp.sql;

utljavrm.sql:Rem utljavarm.sql - Remove all java objects

utlnchar.sql:Rem utlnchar.sql - The migration scrīpt for NCHAR data

from 8i to 9i

utlopslt.sql:Rem utlopslt.sql - Utility to dump lock tree in

OPS

utlpitl.sql:Rem utlpitl.sql - UTiLity to reset Pdml ITL

utlpwdmg.sql:Rem utlpwdmg.sql - scrīpt for Default Password

Resource Limits

utlraw.sql:Rem utlraw.sql - PL/SQL Package of utility routines for

raw datatypes

utlrcmp.sql:Rem utlrcmp.sql - Utility package for dependency-based

recompilation

utlrefld.sql:Rem utlrefld.sql - Load UTL_REF package on the

server

utlrp.sql:Rem utlrp.sql - UTiLity scrīpt Recompile invalid Pl/sql

modules

utlscln.sql:Rem utlscln.sql - UTILITY SNAPshot clone

utlsmtp.sql:REM utlsmtp.sql - PL/SQL Package for Simple Mail

Transfer Protocol (SMTP)

utlstddw.sql:Rem utlstddw.sql - UTL STanDard.sql DoWngrade

utltcp.sql:REM utltcp.sql - PL/SQL Package for TCP/IP

communication

utlurl.sql:REM utlurl.sql - PL/SQL Package for URL (UTL_URL)

utlxmv.sql:Rem utlxmv.sql - UTiLity for eXplain MV

utlxplp.sql:Rem utlxplp.sql - UTiLity eXPLain Parallel plans

utlxpls.sql:Rem utlxpls.sql - UTiLity eXPLain Serial plans

utlxrw.sql:Rem utlxrw.sql - Create the output table for

EXPLAIN_REWRITE