| General Information |
| 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 |
| 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$ |
| 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
|
| 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 |
| 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
|
|
|
