Oracle BSQ Files

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version to Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Source {ORACLE_HOME}/rdbms/admin/*.bsq
File Name Descriptions
daw.bsq Analytic Workspace catalog tables such as aw$, aw_prop$, olap_mappings$, olap_models$, and olap_primary_dimensions$
dcore.bsq Core catalog tables and SYSTEM tablespace SYSTEM rollback segment such as clu$, uet$, seg$, ts$, obj$, props$, and dual
ddm.bsq Data mining and model clause catalog tables such as model$, modeltab$, and modelset$
ddst.bsq Daylight savings time tables
denv.bsq Catalog objects related to profiles, jobs, resource management and the profile "DEFAULT"
dexttab.bsq Catalog objects related to external tables external_tab$ and external_location$ and their indexes
dfba.bsq Flashback Archive tables
dfmap.bsq Catalog objects such as map_file$, map_element$, map*, etc.
djava.bsq Creation of catalog objects related to java objects (java class, java source, java resource, java data and etc).
dlmnr.bsq Creation of catalog objects related to log miner such as logmnr_session_evolve$ and logmnr_evolve_seq$
dmanage.bsq Creation of tablespace SYSAUX and catalog objects such as sqllog$, sql$, sqltext$, sqlobj$, and object_usage
dobj.bsq Catalog objects such as dir$, type$, collection$, method$, operator$, indarraytype$, and related indexes
doptim.bsq Catalog objects related to the cost based optimizer such as histgrm$, hist_head$, tab_stats$, and ind_stats$
dpart.bsq Catalog objects related to partitioning of LOBs such as partobj$, partcol$, lobfrag$, etc.
dplsql.bsq Catalog objects related to PL/SQL such as procedure$, procedureinfo$, source$, error$, and diana_version$
dpstdby.bsq Catalog tabls supporting DataGuard Physical Standby
drac.bsq Catalog objects related to TSM (Transparent Service Migration) such as tsm_src$, service$, cluster_databases, & dir$alert_history
drep.bsq Catalog objects related to replications such as mlog$, slog$, snap$, snap_reftime$, cdc_system, and  streams$_capture_process
drupg.bsq Catalog tables supporting DBMS_ROLLING and rolling upgrades
dsec.bsq Creation of user sys, public, and default roles such as connect. Also objects related to privileges such as audit$, aud$, SYSTEM_PRIVILEGE_MAP, rls$, fga$, and inserting values into SYSTEM_PRIVILEGE_MAP, and granting ora$base to public
dsqlddl.bsq Catalog objects such as link$, recyclebin$, duc$, trigger$, context$ and related indexes
dsummgt.bsq Catalog objects related to OLAP such as sum$, sumagg$, sumdetail$, hier$, dim$, and their related indexes
dtlog.bsq Catalog tables and sequence supporting the CLI dictionary
dtools.bsq Creation of role exp_full_database, select_catalog_role, expimp_tts_ct$, metaview$, metascript$, and related indexes
dtxnspc.bsq Creation of default UNDO, temporary, permanent tablespace, pending_trans$, pending_sessions$, and inserts values into props$
recover.bsq Catalog objects related to RMAN, backup and recovery
sql.bsq Calls the other .bsq scripts to build the data dictionary catalog beginning with dcore and ending with dlmnr

Related Topics
Files of Interest

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved