oracle编译文件后缀,oracle提供的那个编译所有对象的脚本是什么名字？谢谢

嘿嘿，自己DIY了一个

D:\oracle\ora92\rdbms\admin>grep ".sql -" utlrp.sql

Rem      utlrp.sql - UTiLity script Recompile invalid Pl/sql modules

D:\oracle\ora92\rdbms\admin>grep ".sql -" utl*.sql

utlchn1.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 script to check for INCoMPatible

utlip.sql:Rem     utlip.sql - UTiLity script to Invalidate & Recompile Pl/sql modules

utlirp.sql:Rem     utlirp.sql - UTiLity script 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 script 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 - script 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 script 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