解读sql.bsq文件
在$ORACLE_HOME/rdbms/admin下基本都是.sql文件，.bsq文件并不多，但.bsq文件非常重要
bsq文件在创建数据库的时候被调用，执行了许多创建数据库基表和索引等的一些sql语句，bsq应该可以理解为basic sql。
sql.bsq 片段：
dbxxx:/oracle/app/db_1/rdbms/admin> more sql.bsq
rem
rem $Header: rdbms/admin/sql.bsq /main/606 2008/07/14 17:25:59 vliang Exp $ sql.bsq
rem MODIFIED
rem huagli 06/09/08 - add ddst.bsq
rem dvoss 01/03/07 - add dlmnr.bsq
rem rdecker 10/20/06 - create SYSAUX before running dplsql.bsq
rem jklein 08/01/05 - diag 11g - split-up into units
rem sdavidso 08/01/05 - add tranform_param type check info
rem MODIFIED后面是脚本更新记录
第一列rem注释
第二列应该是更改人
第三列更改时间
第四列是备注，基本都是更改了什么内容
rem and 'default$' not-supported (N/S))
rem skrishna 12/06/94 - create extent table of pre-defined types
rem varora 12/01/94 - change toid in adtcol$ to type number
rem anori 11/17/94 - ADT support tables and columns
rem
rem !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! IMPORTANT !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
rem Whenever new column is created to store internal, user or kernel column
rem number, be sure to update the structure adtDT in atb.c so that those
rem columns will be updated properly during drop column.
rem !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
rem
dcore.bsq
dsqlddl.bsq
dmanage.bsq
dplsql.bsq
dtxnspc.bsq
dfmap.bsq
denv.bsq
drac.bsq
dsec.bsq
doptim.bsq
dobj.bsq
djava.bsq
dpart.bsq
drep.bsq
daw.bsq
dsummgt.bsq
dtools.bsq
dexttab.bsq
ddm.bsq
dlmnr.bsq
ddst.bsqsql.bsq真正执行的是后面*.bsq文件，前面一大段都是注释
版本差异：
#9.2
misdb1:/ora/ynprd/ynprddb/9.2.0/rdbms/admin>ls -lrt *.bsq
-rw-r--r-- 1 oraprd dba 243796 Jun 23 2011 migrate.bsq
-rw-r--r-- 1 oraprd dba 334372 Jun 23 2011 sql.bsq
-rw-r--r-- 1 oraprd dba 1120158 Jun 23 2011 recover.bsq
#10.2
nbjkd01:/oracle/app/product/10.2.0/db_1/rdbms/admin>ls -lrt *.bsq
-rw-r--r-- 1 oracle dba 445415 Apr 04 2007 sql.bsq
-rw-r--r-- 1 oracle dba 1907073 May 10 2008 recover.bsq
#11.2
ebcend01:/oracle/app/oracle/product/11.2.0/db_1/rdbms/admin@db> ls -lrt *.bsq
-rw-r--r-- 1 oracle oinstall 728 Oct 31 2005 djava.bsq
-rw-r--r-- 1 oracle oinstall 4937 Oct 31 2005 dfmap.bsq
-rw-r--r-- 1 oracle oinstall 1364 Oct 31 2005 dexttab.bsq
-rw-r--r-- 1 oracle oinstall 2832 Oct 23 2006 ddm.bsq
-rw-r--r-- 1 oracle oinstall 5474 Oct 31 2006 dtxnspc.bsq
-rw-r--r-- 1 oracle oinstall 16679 Jan 08 2007 dplsql.bsq
-rw-r--r-- 1 oracle oinstall 25509 Jun 08 2007 dobj.bsq
-rw-r--r-- 1 oracle oinstall 53130 Jul 14 2008 sql.bsq
-rw-r--r-- 1 oracle oinstall 674 Jul 14 2008 ddst.bsq
-rw-r--r-- 1 oracle oinstall 19958 Jul 30 2008 dsummgt.bsq
-rw-r--r-- 1 oracle oinstall 17751 Mar 09 2009 dsqlddl.bsq
-rw-r--r-- 1 oracle oinstall 25905 Mar 19 2009 daw.bsq
-rw-r--r-- 1 oracle oinstall 17811 Oct 09 2009 drac.bsq
-rw-r--r-- 1 oracle oinstall 47093 Nov 12 2009 dpart.bsq
-rw-r--r-- 1 oracle oinstall 9632 Dec 08 2009 dmanage.bsq
-rw-r--r-- 1 oracle oinstall 17993 Feb 23 2010 denv.bsq
-rw-r--r-- 1 oracle oinstall 33697 Apr 26 2011 dlmnr.bsq
-rw-r--r-- 1 oracle oinstall 91782 Jun 10 2012 dcore.bsq
-rw-r--r-- 1 oracle oinstall 33083 Feb 07 2013 doptim.bsq
-rw-r--r-- 1 oracle oinstall 147490 Apr 02 2013 drep.bsq
-rw-r--r-- 1 oracle oinstall 145316 Jul 07 2013 dsec.bsq
-rw-rw-rw- 1 oracle oinstall 15734 Feb 15 2017 dtools.bsq
-rwxrwxrwx 1 oracle oinstall 2532797 Feb 26 2018 recover.bsq
#12.1
[oracle@dbnode01 admin]$ ls -lrt *.bsq
-rw-r--r-- 1 oracle oinstall 728 Oct 31 2005 djava.bsq
-rw-r--r-- 1 oracle oinstall 4937 Oct 31 2005 dfmap.bsq
-rw-r--r-- 1 oracle oinstall 1364 Oct 31 2005 dexttab.bsq
-rw-r--r-- 1 oracle oinstall 779 May 21 2011 ddst.bsq
-rw-r--r-- 1 oracle oinstall 3099 Jul 6 2011 ddm.bsq
-rw-r--r-- 1 oracle oinstall 5599 Jul 21 2011 dtxnspc.bsq
-rw-r--r-- 1 oracle oinstall 53415 Jan 11 2012 sql.bsq
-rw-r--r-- 1 oracle oinstall 3920 Mar 6 2012 dfba.bsq
-rw-r--r-- 1 oracle oinstall 11292 Mar 27 2012 dmanage.bsq
-rw-r--r-- 1 oracle oinstall 16902 Apr 13 2012 dplsql.bsq
-rw-r--r-- 1 oracle oinstall 5774 May 8 2012 dtlog.bsq
-rw-r--r-- 1 oracle oinstall 29266 Jun 30 2012 daw.bsq
-rw-r--r-- 1 oracle oinstall 20195 Aug 7 2012 drac.bsq
-rw-r--r-- 1 oracle oinstall 60376 Sep 7 2012 dsummgt.bsq
-rw-r--r-- 1 oracle oinstall 10610 Nov 15 2012 drupg.bsq
-rw-r--r-- 1 oracle oinstall 40774 May 8 2013 dlmnr.bsq
-rw-r--r-- 1 oracle oinstall 45499 Sep 23 2013 dpart.bsq
-rw-r--r-- 1 oracle oinstall 35548 Oct 7 2013 doptim.bsq
-rw-r--r-- 1 oracle oinstall 23096 Dec 2 2013 dsqlddl.bsq
-rw-r--r-- 1 oracle oinstall 26136 Jan 22 2014 dobj.bsq
-rw-r--r-- 1 oracle oinstall 152411 Feb 14 2014 drep.bsq
-rw-r--r-- 1 oracle oinstall 95974 Feb 28 2014 dsec.bsq
-rw-r--r-- 1 oracle oinstall 7529 Mar 5 2014 dpstdy.bsq
-rw-r--r-- 1 oracle oinstall 20390 May 14 2014 denv.bsq
-rw-r--r-- 1 oracle oinstall 131967 Jun 27 2014 dcore.bsq
-rw-r--r-- 1 oracle oinstall 3846932 Mar 28 00:48 recover.bsq
-rw-r--r-- 1 oracle oinstall 16320 Mar 28 00:51 dtools.bsq在11g前，bsq脚本的文本基本都在sql.bsq中，11g后就分开来调用，结构要清晰一点。还有一点是recover.bsq和dtools.bsq文件在打psu时都被touch过。一个是rman相关，一个是导入导出相关
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. |
| dhcs.bsq | HCS catalog tables |
| 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 |
| dmisc.bsq | Registry and transformations, lost write metadata |
| 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 |
（表格来源：https://www.morganslibrary.org/reference/bsq.html）
12．1新增bsq rem只有这些
rem amullick 01/05/12 - bug13549280: add dtlog.bsq
rem sslim 09/01/11 - add drupg.bsq
rem swerthei 03/15/11 - force new version on PT.RS branch
rem jinjche 03/10/11 - Add dpstdy.bsq
rem sankejai 04/11/11 - add dfba.bsq
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！