Search notes:

$ORACLE_HOME/rdbms/admin

Annotations in SQL files

Some SQL files are annotated with lines looking like 
--CATCTL -S
These annotations are used by catctl.pl to determine dependencies among invoked SQL files. Independent SQL files can then be processed in parallel.

List of files found in $ORACLE_HOME/rdbms/admin

With some exceptions, the following files might be found in an 18c installation.
a1102000.sql
a1201000.sql
a1202000.sql
addmrpt.sql SQL*Plus script to run Automatic Database Diagnostic Monitor (ADDM) analysis on a pair on AWR snapshots and display the result of the analysis.
addmrpti.sql SQL*Plus script that prompts for dbid and instance number to run ADDM analysis on a pair of AWR snapshots and display the result of the analysis.
addmtmig.sql Post upgrade script for 11.1 release to fill new ADDM task metadata tables with derived information.
apex_to_common.sql
approot_to_pdb.sql App Root -> PDB conversion script
ashrpt.sql SQL*Plus script to generate an ASH report
ashrpti.sql
ashrptinoop.sql
ashrptipdb.sql
ashrptistd.sql
autoupgrade.jar
awrblmig.sql
awrddinp.sql A chunk of common code used for SWRF reports and ADDM. This script gets the dbid,eid,filename,etc from the user for both components to use.
awrddrpi.sql Workload Repository Compare Periods Report
awrddrpt.sql Calls awrddrpi.sql with the dbid and instance number of that of the instance that is currently connected to.
awrextr.sql SQL*Plus script to help users extract data from the AWR
awrgdinp.sql AWR Glopal Compare Period Report Input variables
awrgdrpi.sql RAC Version of Compare Period Report
awrgdrpt.sql Calls awrgdrpi.sql with dbid and instance number of instance that the session is currently connected to.
awrginp.sql Used in conjunction with AWR RAC report
awrgrpt.sql AWR global report
awrgrpti.sql The AWR global report. It produces a report for all available instances in an Oracle RACenvironment. Can be invoked via awrgrpt.sql
awrinfo.sql Show general AWR information such as size, data distribution etc. to diagnose abnormalities in AWR.
awrinpnm.sql
awrinput.sql
awrload.sql SQL/Plus script to help users load data into the AWR from a dump file.
awrmacro.sql AWR utility to define macros for SQL*Plus scripts
awrrpt.sql Uses awrrpti.sql to produce the AWR report for th current (i.e. local) database.
awrrpti.sql Report differences between two AWR snapshots. See also awrrpt.sql
awrrptidc.sql
awrrptinoop.sql An «empty» script to implement if/else logic in SQL*Plus scripts
awrsqrpi.sql
awrsqrpt.sql
awrupd12.sql
bugfix16173764.sql
bulkimport.pl Perl script to automate the RMAN bulk import process.
bundlefcp_DBBP.xml
c1102000.sql apply current release patch release
c1201000.sql apply current release patch release
c1201000_wrr.sql Workload Capture and Replay upgrade script
c1202000.sql
c1202000_wrr.sql Workload Capture and Replay upgrade script
cataclsrv.sql Create DBSFWUSER schema and ACL table.
catactx.sql v$context etc.
catadmprvs.sql Grant privileges to administrative users (SYSBACKUP, SYSDG, SYSKM)
catadrvw.sql Catalog ADR views (v$diag… etc.)
catadt.sql Data dictionary views for metadata information for types and other object features.
catadv.sql Advisor framework definitions (dba_advisor…)
catadvtb.sql
catalog.sql creates the data dictionary views
catalogses.sql
catalrt.sql
catamgt.sql DBA_AUDIT_MGMT…
catapp.sql Streams apply views
catapp_mig.sql
catappcdbviews.sql create Application related CDB Views
catappcont.sql Create objects for transaction guard
catappcontainer.sql Application Container tables and views
catappcontainertab.sql
catappupgbeg1.sql
catappupgbeg2.sql
catappupgend.sql
catappupgpre.sql Creates objects needed for ALTER PLUGGABLE DATABASE APPLICATION statements to run properly. pdb_sync$, fed$apps, etc.
catapt.sql
cataqalt121.sql
cataqjms.sql Create aqjms types
cataqsch.sql AQ dictionary objects that depend on the scheduler
catar.sql
catatsk.sql
cataudit.sql Creates data dictionary views for auditing. Compare with catnoaud.sql
catawr.sql
catawrcdbvw.sql Catalog script for AWR CDB views, used to install the workload repository schema. Compare with catawrvw.sql
catawrpd.sql
catawrpdbvw.sql
catawrrtvw.sql
catawrtb.sql
catawrtv.sql
catawrvw.sql Catalog script for AWR views, used to create the workload repository schema. Compare with catawrcdbvw.sql
catbac.sql
catblock.sql Creates views that can dynamically display lock dependency graphs
catbsln.sql
catbslnd.sql
catbslnt.sql
catbslnv.sql
catbslny.sql
catcap.sql
catcapi.sql
catcapit.sql
catcdb.pl
catcdb.sql
catcdbviews.sql
catchnf.sql
catcio.sql
catclust.sql Cluster database specific view definitions, dbms_clustdb, … (Must by run as SYS)
catcmp.sql
catcmprm.sql
catcon.pl CONtainer-aware Perl script for creating or upgrading CATalogs. Uses catcon.pm
catcon.pm
catcon_kill_sess_gen.sql
catconst.pm
catcont.sql
catcr.sql
catcrc.sql
catcredv.sql
catcrsc.sql Catalog component registry server components: constants to identify server components and the associated upgrade/downgrade/patch/reload scripts.
catctl.pl Perl script to to organize (catalog related) SQL files for parallel processing.
catdbfus.sql
catdbl.sql
catdbsyn.sql
catdef.sql Table default_pwd$ storing values of default users with SHA1 of their default passwords.
catdefer.sql
catdevrol.sql Creates db_developer_role and grants it some privileges (Oracle 23c).
catdip.sql
catdpb.sql
catdph.sql Main install script for all Data Pump header components.
catdwgrd.sql Database downgrade from the current release to the original release. See also -r option of catcon.pl.
catemini.sql
catemxt.sql Creates the base tables for EM Express. See catemxv.sql for view defs.
catemxv.sql View definitions for EM Express file manager.
catepg.sql
catexp.sql Creates (internal) views for the export/import utility.
catexp7.sql
catfga.sql
catfgr.sql
catfinal.sql
catfusrg.sql Registration of DB Feature Usage which allows the clients of DB Feature Usage infrastructure to register their features and high water marks.
catgdtab.sql
catggshard.sql
catgwm.sql
catgwmcat.sql Catalog script for GSM on on the catalog database
cathae.sql
cathcsx.sql
cathive.sql
cathive1.sql
cathmgr.sql
caths.sql installs packages for administering heterogeneous services
catidxu.sql
catilm.sql
catilmini.sql
catilmtab.sql
catimfstab.sql
catimime.sql
catio.sql trace I/O on a table-by-table basis
catjava.sql Catalog scripts for Java
catjobq.sql
catjsont.sql Opaque types to work with JSON in PL/SQL.
catjsonv.sql
catjvm.sql
catkppls.sql Catalog views related to the connection pool on the server side. (See also cpool$)
catlbacs.sql
catldap.sql
catldr.sql Creates views that are necessary for direct path loads in SQL*Loader.
catlibc.sql
catlmnr.sql
catlmnr_mig.sql
catlsby.sql
catmac.sql
catmaca.sql
catmacc.sql
catmacd.sql Creates seed data for the code$ table.
catmacdd.sql
catmacg.sql
catmach.sql
catmacp.sql
catmacpatch.sql
catmacpost.sql
catmacpre.sql Creates Data Vault account manager account
catmacr.sql
catmacs.sql
catmact.sql
catmet2.sql
catmeta.sql
catmetgrant1.sql
catmetgrant2.sql
catmetinsert.sql Inserts data into the Oracle dictionary for use by the DataPump Metadata API.
catmettypes.sql
catmetviews.sql Creates the views that are related to the DataPump metadata APIs.
catmetviews_mig.sql Creates catmet views whose definitions are dependent on «new» columns in bootstrap tables.
catmetx.sql
catmetx2.sql
catmgd.sql Installation of MGD
catmmig.sql
catmntr.sql
catmvrs.sql
catmwin.sql Defines maintenance window and stats collection job.
catnacl.sql
catnaclv.sql
catnoadt.sql drop views and synonyms on dictionary metadata that relate to object types.
catnoalr.sql
catnoap.sql
catnoaud.sql drops views and synonyms on auditing metadata. Compare with cataudit.sql
catnoawr.sql
catnocapi.sql
catnoclust.sql drops views that are specific to Oracle Real Application Clusters (Oracle RAC)
catnodp.sql
catnodpall.sql
catnodpaq.sql
catnodpobs.sql
catnoexf.sql
catnofus.sql
catnoggshard.sql
catnohs.sql removes Heterogeneous Services dictionary metadata.
catnojav.sql drops the RDBMS Java classes and system triggers created by the catjava.sql script.
catnomgd.sql
catnomta.sql
catnomtr.sql
catnomwn.sql
catnoprc.sql
catnoprt.sql drops views and synonyms on dictionary metadata that relate to partitioned tables and indexes.
catnoqpi.sql
catnoratmask.sql
catnorep.sql
catnorul.sql
catnosch.sql
catnosodacoll.sql
catnosvm.sql removes Oracle7 Server Manager views and synonyms
catnoumf.sql
catnowrr.sql master script that drops the entire schema related to Database Replay - calls the drop schema scripts for Workload Capture, Database Replay, Workload Replay, and Workload Intelligence
catnowrrc.sql drops the schema related to Workload Capture
catnowrrp.sql drops the schema related to Workload Replay
catnowrrwitb.sql drops the schema related to Workload Intelligence
catnozxs.sql
catnsnmp.sql drops the DBSNMP user and SNMPAGENT role
catobtk.sql
catocm.sql
catoctk.sql
catodci.sql Types and interfaces for extensibility (aka Data Cartridge?)
catodm.sql
catol.sql
catols.sql Installs Oracle Label Security.
catolsd.sql Oracle Label Security with OID support.
catolsdd.sql
catolsddv.sql
catolsrecomp.sql
catost.sql Optimizer Statistics tables and views (that cannot be created while running catalog.sql, see also doptim.bsq and cdoptim.sql)
catparr.sql
catpcat.sql Runs catalog.sql and catproc.sql in parallel (See also catctl.pl).
catpcnfg.sql
catpdbms.sql Creates package specifications and standalone procedures/functions.
catpdeps.sql
catpend.sql
catpexe.sql
catpexec.sql
catpexev.sql
catpgrants.sql
catpitr.sql
catplan.sql Create the table plan_table$, the public synonym plan_table pointing to plan_table$ and related stuff.
catplug.sql
catpplb.sql
catpprvt.sql
catprc.sql All scripts for the procedural option.
catproc.sql runs all sql scripts that are required or used with PL/SQL (the procedural option)
catprocses.sql
catprofa.sql
catprofc.sql
catprofp.sql
catproft.sql
catproftab.sql
catprp.sql
catpses.sql
catpspec.sql
catpspi.sql
catpstdy.sql
catpstr.sql
catpstrt.sql
catptabs.sql
catptt.sql
catptyps.sql
catpvf.sql Password verify functions, STIG profile
catqitab.sql
catqm.sql
catqm_adw.sql simplified version of catqm.sql, installs XDB for ADWC (it installs dbms_xmlgen, dbms_xmldom, dbms_xmlparser, dbms_xslprocessor, dbms_xmlindex and SODA related packages, but no XDB repositories or schemas).
catqm_int.sql SQL XML management (XDB user etc.)
catqos.sql
catqueue.sql creates the dictionary objects required for Advanced Queuing
catratmask.sql
catredact.sql
catrelod.sql
catremvxutil.sql
catremxutil.sql
catreplt.sql runs all SQL scripts for enabling database replication
catrept.sql
catrepv.sql
catrequired.sql
catrequtlmg.sql
catresults.sql
catrls.sql
catrm.sql
catrmno.sql
catrms.sql
catrpc.sql Creates internal views for RPC (only needed for databases with the procedural option that are accessed by remote databases).
catrsa.sql
catrse.sql
catrssch.sql
catrule.sql This script creates the PL/SQL packages and catalog for the rule engine.
catrupg.sql
catsadv.sql
catsch.sql Base tables and catalog views for the job scheduler.
catschv.sql
catscqa.sql
catshutdown.sql
catshutdownpdb.sql
catsmbvw.sql Creation of SQL Management Base catalog views (DBA_SQL_PROFILES …)
catsnap.sql Data dictionary views for snapshots (dba_snapshot etc.)
catsnmp.sql
catsodacoll.sql
catsodaddl.sql
catsodaview.sql
catspacd.sql
catspace.sql
catspd.sql
catsqlreg.sql
catsqlt.sql Types and tables for SQL Tune Advisor, SQL Tuning Set and SQL Profile
catsqltk.sql
catsqltv.sql
catsscr.sql
catstr.sql
catstrc.sql
catstrm.sql
catstrr.sql
catstrt.sql
catsum.sql
catsumaa.sql
catsumat.sql
catsumno.sql
catsvrmg.sql
cattlog.sql
cattrans.sql
catts.sql
cattsdp.sql
cattsm.sql
cattsmcr.sql
catuat.sql
catumftb.sql
catumftv.sql
catumfusr.sql
catumfvw.sql
catupcox.sql
catupend.sql
catupgrd.sql
catuposb.sql
catupprc.sql
catuppst.sql
catupses.sql
catupshd.sql
catupstr.sql
catuptabdata.sql
catvxutil.sql
catwrr.sql Master script that creates the entire schema related to Database Replay
catwrrtb.sql
catwrrtbc.sql
catwrrtbp.sql
catwrrtv.sql
catwrrvw.sql
catwrrvwc.sql
catwrrvwp.sql
catwrrwitb.sql creates the schema for Workload Intelligence
catwrrwivw.sql
catxdav.sql
catxdav2.sql
catxdbapp.sql
catxdbc1.sql
catxdbc2.sql
catxdbck.sql
catxdbdbca.sql
catxdbdl.sql
catxdbdr.sql
catxdbdt.sql
catxdbdv.sql
catxdbeo.sql
catxdbh.sql
catxdbj.sql
catxdbpi.sql Indextype information neeed to support the PATH INDEX (XDB).
catxdbpv.sql
catxdbr.sql
catxdbrs.sql
catxdbs.sql
catxdbst.sql
catxdbtm.sql
catxdbv.sql
catxdbvfexp.sql
catxdbvr.sql
catxdbz.sql
catxdbz0.sql
catxdbz1.sql
catxev.sql
catxidx.sql
catxlcr.sql
catxlcr1.sql
catxml.sql
catxmvrs.sql
catxpend.sql
catxrd.sql
catxs.sql
catxtbix.sql
catzxs.sql
cdadr.sql
cdaw.sql
cdbfixed.sql Creation of cv$… views
cdclst.sql views for clustering clause of a table
cdcore.sql Cataloc dcore.bsq views
cdcore_cols.sql
cdcore_ind.sql
cdcore_mig.sql
cdcore_misc.sql
cdcore_objs.sql
cdcore_pdbs.sql
cdcore_privs.sql
cdcore_stat.sql Statistics views needed at startup
cdcore_str.sql
cdcore_tabs.sql
cddm.sql
cddst.sql
cdend.sql Catalog end
cdenv.sql
cdenv_mig.sql
cdexttab.sql
cdfixed.sql Catalog fixed views
cdhcs.sql
cdjava.sql creates javaobj$ (which contains information about Java objects (classes, sources, resources, data etc.) and javasnm$.
cdmanage.sql
cdobj.sql
cdoptim.sql
cdpart.sql
cdpart_mig.sql
cdplsql.sql
cdrac.sql
cdrep.sql
cdsec.sql
cdsqlddl.sql
cdstrt.sql
cdsummgt.sql
cdtools.sql
cdtxnspc.sql
cmpdwgrd.sql
cmpupend.sql
cmpupgrd.sql
cmpupjav.sql
cmpupmsc.sql
cmpupnjv.sql
cmpupord.sql
cmpupsdo.sql
cmpupstr.sql
components.properties
corejava.sym
daw.bsq Analytic workspace catalog tables
dbfs_create_filesystem.sql Script to create a DBFS filesystem. Calls dbfs_create_filesystem_advanced.sql.
dbfs_create_filesystem_advanced.sql
dbfs_drop_filesystem.sql
dbfusrpi.sql
dbfusrpt.sql
dbms_registry_basic.sql SQLPLUS constants (such as C_ORACLE_HIGH_VERSION_0_DOTS … C_ORACLE_HIGH_VERSION_4_DOTS, C_ORACLE_HIGH_VERSIONFULL, C_ORACLE_HIGH_STATU etc) for use by Upgrade and Downgrade. The package dbms_db_version relies on the constant C_ORACLE_HIGH_VERSION_0_DOTS)
dbms_registry_extended.sql
dbmsaclsrv.sql
dbmsaddm.sql
dbmsadr.sql
dbmsadra.sql
dbmsadro.sql
dbmsadv.sql dbms_advisor
dbmsalrt.sql
dbmsamgt.sql
dbmsany.sql Specification of dbms_types, sys.anyData, sys.anyType and sys.anyDataSet
dbmsapin.sql
dbmsapp.sql
dbmsappcon.sql
dbmsappcont.sql
dbmsapre.sql
dbmsaq.plb
dbmsaq8x.plb
dbmsaqad.sql
dbmsaqds.plb
dbmsaqem.plb
dbmsasrt.sql
dbmsatsk.sql
dbmsaudutl.sql
dbmsautorep.sql
dbmsaw.sql
dbmsawex.sql
dbmsawr.sql
dbmsawst.sql
dbmsbkrs.sql
dbmsbsln.sql
dbmscap.sql
dbmscapi.sql The DBFS API (dbms_dbfs_content, dbms_dbfs_content_admin and dbms_dbfs_content_spi) specification.
dbmscbl.sql
dbmschnf.sql
dbmsclr.plb
dbmscmp.sql
dbmscoll.sql
dbmscomp.sql
dbmscov.sql
dbmscr.sql
dbmscred.sql
dbmscrs.sql
dbmscu.sql
dbmsdbcomp.sql
dbmsdbv.sql
dbmsdbvn.sql
dbmsddl.sql
dbmsdesc.sql
dbmsdg.sql
dbmsdiag.sql
dbmsdm.sql
dbmsdmpa.sql
dbmsdmxf.sql
dbmsdnfs.sql
dbmsdp.sql Specification for dbms_datapump
dbmsdpmt.sql
dbmsdrs.sql
dbmsdst.sql
dbmsedu.sql
dbmsepg.sql
dbmserlg.sql
dbmsfga.sql
dbmsfgd.sql
dbmsfgr.sql
dbmsfi.sql
dbmsfs.sql
dbmsfspi.sql
dbmsfus.sql
dbmsfuse.sql
dbmsgen.sql
dbmsgg.sql
dbmsgwm.sql
dbmsgwmalt.sql
dbmsgwmcl.sql
dbmsgwmco.sql
dbmsgwmdb.sql
dbmsgwmfix.sql
dbmsgwmfx.sql
dbmsgwmpl.sql
dbmsgwmut.sql
dbmshadp.sql
dbmshadp1.sql
dbmshae.sql
dbmshias.sql
dbmshier.sql
dbmshm.sql
dbmshmgr.sql
dbmshord.sql
dbmshpro.sql
dbmshptab.sql
dbmshrmg.sql
dbmshs.sql
dbmshsld.sql
dbmshssn.sql
dbmshsxp.sql
dbmsiast.sql
dbmsidxu.sql
dbmsilm.sql
dbmsindx.sql
dbmsinmem.sql
dbmsinmemadmin.sql
dbmsiotc.sql analyzes chained rows in index organized tables.
dbmsir.sql
dbmsjdcu.sql
dbmsjdev.sql
dbmsjdmp.sql
dbmsjdwp.sql
dbmsjob.sql
dbmsjson.sql
dbmskzxp.sql
dbmslcr.sql Opaque type definitions for sys.lcr$_row_record, sys.lcr$_ddl_record and sys.lcr$_procedure_record. Package definition dbms_lcr. (LCR = Logical Change Record?)
dbmsldap.sql
dbmslibc.sql
dbmslm.sql
dbmslmd.sql
dbmslob.sql
dbmslobu.sql
dbmslock.sql
dbmslsby.sql
dbmsmap.sql
dbmsmb.sql
dbmsmemoptimize.sql
dbmsmet2.sql
dbmsmeta.sql
dbmsmetb.sql
dbmsmetd.sql
dbmsmeti.sql
dbmsmetu.sql
dbmsmntr.sql
dbmsmp.sql
dbmsnacl.sql
dbmsncdb.sql
dbmsobj.sql
dbmsobtk.sql
dbmsocm.sql
dbmsoctk.sql
dbmsodbo.sql
dbmsodm.sql
dbmsol.sql
dbmsoptim.sql
dbmsotpt.sql dbms_output
dbmspart.sql
dbmspb.sql dbms_debug (also dbms_debug_vc2coll)
dbmspbp.sql
dbmspbt.sql
dbmspclx.sql
dbmspdb.sql
dbmsperf.sql
dbmspexe.sql
dbmspexp.sql
dbmspipe.sql
dbmspitr.sql
dbmsplsw.sql
dbmsplts.sql
dbmspool.sql enables DBA to lock PL/SQL packages, SQL statements, and triggers into the Shared Pool
dbmspp.sql
dbmspplb.sql
dbmsprp.sql
dbmspsp.sql
dbmspspi.sql
dbmspump.sql
dbmsqopi.sql
dbmsrand.sql
dbmsratmask.sql
dbmsrcad.sql
dbmsread.sql
dbmsredacta.sql
dbmsrep.sql
dbmsrepl.sql
dbmsres.sql
dbmsrlsa.sql
dbmsrmad.sql
dbmsrman.sql
dbmsrmansys.sql
dbmsrmanvpc.sql
dbmsrmge.plb
dbmsrmin.plb
dbmsrmpa.plb
dbmsrmpe.plb
dbmsrmpr.sql
dbmsrms.sql
dbmsrpr.sql
dbmsrqmo.sql
dbmsrsa.plb
dbmsrsicd.plb
dbmsrspreq.plb
dbmsrupg.sql
dbmsrwid.sql
dbmssch.sql Specification for dbms_scheduler.
dbmsscnc.sql
dbmssess.sql
dbmssjty.sql
dbmsslrt.sql
dbmsslxp.sql
dbmssml.sql
dbmssnap.sql
dbmssodacoll.sql
dbmssodadom.sql
dbmssodapls.sql
dbmssodautil.sql
dbmsspa.sql
dbmsspc.sql
dbmsspd.sql
dbmsspm.sql
dbmsspu.sql
dbmssqds.plb
dbmssql.sql
dbmssqll.sql
dbmssqlm.sql
dbmssqlpatch.sql
dbmssqls.sql
dbmssqlt.sql
dbmssqlu.sql
dbmssrv.sql
dbmsstat.sql
dbmsstdx.sql
dbmsstr.sql
dbmssts.sql
dbmsstts.sql
dbmssum.sql
dbmssupp.sql installs dbms_support.
dbmssyer.sql
dbmstcv.sql
dbmstf.sql dbms_tf
dbmstns.sql
dbmstran.sql
dbmstrig.sql
dbmstrns.sql
dbmstrst.sql
dbmstsdp.sql
dbmstsdpe.sql
dbmstsdpm.sql
dbmstutl.sql
dbmstxfm.sql
dbmstxin.sql
dbmstypu.sql
dbmsuadv.sql
dbmsumf.sql
dbmsupgin.sql
dbmsupgnv.sql
dbmsuri.sql
dbmsutil.sql
dbmswlm.sql
dbmswrr.sql
dbmsxa.sql
dbmsxdb.sql
dbmsxdba.sql
dbmsxdbc.sql
dbmsxdbdt.sql
dbmsxdbr.sql
dbmsxdbrepos.sql
dbmsxdbschmig.sql
dbmsxdbt.sql
dbmsxdbz.sql
dbmsxev.sql
dbmsxfr.sql
dbmsxidx.sql
dbmsxlsb.sql
dbmsxml.sql
dbmsxmld.sql
dbmsxmlp.sql
dbmsxmls.sql
dbmsxmlt.sql
dbmsxmlu.sql
dbmsxpln.sql
dbmsxrc.sql
dbmsxreg.sql
dbmsxres.sql
dbmsxsch.sql xdb.dbms_xmlschema: a package to register XML schemas with XDB. Must be run as XDB.
dbmsxschlsb.sql
dbmsxslp.sql
dbmsxstr.sql
dbmsxsu.sql
dbmsxtr.sql
dbmsxuducu.sql
dbmsxutil.sql
dbmsxvr.sql
dcore.bsq creates tables such as tab$, dual, …
ddm.bsq Data mining tables (model$ etc.)
ddst.bsq Long identifiers dictionary upgrade
demo.sql
denv.bsq
depsaq.sql
depscapi.sql
depspspi.sql
depssvrm.sql
deptxn.sql
dexttab.bsq
dfba.bsq seems to install the necessary tables for flashback data archive.
dfmap.bsq
dhcs.bsq Dictionary tables for hierarchy dimensions (HCS catalog tables).
diutil.sql DIANA application routines (package diutil). Compare with wpiutil.sql.
djava.bsq
dlmnr.bsq LogMiner
dmanage.bsq
dmeidmsys.sql
dmisc.bsq
dmproc.sql
dmsysrem.sql
dobj.bsq
doptim.bsq Tables that store statistics and associated metadata.
dpart.bsq Tables to store information about partitioned objects.
dpload.sql
dplsql.bsq PL/SQL related dynamic peformance tables such as procedure$, source$, idl_char$, idl_ub2$, …
dpstdy.bsq Primary standby? Creates system.redo_db and system.redo_log.
dmle.bsq Data dictionary definitions for MLE (Tables mle_module$, mle_env$, mleenvimports$ and proceduremle$).
drac.bsq Transparent session migration
drep.bsq
drpadrvw.sql
drupg.bsq Tables used by dbms_rolling (Rolling upgrade)
dsec.bsq Security related data dictionary components. (Users sys and system are created here!)
dsqlddl.bsq
dsummgt.bsq
dtlog.bsq
dtools.bsq
dtxnspc.bsq Among others, creates default undo, temp and permanent tablespaces, table smon_scn_time etc.
dumpdian.sql Package that allows to dump «DIANA» out of a database in a human-readable format.
dvdbmig.sql
dvdwgrd.sql
dve102.sql
dve111.sql
dve112.sql
dve121.sql
dve122.sql
dvmacfnc.plb
dvpatch.sql
dvregrant.sql
dvrelod.sql
dvremov.sql
dvu102.sql
dvu111.sql
dvu112.sql
dvu121.sql
dvu122.sql
e1102000.sql
e1201000.sql
e1201000_wrr.sql
e1202000.sql
e1202000_wrr.sql
emremove.sql
epgstat.sql A script that shows the various settings and states of the Embedded PL/SQL Gateway (EPG) and the XDB HTTP listener.
execaq.sql
execbsln.sql
execcr.sql
execemx.sql
exechae.sql
execlmnr.sql
execlmnrstats.sql
execocm.sql
execpdb.sql
execqopi.sql
execrep.sql
execrm.sql
execrsa.plb
execsch.sql
execschlb.plb
execsec.sql
execsmb.sql
execsqlt.sql
execstat.sql
execstr.sql
execsvr.sql
execsvrm.sql
exectsdp.sql
externaljob.ora Configuration file is used by dbms_scheduler when executing external (operatin system) jobs.
f1102000.sql
f1201000.sql
f1202000.sql
genezi.sym
getawrviewloc.sql
grntocmtabaccess.sql
hangdiag.sql Script for hang diagnosis
i1102000.sql
i1201000.sql
i1202000.sql
imupgrdses.sql
initdbj.sql
initjms.sql
initjvm2.sql
initjvm4.sql
initjvm5.sql
initjvma.sql
initmeta.sql
initmgd.sql
initscfw.sql Java wrapper for file watcher (scheduler object)
initsjty.sql
initsoxx.sql
initsqlj.sql
initxa.sql
initxml.sql Loads XML into JServer
initxqry.sql
javdbmig.sql
javdwgrd.sql
jave112.sql
jave121.sql
jave122.sql
loc_to_common0.sql
loc_to_common1.sql
loc_to_common2.sql
loc_to_common3.sql
loc_to_common4.sql
mgdmeta.sql
mgdpatch.sql
mgdpbs.sql
mgdrelod.sql
mgdsys.sql
mgdtab.sql
mgdtrg.sql
mgdtyp.sql
mgdus.sql
mgdview.sql
nacla112.sql
nacle102.sql
nacle111.sql
nacle112.sql
noncdb_to_pdb.sql Convert a DB to a PDB.
nothing.sql
oci.sym
ociw32.sym
ocmdbb.sql
ocmdbd.sql
ocmjb10.sql
ocmjd10.sql
ocmupgrd.sql
ocssd.sym
odbsrmt.pl
odmcpu.sql
odmdbmig.sql
odme101.sql
odme102.sql
odme111.sql
odme920.sql
odmpatch.sql
odmproc.sql
odmrelod.sql
odmu101.sql
odmu102.sql
odmu111.sql
odmu112.sql
odmu920.sql
olappl.sql
olaptf.plb
olsaudup.sql
olsdbmig.sql
olsdwgrd.sql
olse112.sql
olse121.sql
olse122.sql
olsload.sql
olspatch.sql
olspredowngrade.sql
olspreupgrade.sql
olsrelod.sql
olsrle.sql
olstrig.sql
olsu112.sql
olsu121.sql
olsu122.sql
olsup.sql
oraaccess.xsd
oracell18.sym
oracle.sym
oraclient18.sym
oraclsce18.sym
oraclscred18.sym
oraclsra18.sym
oracommon18.sym
oracore18.sym
oradbcfg18.sym
orageneric18.sym
oragns18.sym
oragnsjni18.sym
orahasgen18.sym
orahome.exe
oraipc1.sym
orajagent18.sym
oramql1.sym
oramysql18.sym
oranls18.sym
oraocci18.sym
oraocr18.sym
oraocrb18.sym
oraocrutl18.sym
oraopc.sym
oraosbws.sym
oraplc18.sym
oraplp18.sym
orapls18.sym
orara.sym
orardjni18.sym
oraskgxp18.sym
oraskgxpg18.sym
oraskgxpt18.sym
oraskgxpv18.sym
orasnls18.sym
orasql18.sym
orasrvm18.sym
orasrvmhas18.sym
orasrvmocr18.sym
orauini18.sym
oraunls18.sym
owachars.sql
owacomm.sql Installation of PL/SQL Gateway. Compare with owadins.sql
owacsyn.sql
owadins.sql Deinstallation of PL/SQL Gateway. Compare with owacomm.sql.
owadsyn.sql
owadummy.sql
owainst.sql
owaload.sql Installs the packages needed to run the PL/SQL Gateway.
owmadmb.plb
owmadms.plb
owmaqb.plb
owmaqs.plb
owmasrtb.plb
owmasrts.plb
owmblklb.plb
owmblkls.plb
owmcddlb.plb
owmcddls.plb
owmcmdv.plb
owmcpkgb.plb
owmcpkgs.plb
owmctrg.plb
owmctxb.plb
owmctxs.plb
owmcvws.plb
owmdbmig.sql
owmddlb.plb
owmddls.plb
owmdtrgb.plb
owmdtrgs.plb
owmdutlb.plb
owmdutls.plb
owmdwgrd.sql
owmdynb.plb
owmdyns.plb
owme112.sql
owme121.sql
owme122.sql
owmerrb.plb
owmerrs.plb
owmexpb.plb
owmexps.plb
owmgrnt.plb
owmiexpb.plb
owmiexps.plb
owminst.plb Installs Workspace Manager
owmltb.plb
owmlts.plb
owmltsysb.plb
owmltsyss.plb
owmmigb.plb
owmmigs.plb
owmmpb.plb
owmmps.plb
owmpkgb.plb
owmpkgs.plb
owmprvb.plb
owmprvs.plb
owmr1120.plb
owmr1210.plb
owmr1220.plb
owmrelod.sql
owmremov.sql
owmricb.plb
owmrics.plb
owmuany.plb
owmuinst.plb Uninstalls Workspace Manager
owmupgrd.plb
owmutlb.plb
owmutls.plb
owmutrgb.plb
owmutrgs.plb
owmvpkgb.plb
owmvpkgs.plb
owmvtb.plb
owmvts.plb
owmwdmlb.plb
owmwdmls.plb
owmwmsys.plb
parameters.properties List of deprecated, obsolete and removed parameters
pbload.sql
pbunload.sql
pdb_to_apppdb.sql
pdbdba.sql
perfhubrpt.sql
pidian.sql
pipidl.sql Package portable IDL.
pistub.sql
plitblm.sql PL/SQL Index-TaBLe Methods (count, first, last, exists etc.) for varrays etc. Comment mentions icd/plitblm.pls and kkwtp.c)
plspur.sql Package definition for sys.sys_stub_for_purity_analysis
preupgrade.jar
preupgrade_messages.properties
preupgrade_package.sql
prgrmanc.sql
privcach.sql
privcook.sql
privcust.sql
privht.sql Hyper-text packages that provide utility functions for producing HTML documents from PL/SQL (package bodies for htf and htp). See also pubht.sql.
privimg.sql
privmat.sql
privoolk.sql
privowa.sql
privpat.sql
privsec.sql
privtext.sql
privutil.sql
profload.sql Installs dbms_profiler (used before Oracle 10i).
proftab.sql
prvs_awr_data.plb
prvs_awr_data_cp.plb
prvsadri.plb
prvsadv.plb
prvsash.plb
prvsautorepi.plb
prvsawr.plb
prvsawri.plb
prvsawrs.plb
prvsawrv.plb
prvscpaddm.plb
prvsemx_admin.plb
prvsemx_cell.plb
prvsemx_dbhome.plb
prvsemx_memory.plb
prvsemx_perf.plb
prvsemx_rsrcmgr.plb
prvsemx_sql.plb
prvsemxi.plb
prvsfus.plb
prvshdm.plb
prvsrepr.plb
prvsrept.plb
prvsrtaddm.plb
prvssmb.plb
prvssmbi.plb
prvssmgu.plb
prvsspai.plb
prvsspdi.plb
prvsspmi.plb
prvssqlf.plb
prvssqli.plb
prvsumfi.plb
prvt_awr_data.plb
prvt_awr_data_cp.plb
prvtacl.plb
prvtaclsrv.plb
prvtaddm.plb
prvtadmi.plb
prvtadr.plb
prvtadra.plb
prvtadri.plb
prvtadv.plb
prvtalrt.plb
prvtamgt.plb
prvtany.plb
prvtapin.plb
prvtappcon.plb
prvtappcont.plb
prvtapre.plb
prvtaq.plb
prvtaq8x.plb
prvtaqad.plb
prvtaqal.plb
prvtaqdi.plb
prvtaqds.plb
prvtaqem.plb
prvtaqim.plb
prvtaqin.plb
prvtaqip.plb
prvtaqis.plb
prvtaqiu.plb
prvtaqji.plb
prvtaqjm.plb
prvtaqme.plb
prvtaqmi.plb
prvtaqxe.plb
prvtaqxi.plb
prvtash.plb
prvtasrt.plb
prvtatsk.plb
prvtatxp.plb
prvtaudutl.plb
prvtautorep.plb
prvtautorepi.plb
prvtaw.plb
prvtawex.plb
prvtawr.plb
prvtawri.plb
prvtawrs.plb
prvtawrv.plb
prvtawst.plb
prvtbapp.plb
prvtbcap.plb
prvtbcmp.plb
prvtbdbu.plb
prvtbdpi.plb
prvtbfgr.plb
prvtbfie.plb
prvtbgg.plb
prvtbggei.plb
prvtbhdlr.plb
prvtbias.plb
prvtbisagt.plb
prvtbisutl.plb
prvtbkrs.plb
prvtblcr.plb
prvtblib.plb
prvtblid.plb
prvtblin.plb
prvtblru.plb
prvtblut.plb
prvtbord.plb
prvtbpc.plb
prvtbpci.plb
prvtbpd.plb
prvtbpdi.plb
prvtbpexpi.plb
prvtbpf.plb
prvtbpfi.plb
prvtbpm.plb
prvtbpp.plb
prvtbprp.plb
prvtbpu.plb
prvtbpui.plb
prvtbpv.plb
prvtbpvi.plb
prvtbpw.plb
prvtbrmg.plb
prvtbrse.plb
prvtbsai.plb
prvtbsch.plb
prvtbscp.plb
prvtbsdp.plb
prvtbsha.plb
prvtbsln.plb
prvtbsmc.plb
prvtbsmt.plb
prvtbspa.plb
prvtbsrp.plb
prvtbssm.plb
prvtbstr.plb
prvtbsts.plb
prvtbxfr.plb
prvtbxstr.plb
prvtcapi.plb
prvtcbl.plb
prvtchnf.plb
prvtcia.plb
prvtciai.plb
prvtclkm.plb
prvtcmp.plb
prvtcmpl.plb
prvtcmpr.plb
prvtcoll.plb
prvtcomp.plb
prvtconsacl.plb
prvtcov.plb
prvtcpaddm.plb
prvtcr.plb
prvtcrc.plb
prvtcred.plb
prvtcrs.plb
prvtcstk.plb
prvtcxml.plb
prvtdadv.plb
prvtdbcomp.plb
prvtdbv.plb
prvtddl.plb
prvtdesc.plb
prvtdfrd.plb
prvtdg.plb
prvtdiag.plb
prvtdm.plb
prvtdmmi.plb
prvtdmpa.plb
prvtdmsu.plb
prvtdmtf.plb
prvtdmxf.plb
prvtdnfs.plb
prvtdp.plb
prvtdpcr.plb
prvtdpmt.plb
prvtdput.plb
prvtdputh.plb
prvtdrs.plb
prvtds.plb
prvtdst.plb
prvtdtde.plb
prvtdumi.plb
prvtedu.plb
prvtemx_admin.plb
prvtemx_cell.plb
prvtemx_dbhome.plb
prvtemx_memory.plb
prvtemx_perf.plb
prvtemx_rsrcmgr.plb
prvtemx_sql.plb
prvtemxi.plb
prvtenc.plb
prvtepg.plb
prvterlg.plb
prvtesch.plb
prvtfga.plb
prvtfgd.plb
prvtfi.plb
prvtfile.plb
prvtfs.plb
prvtfspi.plb
prvtfus.plb
prvtfuse.plb
prvtfwjava.plb Wrapped specification and body for dbms_ischedfw.
prvtgdk.plb
prvtgen.plb
prvtgwm.sql
prvtgwmalt.plb
prvtgwmcl.plb
prvtgwmco.plb
prvtgwmdb.plb
prvtgwmfix.plb
prvtgwmfx.plb
prvtgwmpl.plb
prvtgwmut.plb
prvthadoop.plb
prvthadoop1.plb
prvthapp.plb
prvthcap.plb
prvthcmp.plb
prvthcrc.plb
prvthdbu.plb
prvthddl.plb
prvthdfd.plb
prvthdm.plb
prvthdpi.plb
prvthesh.plb
prvthfgr.plb
prvthfie.plb
prvthgg.plb
prvthggei.plb
prvthhdlr.plb
prvthidx.plb
prvthier.plb
prvthisagt.plb
prvthisutl.plb
prvthitr.plb
prvthjob.plb
prvthlcr.plb
prvthlin.plb
prvthlrt.plb
prvthlru.plb
prvthlut.plb
prvthm.plb
prvthmgr.plb
prvthpc.plb
prvthpci.plb
prvthpclxi.plb
prvthpd.plb
prvthpdi.plb
prvthpexei.plb
prvthpexpi.plb
prvthpf.plb
prvthpfi.plb
prvthpm.plb
prvthpp.plb
prvthpro.plb
prvthprp.plb
prvthpu.plb
prvthpui.plb
prvthpv.plb
prvthpvi.plb
prvthpw.plb
prvthrse.plb
prvths.plb
prvthsai.plb
prvthsch.plb
prvthscp.plb
prvthsdp.plb
prvthsha.plb
prvthsld.plb
prvthsmc.plb
prvthsmt.plb
prvthspa.plb
prvthsrp.plb
prvthssm.plb
prvthssq.plb
prvthstr.plb
prvthsts.plb
prvthsxp.plb
prvthsye.plb
prvthttp.plb
prvthtxn.plb
prvthxstr.plb
prvti18n.plb
prvtidxu.plb
prvtilm.plb
prvtinad.plb
prvtindx.plb
prvtinmem.plb
prvtinmemadmin.plb
prvtiotc.plb
prvtir.plb
prvtitrg.plb
prvtjdbb.plb
prvtjdbs.plb
prvtjdmp.plb
prvtjdwp.plb
prvtjob.plb
prvtjson.plb
prvtkcl.plb
prvtkjhn.plb
prvtkppb.plb
prvtkpps.plb
prvtkubsagt.plb
prvtkupc.plb
prvtkzrxh.plb
prvtkzrxu.plb
prvtkzxp.plb
prvtkzxs.plb
prvtldap.plb
prvtldh.plb
prvtlibc.plb
prvtlm.plb
prvtlmcb.plb
prvtlmcs.plb
prvtlmd.plb
prvtlmeb.plb
prvtlmes.plb
prvtlmrb.plb
prvtlmrs.plb
prvtlms2.plb
prvtlmsb.plb
prvtlmss.plb
prvtlob.plb
prvtlobu.plb
prvtlock.plb
prvtlog.plb
prvtlsby.plb
prvtlsib.plb
prvtlsis.plb
prvtlssb.plb
prvtlsss.plb
prvtmacp.plb
prvtmail.plb
prvtmap.plb
prvtmb.plb
prvtmemoptimize.plb
prvtmet2.plb
prvtmeta.plb
prvtmetb.plb
prvtmetd.plb
prvtmeti.plb
prvtmetu.plb
prvtmgdtypb.plb
prvtmgdub.plb
prvtmgduib.plb
prvtmgduis.plb
prvtmntr.plb
prvtmp.plb
prvtnacl.plb
prvtncdb.plb
prvtnla.plb
prvtnoqm.plb
prvtns.plb
prvtobtk.plb
prvtocm.sql
prvtoctk.plb
prvtodbo.plb
prvtodci.plb
prvtodm.plb
prvtol.plb
prvtolapmig.plb
prvtoli.plb
prvtols.plb
prvtolsdd.plb
prvtolsdip.plb
prvtolsgrnt.plb
prvtolsldap.plb
prvtolsopq.plb
prvtolsstnd.plb
prvtoptim.plb
prvtotpt.plb
prvtpart.plb
prvtpb.plb
prvtpbp.plb
prvtpbt.plb
prvtpckl.plb
prvtpclx.plb
prvtpclxi.plb
prvtpdb.plb
prvtperf.plb
prvtpexe.plb
prvtpexei.plb
prvtpexp.plb
prvtpgb.plb
prvtpipe.plb
prvtpitr.plb
prvtplsw.plb
prvtplts.plb
prvtpool.plb
prvtpp.plb
prvtpplb.plb
prvtpprof.plb
prvtpq.plb
prvtprin.plb
prvtprocess.plb
prvtpsp.plb
prvtpspi.plb
prvtpstdy.plb
prvtqopi.plb
prvtratmask.plb
prvtrawb.plb
prvtrc.plb
prvtrcmp.plb
prvtrctv.plb
prvtread.plb
prvtredacta.plb
prvtref.plb
prvtreie.plb
prvtrep.plb
prvtrepl.sql
prvtrepr.plb
prvtrept.plb
prvtres.plb
prvtreut.plb
prvtrlsa.plb
prvtrmad.plb
prvtrmge.plb
prvtrmie.plb
prvtrmin.plb
prvtrmns.plb
prvtrmpa.plb
prvtrmpe.plb
prvtrmpr.plb
prvtrms.plb
prvtrpr.plb
prvtrqtf.plb
prvtrsa.plb
prvtrsch.plb
prvtrsicd.plb
prvtrtaddm.plb
prvtrupg.plb
prvtrupgib.plb
prvtrupgis.plb
prvtrwee.plb
prvtrwid.plb
prvtsc.plb
prvtscnc.plb
prvtsess.plb
prvtsjty.plb
prvtslrt.plb
prvtslxp.plb
prvtsma.plb
prvtsmaa.plb
prvtsmb.plb
prvtsmbi.plb
prvtsmgu.plb
prvtsms.plb
prvtsmtp.plb
prvtsmv.plb
prvtsnap.plb
prvtsnps.plb
prvtsodacoll.plb
prvtsodadml.plb
prvtsodadom.plb
prvtsodapls.plb
prvtsodautil.plb
prvtspa.plb
prvtspad.plb
prvtspai.plb
prvtspcu.plb
prvtspd.plb
prvtspdi.plb
prvtspm.plb
prvtspmi.plb
prvtsqdi.plb
prvtsqds.plb
prvtsqis.plb
prvtsql.plb
prvtsqld.plb
prvtsqlf.plb
prvtsqli.plb
prvtsqll.plb
prvtsqlm.plb
prvtsqlpatch.plb
prvtsqls.plb
prvtsqlt.plb
prvtsqlu.plb
prvtsqtk.plb
prvtsrv.plb
prvtssb.plb
prvtssql.plb
prvtsss.plb
prvtstai.plb
prvtstas.plb
prvtstat.plb
prvtstatadv.plb
prvtstatadvi.plb
prvtstatagg.plb
prvtstataggs.plb
prvtstattyp.plb
prvtstts.plb
prvtsum.plb
prvtsupp.plb
prvtsyer.plb
prvtsys.plb
prvttcp.plb
prvttcv.plb
prvttf.plb
prvttlog.plb
prvttns.plb
prvttran.plb
prvttrns.plb
prvttrst.plb
prvttsdp.plb
prvttsdpe.plb
prvttsdpm.plb
prvttsmb.plb
prvttsms.plb
prvttxfm.plb
prvttxfs.plb
prvttxin.plb
prvttypu.plb
prvtuadv.plb
prvtumf.plb
prvtumfi.plb
prvturi.plb
prvturl.plb
prvtutil.plb
prvtutils.plb
prvtuttv.plb
prvtwlm.plb
prvtwrk.plb
prvtwrr.plb
prvtwrr_report.plb
prvtxa.plb
prvtxdb.plb
prvtxdb0.plb
prvtxdba.plb
prvtxdbdl.plb
prvtxdbp.plb
prvtxdbr.plb
prvtxdbrepos.plb
prvtxdbschmig.plb
prvtxdbz.plb
prvtxdr0.plb
prvtxdz0.plb
prvtxdz2.plb
prvtxev.plb
prvtxidx.plb
prvtxlsb.plb
prvtxmeth.plb
prvtxml.plb
prvtxmld.plb
prvtxmlp.plb
prvtxmlstreams.plb
prvtxmlt.plb
prvtxpln.plb
prvtxpsw.plb
prvtxrc.plb
prvtxreg.plb
prvtxres.plb
prvtxrmv.plb
prvtxsch.plb
prvtxsch0.plb
prvtxschlsb.plb
prvtxschnp.plb
prvtxschnpb.plb
prvtxsfsclient.plb
prvtxslp.plb
prvtxsrs.plb
prvtxtr.plb
prvtxudu.plb
prvtxutil.plb
prvtzexp.plb
prvtzhlp.plb
pubcach.sql
pubcook.sql
pubcust.sql
pubht.sql Hyper-text packages that provide utility functions for producing HTML documents from PL/SQL. See also privht.sql.
pubimg.sql
pubmat.sql
puboolk.sql
pubowa.sql
pubpat.sql
pubsec.sql
pubtext.sql
pubutil.sql
racdwgrd.sql
recover.bsq
reenable_indexes.sql
response.plb
rman.pl
rman.pm
rmaqhp.sql
rmaqjms.sql
rmxml.sql
rstrconn.sql Grant all pre 10g R2 privileges back to the connect role.
rtaddmrpt.sql
rtaddmrpti.sql
rxsviews.sql
sbaddins.sql
sbcpkg.sql
sbcreate.sql
sbctab.sql
sbcusr.sql
sbdelins.sql
sbdoc.txt
sbdrop.sql
sbdtab.sql
sbdusr.sql
sblisins.sql
sbpurge.sql
sbrepcon.sql
sbrepins.sql
sbreport.sql
sbrepsql.sql
sbrsqins.sql
sbup1101.sql
sbup112.sql
sbup11201.sql
sbup12102.sql
sbup12200.sql
scott.sql A script that is similar to utlsampl.sql
sdoupgrdses.sql
secconf.sql
setpdb.sql
showlibc.sql
spadvrpt.sql
spauto.sql
spawrio.sql
spawrrac.sql
spcpkg.sql
spcreate.sql
spctab.sql
spcusr.sql
spdoc.txt
spdrop.sql
spdtab.sql
spdusr.sql
sppurge.sql
sprepcon.sql
sprepins.sql
spreport.sql
sprepsql.sql
sprsqins.sql
sptrunc.sql
spuexp.par
spup10.sql
spup102.sql
spup1101.sql
spup112.sql
spup11201.sql
spup12102.sql
spup12200.sql
spup816.sql
spup817.sql
spup90.sql
spup92.sql
sql.bsq Executed during create database, creates tables that are needed for DB operation
sqlsessend.sql Contains a simple alter session set "_ORACLE_SCRIPT" = false;
sqlsessstart.sql Contains a simple alter session set "_ORACLE_SCRIPT" = true;. This script and sqlsessend.sql are possibly related to catcon.pl
sqltacrt.sql
sqltrpt.sql
standard.sql
stdbody.sql
stdspec.sql
sxpndoff.sql
tcellsim.sql
tracetab.sql creates the tables for the PL/SQL (execution?) tracer, see event 10938.
tsdpend.sql
tsdpviews.sql
undoaud.sql
undopwd.sql
upgrdpdb.sql
upgrdpdbcheck.sql
upobjxt.lst
upuserxt.lst
userlock.sql Creates package user_lock which provides a facility for user-named locks that can be used in a local or clustered environment to aid in sequencing application actions
util.pm
utl32k.sql prerequisite to set the init parameter max_string_size to extended.
utlbstat.sql start collecting performance tuning statistics (ended with utlestat.sql)
utlchain.sql Creates the table CHAINED_ROWS which is used to store the result of analyze table … list chained rows command.
utlchn1.sql Creates the table CHAINED_ROWS which is used to store the result of the ANALYZE command with the CHAINED ROWS option. It can handle both physical and logical rowids. Compare with utlchain.sql which creates the same table.
utlcoll.plb
utlcomp.sql
utlconst.sql provides functions to validate that CHECK constraints on date columns are year 2000 compliant.
utlcstk.sql utl_call_stack
utlcxml.sql utl_xml, the wrapper over CORE's C-based XML/XSL processor. (Does not provide an interface for CORE's C-based DOM, SAX and Namespace APIs).
utldcchk.sql
utldim.sql
utldirsymlink.sql Loops through all_directories and check if any of these directories contain symbolic links.
utldtchk.sql
utldtree.sql creates tables and views that show dependencies between objects.
utledtol.sql
utlenc.sql
utlestat.sql stops collecting performance tuning statistics (which was started with utlbstat.sql)
utlexcpt.sql Creates the exception table.
utlexpt1.sql creates the default table (EXCEPTIONS) for storing exceptions from enabling constraints. Can handle both physical and logical rowids. Compare with utlexcpt.sql.
utlfile.sql
utlgdk.sql
utlhttp.sql
utli18n.sql
utlident.sql
utlimcjson.sql
utlinad.sql
utlincmp.sql
utlip.sql used primarily for upgrade and downgrade operations
utlirp.sql used to change from 32-bit to 64-bit word size or vice versa.
utljavrm.sql
utllms.sql
utllmup.sql
utllockt.sql displays a lock wait-for graph, in tree structure format
utlmail.sql
utlmatch.sql
utlmmig.sql Mini MIGration for Bootstrap objects.
utlmmigdown.sql
utlmmigdown121.sql
utlmmigtbls.sql
utlnla.sql
utlpg.sql
utlpitl.sql
utlprp.sql
utlpwdmg.sql creates PL/SQL functions for default password complexity verification. Sets the default password profile parameters and enables password management features.
utlraw.sql
utlrcmp.sql
utlrdt.sql
utlref.plb
utlrefld.sql
utlrp.sql recompiles all existing PL/SQL modules that were previously in an INVALID state, such as packages, procedures, and types
utlrvw.sql
utlsampl.sql creates sample schemas (such as SCOTT) and demonstration tables such as EMP and DEPT.
utlsmtp.sql
utlspadv.sql
utlsrt.sql
utlstddw.sql
utlsxszd.sql
utlsyxsz.sql
utltcp.sql
utltkprf.sql creates the TKPROFER role to allow the TKPROF profiling utility to be run by non-DBA users
utltz_countstar.sql
utltz_countstats.sql
utltz_upg_apply.sql
utltz_upg_check.sql
utltzu92.sql
utltzuv2.sql
utlu122s.sql
utlupox.sql
utluptabdata.sql Upgrade customer data tables that depend on Oracle-Maintained types by executing alter table … upgrade including data statements. This script should be run after upgrading to a new release.
utlurl.sql
utlusts.sql
utlvalid.sql creates tables required for storing output of ANALYZE TABLE ...VALIDATE STRUCTURE of a partitioned table.
utlxaa.sql
utlxmv.sql creates a table named mv_capabilities_table that is required by the dbms_mview.explain_mview procedure.
utlxplan.sql creates the table PLAN_TABLE, which holds output from the EXPLAIN PLAN statement
utlxplp.sql script to display the plan table output including parallel execution processing
utlxpls.sql script to display the plan table output for serial processing
utlxrw.sql Creates output table (named rewrite_table) for the procedure explain_rewrite (package dbms_snapshot and its synonym dbms_mview). Compare created table with types sys.rewriteMessage and sys.rewriteArrayType).
varlib.lst
wkremov.sql
wpgdocb.sql
wpgdocs.sql
wpiutil.sql
wpiutl.sql Compare with diutil.sql
wwvdocb.sql
wwvdocs.sql
xaview.sql
xdbdwgrd.sql
xdbe111.sql
xdbe112.sql
xdbe121.sql
xdbe122.sql
xdbeall.sql
xdbed111.sql
xdbed112.sql
xdbed121.sql
xdbed122.sql
xdbeo111.sql
xdbeo112.sql
xdbeo121.sql
xdbeo122.sql
xdbes111.sql
xdbes112.sql
xdbes121.sql
xdbes122.sql
xdbinst.sql
xdbinstd.sql
xdbload.sql
xdbloadend.sql
xdbrelod.sql
xdbud.sql
xdbud111.sql
xdbud112.sql
xdbud121.sql
xdbud122.sql
xdbuend.sql
xdbuo.sql
xdbuo111.sql
xdbuo112.sql
xdbuo121.sql
xdbuo122.sql
xdbupgrd.sql
xdbupgrdses.sql
xdbus.sql
xdbus111.sql
xdbus112.sql
xdbus121.sql
xdbus122.sql
xdbustr.sql
xdbuuc.sql
xdbuuc2.sql
xdbuuc3.sql
xdbuuc4.sql
xdbuud.sql
xdbuud2.sql
xdbuud3.sql
xdbxtbix.sql
xmlja.sql
xmlu817.sql
xmlu901.sql
xrddwgrd.sql
xrde112.sql
xrde121.sql
xrde122.sql
xrdu112.sql
xrdu121.sql
xrdu122.sql
xrdud112.sql
xrdud121.sql
xrdud122.sql
xrdupgrd.sql
xsa102.sql
xsa111.sql
xsa112.sql
xsacl.sql
xsadmi.sql
xsdbmig.sql
xsdiag.sql
xsds.sql
xse102.sql
xse111.sql
xse112.sql
xsns.sql
xspatch.sql
xsprin.sql XS Principal adminstrative interface: package for ACL adminstration
xsrs.sql
xssc.sql
xssess.sql
xsu102.sql
xsu111.sql
xsu112.sql
xsutil.sql

Index