Introduction
Comment fait Oracle pour créer une base de données quand j'exécute un CREATE DATABASE, que ce soit en ligne de commandes ou via DBCA? La réponse est que des centaines de scripts sont appelés et ce sont eux qui créent cette base avec son dictionnaire de données.

Ces scripts se trouvent dans $ORACLE_HOME/rdbms/admin et nous allons voir cela plus en détail.




Points d'attention
Aucun.



Base de tests
N'importe quelle base mais, dans mes tests, ma base est une 12.1.



Exemples
============================================================================================
Les fichiers du répertoire $ORACLE_HOME/rdbms/admin

============================================================================================
Les types de fichiers
Le répertoire magique contenant tous les scripts de création d'une base Oracle est donc $ORACLE_HOME/rdbms/admin.
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ pwd
          /opt/oracle/srv/12.1.0/rdbms/admin

Pour une base 12.1 il y a 1843 fichiers (et pas 1844). Les plus nombreux sont les .sql et .plb.         
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l | wc -l
          1844

Il y a treize types de fichiers différents dont voici la répartition.         
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *bsq | wc -l
          27
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *def | wc -l
          13
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *lst | wc -l
          6
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *ora | wc -l
          1
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *par | wc -l
          1
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *pl | wc -l
          2
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *plb | wc -l
          680
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *pm | wc -l
          2
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *sql | wc -l
          1102
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *txt | wc -l
          2
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *var | wc -l
          5
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *xml | wc -l
          1
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l *xsd | wc -l
          1
           
Total : 1843
Il en manque un? Non, il y a un piège : la première ligne du ls -l n'est pas un fichier :-)
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls -l
          total 54616
          -rw-r--r--. 1 ora1210 oinstall   35507 Oct 14  2009 a0902000.sql
          -rw-r--r--. 1 ora1210 oinstall   75707 Apr 21  2014 a1001000.sql
          -rw-r--r--. 1 ora1210 oinstall   52885 Nov 13  2012 a1002000.sql
          

Liste des fichiers par type         
Listons maintenant TOUS ces fichiers par leur type; oui, TOUS!!!!!
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *bsq
daw.bsq    ddm.bsq   denv.bsq     dfba.bsq   djava.bsq  dmanage.bsq  doptim.bsq  dplsql.bsq  drac.bsq  drupg.bsq  dsqlddl.bsq  dtlog.bsq   dtxnspc.bsq  sql.bsq    dcore.bsq  ddst.bsq  dexttab.bsq  dfmap.bsq  dlmnr.bsq  dobj.bsq  dpart.bsq   dpstdy.bsq  drep.bsq  dsec.bsq   dsummgt.bsq  dtools.bsq  recover.bsq
           
          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *sql
          a0902000.sql               catemxv.sql             catpexe.sql         catxdbck.sql                         dbmsdesc.sql     dbmsrepl.sql       dve121.sql                 odme101.sql           sbctab.sql        utlstddw.sql
          a1001000.sql               catepg.sql              catpexev.sql        catxdbdbca.sql                       dbmsdg.sql       dbmsrep.sql        dvpatch.sql                odme102.sql           sbcusr.sql        utlsxszd.sql
          a1002000.sql               catexf.sql              catpgrants.sql      catxdbdl.sql                         dbmsdiag.sql     dbmsres.sql        dvregrant.sql              odme111.sql           sbdelins.sql      utlsyxsz.sql
          a1101000.sql               catexp7.sql             catpitr.sql         catxdbdr.sql                         dbmsdmpa.sql     dbmsrgt.sql        dvrelod.sql                odme920.sql           sbdrop.sql        utltcp.sql
          a1102000.sql               catexp.sql              catplan.sql         catxdbdt.sql                         dbmsdm.sql       dbmsrint.sql       dvremov.sql                odmpatch.sql          sbdtab.sql        utltkprf.sql
          a1201000.sql               catfga.sql              catplug.sql         catxdbdv.sql                         dbmsdmxf.sql     dbmsrlsa.sql       dvu102.sql                 odmproc.sql           sbdusr.sql        utltzu92.sql
          addmrpti.sql               catfgr.sql              catpprvt.sql        catxdbeo.sql                         dbmsdnfs.sql     dbmsrmad.sql       dvu111.sql                 odmrelod.sql          sblisins.sql      utltzuv2.sql
          addmrpt.sql                catfusrg.sql            catprc.sql          catxdbh.sql                          dbmsdp.sql       dbmsrman.sql       dvu112.sql                 odmu101.sql           sbpurge.sql       utlu121i.sql
          addmtmig.sql               catgwmcat.sql           catprocses.sql      catxdbj.sql                          dbmsdrs.sql      dbmsrmansys.sql    dvu121.sql                 odmu102.sql           sbrepcon.sql      utlu121s.sql
          apex_to_common.sql         catgwm.sql              catproc.sql         catxdbpi.sql                         dbmsdst.sql      dbmsrmanvpc.sql    e1001000.sql               odmu111.sql           sbrepins.sql      utlucdir.sql
          ashrptinoop.sql            cathae.sql              catprofa.sql        catxdbpv.sql                         dbmsedu.sql      dbmsrmpr.sql       e1002000.sql               odmu112.sql           sbreport.sql      utluiobj.sql
          ashrpti.sql                caths.sql               catprofc.sql        catxdbr.sql                          dbmsepg.sql      dbmsrms.sql        e1101000.sql               odmu920.sql           sbrepsql.sql      utlupox.sql
          ashrptistd.sql             catiasc.sql             catprofp.sql        catxdbrs.sql                         dbmserlg.sql     dbmsrpr.sql        e1102000.sql               olappl.sql            sbrsqins.sql      utluppkg.sql
          ashrpt.sql                 catidxu.sql             catproftab.sql      catxdbs.sql                          dbmsfga.sql      dbmsrupg.sql       e1201000.sql               olsdbmig.sql          sbup1101.sql      utlurl.sql
          awrblmig.sql               catilmini.sql           catproft.sql        catxdbst.sql                         dbmsfgd.sql      dbmsrwid.sql       emremove.sql               olse101.sql           sbup11201.sql     utlusts.sql
          awrddinp.sql               catilm.sql              catprp.sql          catxdbtm.sql                         dbmsfgr.sql      dbmssch.sql        epgstat.sql                olse102.sql           sbup112.sql       utlvalid.sql
          awrddrpi.sql               catilmtab.sql           catpses.sql         catxdbvfexp.sql                      dbmsfi.sql       dbmsscnc.sql       execaq.sql                 olse111.sql           sbup12102.sql     utlxaa.sql
          awrddrpt.sql               catio.sql               catpspec.sql        catxdbvr.sql                         dbmsfspi.sql     dbmssess.sql       execbsln.sql               olse112.sql           secconf.sql       utlxmv.sql
          awrextr.sql                catjava.sql             catpspi.sql         catxdbv.sql                          dbmsfs.sql       dbmssjty.sql       execcr.sql                 olse121.sql           showlibc.sql      utlxplan.sql
          awrgdinp.sql               catjobq.sql             catpstdy.sql        catxdbz0.sql                         dbmsfuse.sql     dbmsslrt.sql       execemx.sql                olspatch.sql          spadvrpt.sql      utlxplp.sql
          awrgdrpi.sql               catjsonv.sql            catpstr.sql         catxdbz.sql                          dbmsfus.sql      dbmsslxp.sql       exechae.sql                olspredowngrade.sql   spauto.sql        utlxpls.sql
          awrgdrpt.sql               catjvm.sql              catpstrt.sql        catxev.sql                           dbmsgen.sql      dbmssml.sql        execocm.sql                olspreupgrade.sql     spawrio.sql       utlxrw.sql
          awrginp.sql                catkppls.sql            catptabs.sql        catxidx.sql                          dbmsgwmalt.sql   dbmssnap.sql       execqopi.sql               olsrelod.sql          spawrrac.sql      wkremov.sql
          awrgrpti.sql               catlbacs.sql            catptyps.sql        catxlcr1.sql                         dbmsgwmcl.sql    dbmsspa.sql        execrep.sql                olsrle.sql            spcpkg.sql        wpgdocb.sql
          awrgrpt.sql                catldap.sql             catpvf.sql          catxlcr.sql                          dbmsgwmco.sql    dbmsspc.sql        execrm.sql                 olstrig.sql           spcreate.sql      wpgdocs.sql
          awrinfo.sql                catldr.sql              catqitab.sql        catxml.sql                           dbmsgwmdb.sql    dbmsspd.sql        execsch.sql                olsu101.sql           spctab.sql        wpiutil.sql
          awrinpnm.sql               catlibc.sql             catqm_int.sql       catxpend.sql                         dbmsgwmpl.sql    dbmsspm.sql        execsec.sql                olsu111.sql           spcusr.sql        wpiutl.sql
          awrinput.sql               catlmnr.sql             catqm.sql           catxs.sql                            dbmsgwm.sql      dbmsspu.sql        execsqlt.sql               olsu112.sql           spdrop.sql        wwvdocb.sql
          awrload.sql                catlsby.sql             catqos.sql          catxtbix.sql                         dbmsgwmut.sql    dbmssqll.sql       execstat.sql               olsu121.sql           spdtab.sql        wwvdocs.sql
          awrrpti.sql                catmaca.sql             catqueue.sql        catzxs.sql                           dbmshae.sql      dbmssqlm.sql       execstr.sql                olsup.sql             spdusr.sql        xaview.sql
          awrrpt.sql                 catmacc.sql             catratmask.sql      cdaw.sql                             dbmshias.sql     dbmssqlpatch.sql   execsvrm.sql               owachars.sql          sppurge.sql       xdb1m102.sql
          awrsqrpi.sql               catmacdd.sql            catredact.sql       cdclst.sql                           dbmshm.sql       dbmssql.sql        execsvr.sql                owacomm.sql           sprepcon.sql      xdbdbmig.sql
          awrsqrpt.sql               catmacd.sql             catrelod.sql        cdcore_mig.sql                       dbmshord.sql     dbmssqlt.sql       exectsdp.sql               owacsyn.sql           sprepins.sql      xdbe101.sql
          awrupd12.sql               catmacg.sql             catremvxutil.sql    cdcore.sql                           dbmshpro.sql     dbmssqlu.sql       exfcpu.sql                 owadins.sql           spreport.sql      xdbe102.sql
          bug18909599.sql            catmach.sql             catremxutil.sql     cddm.sql                             dbmshptab.sql    dbmssrv.sql        exfdbmig.sql               owadsyn.sql           sprepsql.sql      xdbe111.sql
          bug19532017_downgrade.sql  catmacpatch_int.sql     catrepc.sql         cddst.sql                            dbmshrep.sql     dbmsstat.sql       exfe101.sql                owadummy.sql          sprsqins.sql      xdbe112.sql
          bug19532017_upgrade.sql    catmacpatch_rb_int.sql  catreplt.sql        cdend.sql                            dbmshrmg.sql     dbmsstdx.sql       exfe102.sql                owainst.sql           sptrunc.sql       xdbe121.sql
          bug19587324.sql            catmacpatch_rb.sql      catrep.sql          cdenv.sql                            dbmshsld.sql     dbmsstr.sql        exfe111.sql                owaload.sql           spup102.sql       xdbe1m102.sql
          bug20596234.sql            catmacpatch.sql         catrept.sql         cdexttab.sql                         dbmshsna.sql     dbmssts.sql        exfe112.sql                owmdbmig.sql          spup10.sql        xdbeall.sql
          bug20876308_apply.sql      catmacpost.sql          catrepv.sql         cdfixed.sql                          dbmshssn.sql     dbmsstts.sql       exfpatch.sql               owme102.sql           spup1101.sql      xdbeo101.sql
          bug20876308_rollback.sql   catmacpre.sql           catrequired.sql     cdjava.sql                           dbmshs.sql       dbmssum.sql        exfpbs.sql                 owme111.sql           spup11201.sql     xdbeo102.sql
          bug22160989_apply.sql      catmacp.sql             catrequtlmg.sql     cdmanage.sql                         dbmshsxp.sql     dbmssupp.sql       exfrelod.sql               owme112.sql           spup112.sql       xdbeo111.sql
          bug22160989_rollback.sql   catmacr.sql             catresults.sql      cdobj.sql                            dbmsiast.sql     dbmssyer.sql       exfsys.sql                 owme121.sql           spup12102.sql     xdbeo112.sql
          bug22380919.sql            catmac.sql              catrls.sql          cdoptim.sql                          dbmsidxu.sql     dbmstcv.sql        exftab.sql                 owmpatch.sql          spup816.sql       xdbes101.sql
          bugfix16173764.sql         catmacs.sql             catrmno.sql         cdpart.sql                           dbmsilm.sql      dbmstran.sql       exftyp.sql                 owmrelod.sql          spup817.sql       xdbes102.sql
          c0902000.sql               catmact.sql             catrm.sql           cdplsql.sql                          dbmsindx.sql     dbmstrig.sql       exfu101.sql                owmremov.sql          spup90.sql        xdbes111.sql
          c1001000.sql               catmet2.sql             catrms.sql          cdrac.sql                            dbmsinmem.sql    dbmstrns.sql       exfu102.sql                pbload.sql            spup92.sql        xdbes112.sql
          c1002000.sql               catmeta.sql             catrpc.sql          cdrep.sql                            dbmsiotc.sql     dbmstrst.sql       exfu111.sql                pbunload.sql          sqlsessend.sql    xdbeu101.sql
          c1101000.sql               catmetgrant1.sql        catrse.sql          cdsec.sql                            dbmsir.sql       dbmstsdpe.sql      exfview.sql                perfhubrpt.sql        sqlsessstart.sql  xdbeu102.sql
          c1102000.sql               catmetgrant2.sql        catrssch.sql        cdsqlddl.sql                         dbmsjdcu.sql     dbmstsdpm.sql      f1001000.sql               pidian.sql            sqltacrt.sql      xdbeu111.sql
          c1201000.sql               catmetinsert.sql        catrule.sql         cdstrt.sql                           dbmsjdev.sql     dbmstsdp.sql       f1002000.sql               pipidl.sql            sqltrpt.sql       xdbeu112.sql
          catactx.sql                catmettypes.sql         catrul.sql          cdsummgt.sql                         dbmsjdmp.sql     dbmstutl.sql       f1101000.sql               pistub.sql            standard.sql      xdbinstd.sql
          catadmprvs.sql             catmetviews_mig.sql     catrupg.sql         cdtools.sql                          dbmsjdwp.sql     dbmstxfm.sql       f1102000.sql               plitblm.sql           stdbody.sql       xdbinst.sql
          catadrvw.sql               catmetviews.sql         catsadv.sql         cdtxnspc.sql                         dbmsjob.sql      dbmstxin.sql       f1201000.sql               plspur.sql            stdspec.sql       xdbpatch.sql
          catadt.sql                 catmetx2.sql            catsch.sql          cmpdbdwg.sql                         dbmskzxp.sql     dbmstypu.sql       fix_apply_20766944.sql     preupgrd.sql          tcellsim.sql      xdbptrl1.sql
          catadv.sql                 catmetx.sql             catschv.sql         cmpdwpth.sql                         dbmslcr.sql      dbmsuadv.sql       fix_rollback_20766944.sql  prgrmanc.sql          tracetab.sql      xdbptrl2.sql
          catadvtb.sql               catmgd.sql              catscqa.sql         cmpupend.sql                         dbmsldap.sql     dbmsupgin.sql      grntocmtabaccess.sql       privcach.sql          tsdpend.sql       xdbrelod.sql
          catalogses.sql             catmmig.sql             catshutdownpdb.sql  cmpupgrd.sql                         dbmslibc.sql     dbmsupgnv.sql      hangdiag.sql               privcook.sql          tsdpviews.sql     xdbrlu.sql
          catalog.sql                catmntr.sql             catshutdown.sql     cmpupjav.sql                         dbmslmd.sql      dbmsuri.sql        i0902000.sql               privcust.sql          undoaud.sql       xdbs101.sql
          catalrt.sql                catmwin.sql             catsmbvw.sql        cmpupmsc.sql                         dbmslm.sql       dbmsutil.sql       i1001000.sql               privht.sql            undopwd.sql       xdbs102.sql
          catamgt.sql                catnacl.sql             catsnap.sql         cmpupnjv.sql                         dbmslms.sql      dbmswlm.sql        i1002000.sql               privimg.sql           userlock.sql      xdbs111.sql
          catappcont.sql             catnaclv.sql            catsnmp.sql         cmpupnxb.sql                         dbmslob.sql      dbmswrr.sql        i1101000.sql               privmat.sql           utl32k.sql        xdbs112.sql
          catapp.sql                 catnoadt.sql            catspacd.sql        cmpupord.sql                         dbmslobu.sql     dbmsxa.sql         i1102000.sql               privoolk.sql          utlbstat.sql      xdbs9202.sql
          catapt.sql                 catnoalr.sql            catspace.sql        cmpupsdo.sql                         dbmslock.sql     dbmsxdba.sql       i1201000.sql               privowa.sql           utlchain.sql      xdbs920.sql
          cataqsch.sql               catnoap.sql             catspd.sql          cmpupstr.sql                         dbmslsby.sql     dbmsxdbc.sql       initcdc.sql                privpat.sql           utlchn1.sql       xdbu101.sql
          catar.sql                  catnoaud.sql            catsqlreg.sql       cmpupxdb.sql                         dbmsmap.sql      dbmsxdbrepos.sql   initdbj.sql                privsec.sql           utlcomp.sql       xdbu102.sql
          catatsk.sql                catnoawr.sql            catsqltk.sql        cmpupxdk.sql                         dbmsmet2.sql     dbmsxdbr.sql       initexf.sql                privtext.sql          utlconst.sql      xdbu111.sql
          cataudit.sql               catnocapi.sql           catsqlt.sql         dbfs_create_filesystem_advanced.sql  dbmsmeta.sql     dbmsxdbschmig.sql  initjms.sql                privutil.sql          utlcstk.sql       xdbu112.sql
          catawrpd.sql               catnodp.sql             catsqltv.sql        dbfs_create_filesystem.sql           dbmsmetb.sql     dbmsxdb.sql        initjvm2.sql               profload.sql          utlcxml.sql       xdbu9202.sql
          catawr.sql                 catnodpt.sql            catsscr.sql         dbfs_drop_filesystem.sql             dbmsmetd.sql     dbmsxdbt.sql       initjvm4.sql               proftab.sql           utldim.sql        xdbu920.sql
          catawrtb.sql               catnoexf.sql            catstrc.sql         dbfusrpi.sql                         dbmsmeti.sql     dbmsxdbz.sql       initjvm5.sql               prvtgwm.sql           utldtchk.sql      xdbuuc2.sql
          catawrtv.sql               catnofus.sql            catstrm.sql         dbfusrpt.sql                         dbmsmetu.sql     dbmsxev.sql        initjvma.sql               prvtocm.sql           utldtree.sql      xdbuuc3.sql
          catawrvw.sql               catnohs.sql             catstrr.sql         dbmsaddm.sql                         dbmsmntr.sql     dbmsxfr.sql        initmeta.sql               prvtrepl.sql          utledtol.sql      xdbuuc4.sql
          catbac.sql                 catnojav.sql            catstr.sql          dbmsadra.sql                         dbmsmp.sql       dbmsxidx.sql       initmgd.sql                pubcach.sql           utlenc.sql        xdbuuc.sql
          catblock.sql               catnomgd.sql            catstrt.sql         dbmsadro.sql                         dbmsnacl.sql     dbmsxlsb.sql       initqsma.sql               pubcook.sql           utlestat.sql      xdbuud2.sql
          catbslnd.sql               catnomta.sql            catsumaa.sql        dbmsadr.sql                          dbmsncdb.sql     dbmsxmld.sql       initscfw.sql               pubcust.sql           utlexcpt.sql      xdbuud3.sql
          catbsln.sql                catnomtr.sql            catsumat.sql        dbmsadv.sql                          dbmsobj.sql      dbmsxmlp.sql       initsjty.sql               pubht.sql             utlexpt1.sql      xdbuud.sql
          catbslnt.sql               catnomtt.sql            catsumno.sql        dbmsalrt.sql                         dbmsobtk.sql     dbmsxml.sql        initsoxx.sql               pubimg.sql            utlfile.sql       xdbvlo.sql
          catbslnv.sql               catnomwn.sql            catsum.sql          dbmsamgt.sql                         dbmsocm.sql      dbmsxmls.sql       initsqlj.sql               pubmat.sql            utlgdk.sql        xdbxtbix.sql
          catbslny.sql               catnools.sql            catsvrmg.sql        dbmsany.sql                          dbmsoctk.sql     dbmsxmlt.sql       initxa.sql                 puboolk.sql           utlhttp.sql       xmlja.sql
          catbundleapply.sql         catnoprc.sql            cattlog.sql         dbmsapin.sql                         dbmsodm.sql      dbmsxmlu.sql       initxml.sql                pubowa.sql            utli18n.sql       xmlu817.sql
          catbundlerollback.sql      catnoprt.sql            cattrans.sql        dbmsappcont.sql                      dbmsofln.sql     dbmsxpln.sql       initxqry.sql               pubpat.sql            utlident.sql      xmlu901.sql
          catbundle.sql              catnoqpi.sql            cattsdp.sql         dbmsapp.sql                          dbmsofsn.sql     dbmsxrc.sql        javdbmig.sql               pubsec.sql            utlinad.sql       xsa102.sql
          catcapi.sql                catnoratmask.sql        cattsmcr.sql        dbmsaqad.sql                         dbmsol.sql       dbmsxreg.sql       jave101.sql                pubtext.sql           utlincmp.sql      xsa111.sql
          catcapit.sql               catnorul.sql            cattsm.sql          dbmsasrt.sql                         dbmsotpt.sql     dbmsxres.sql       jave102.sql                pubutil.sql           utlip.sql         xsa112.sql
          catcap.sql                 catnosch.sql            catts.sql           dbmsatsk.sql                         dbmspart.sql     dbmsxschlsb.sql    jave111.sql                rdbmsup.sql           utlirp.sql        xsacl.sql
          catcdb_int.sql             catnosvm.sql            catupcox.sql        dbmsautorep.sql                      dbmspbp.sql      dbmsxsch.sql       jave112.sql                reenable_indexes.sql  utljavrm.sql      xsadmi.sql
          catcdb.sql                 catnowrrc.sql           catupend.sql        dbmsawex.sql                         dbmspb.sql       dbmsxslp.sql       jave920.sql                rmaqhp.sql            utllms.sql        xsdbmig.sql
          catcdbviews.sql            catnowrrp.sql           catupgrd.sql        dbmsawr.sql                          dbmspbt.sql      dbmsxstr.sql       mgdmeta.sql                rmaqjms.sql           utllmup.sql       xsdiag.sql
          catcdc.sql                 catnowrr.sql            catuposb.sql        dbmsaw.sql                           dbmspclx.sql     dbmsxsu.sql        mgdpatch.sql               rmcdc.sql             utllockt.sql      xsds.sql
          catchnf.sql                catnowrrwitb.sql        catupprc.sql        dbmsawst.sql                         dbmspdb.sql      dbmsxtr.sql        mgdpbs.sql                 rmxml.sql             utlmail.sql       xse102.sql
          catcio.sql                 catnozxs.sql            catuppst.sql        dbmsbkrs.sql                         dbmsperf.sql     dbmsxuducu.sql     mgdrelod.sql               rstrconn.sql          utlmatch.sql      xse111.sql
          catclust.sql               catnsnmp.sql            catupses.sql        dbmsbsln.sql                         dbmspexe.sql     dbmsxutil.sql      mgdsys.sql                 rtaddmrpti.sql        utlmmigdown.sql   xse112.sql
          catcmprm.sql               catobtk.sql             catupshd.sql        dbmscapi.sql                         dbmspexp.sql     dbmsxvr.sql        mgdtab.sql                 rtaddmrpt.sql         utlmmig.sql       xsns.sql
          catcmp.sql                 catocm.sql              catupstr.sql        dbmscap.sql                          dbmspipe.sql     depsaq.sql         mgdtrg.sql                 rulcpu.sql            utlmmigtbls.sql   xspatch.sql
          catcont.sql                catoctk.sql             catvxutil.sql       dbmscbl.sql                          dbmspitr.sql     depscapi.sql       mgdtyp.sql                 ruldbmig.sql          utlnla.sql        xsprin.sql
          catcrc.sql                 catodci.sql             catwrr.sql          dbmscdcp.sql                         dbmsplsw.sql     depspspi.sql       mgdus.sql                  rule102.sql           utlpg.sql         xsrs.sql
          catcredv.sql               catodm.sql              catwrrtbc.sql       dbmscdcs.sql                         dbmsplts.sql     depssvrm.sql       mgdview.sql                rule111.sql           utlpitl.sql       xssc.sql
          catcrsc.sql                catolsdd.sql            catwrrtbp.sql       dbmscdcu.sql                         dbmspool.sql     deptxn.sql         nacla112.sql               rule112.sql           utlprp.sql        xssess.sql
          catcr.sql                  catolsddv.sql           catwrrtb.sql        dbmschnf.sql                         dbmspp.sql       diutil.sql         nacle102.sql               rulpatch.sql          utlpwdmg.sql      xsu102.sql
          catdbfus.sql               catolsd.sql             catwrrtv.sql        dbmscmp.sql                          dbmsprp.sql      dmeidmsys.sql      nacle111.sql               rulpbs.sql            utlraw.sql        xsu111.sql
          catdbsyn.sql               catol.sql               catwrrvwc.sql       dbmscoll.sql                         dbmspspi.sql     dmproc.sql         nacle112.sql               rulrelod.sql          utlrcmp.sql       xsu112.sql
          catdefer.sql               catolsrecomp.sql        catwrrvwp.sql       dbmscomp.sql                         dbmspsp.sql      dmsysrem.sql       noncdb_to_pdb.sql          rultab.sql            utlrdt.sql        xsutil.sql
          catdefrt.sql               catols.sql              catwrrvw.sql        dbmscred.sql                         dbmspump.sql     dpload.sql         nothing.sql                rultyp.sql            utlrefld.sql
          catdef.sql                 catost.sql              catwrrwitb.sql      dbmscr.sql                           dbmsqopi.sql     dropjdev.sql       ocmdbb.sql                 rulu102.sql           utlrp.sql
          catdip.sql                 catparr.sql             catwrrwivw.sql      dbmscrs.sql                          dbmsrand.sql     drpadrvw.sql       ocmdbd.sql                 rulu111.sql           utlrvw.sql
          catdpb.sql                 catpcnfg.sql            catxdav2.sql        dbmscu.sql                           dbmsratmask.sql  dumpdian.sql       ocmjb10.sql                rulview.sql           utlsampl.sql
          catdph.sql                 catpdbms.sql            catxdav.sql         dbmsdbvn.sql                         dbmsrcad.sql     dvdbmig.sql        ocmjd10.sql                rxsviews.sql          utlscln.sql
          catdwgrd.sql               catpdeps.sql            catxdbapp.sql       dbmsdbv.sql                          dbmsrctf.sql     dve102.sql         ocmupgrd.sql               sbaddins.sql          utlsmtp.sql
          catemini.sql               catpend.sql             catxdbc1.sql        dbmsddl.sql                          dbmsread.sql     dve111.sql         odmcpu.sql                 sbcpkg.sql            utlspadv.sql
          catemxt.sql                catpexec.sql            catxdbc2.sql        dbmsdefr.sql                         dbmsredacta.sql  dve112.sql         odmdbmig.sql               sbcreate.sql          utlsrt.sql
          
           
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *plb
          dbmsaq8x.plb    owmmps.plb            prvssqlf.plb          prvtbcmp.plb    prvtbrnt.plb     prvtcxml.plb        prvtgwmdb.plb  prvthpd.plb     prvtinmem.plb    prvtmgduis.plb   prvtread.plb     prvtspmi.plb      prvtxdba.plb
          dbmsaqds.plb    owmprvb.plb           prvssqli.plb          prvtbcnf.plb    prvtbrpc.plb     prvtdadv.plb        prvtgwmpl.plb  prvthpexei.plb  prvtiotc.plb     prvtmntr.plb     prvtredacta.plb  prvtspm.plb       prvtxdbdl.plb
          dbmsaqem.plb    owmprvs.plb           prvtacl.plb           prvtbcut.plb    prvtbrrq.plb     prvtdbv.plb         prvtgwmut.plb  prvthpexpi.plb  prvtir.plb       prvtmp.plb       prvtref.plb      prvtsqdi.plb      prvtxdb.plb
          dbmsaq.plb      owmr1020.plb          prvtaddm.plb          prvtbdbu.plb    prvtbrse.plb     prvtddl.plb         prvthadd.plb   prvthpfi.plb    prvtitrg.plb     prvtnacl.plb     prvtreie.plb     prvtsqds.plb      prvtxdbp.plb
          dbmsrmge.plb    owmr1116.plb          prvtadmi.plb          prvtbdcl.plb    prvtbrut.plb     prvtdefr.plb        prvthapp.plb   prvthpf.plb     prvtjdbb.plb     prvtncdb.plb     prvtrep.plb      prvtsqis.plb      prvtxdbrepos.plb
          dbmsrmin.plb    owmr1120.plb          prvtadra.plb          prvtbdmn.plb    prvtbsai.plb     prvtdesc.plb        prvtharp.plb   prvthpm.plb     prvtjdbs.plb     prvtnla.plb      prvtrepr.plb     prvtsqld.plb      prvtxdbr.plb
          dbmsrmpa.plb    owmr1210.plb          prvtadri.plb          prvtbfgr.plb    prvtbsat.plb     prvtdfrd.plb        prvthath.plb   prvthpp.plb     prvtjdmp.plb     prvtnoqm.plb     prvtrept.plb     prvtsqlf.plb      prvtxdbschmig.plb
          dbmsrmpe.plb    owmreplb.plb          prvtadr.plb           prvtbfie.plb    prvtbsch.plb     prvtdfri.plb        prvthcap.plb   prvthpro.plb    prvtjdwp.plb     prvtns.plb       prvtres.plb      prvtsqli.plb      prvtxdbz.plb
          dbmsrsicd.plb   owmrepls.plb          prvtadv.plb           prvtbfla.plb    prvtbscp.plb     prvtdg.plb          prvthcdc.plb   prvthprp.plb    prvtjob.plb      prvtobtk.plb     prvtreut.plb     prvtsqll.plb      prvtxdr0.plb
          dbmsrspreq.plb  owmricb.plb           prvtalrt.plb          prvtbfma.plb    prvtbsdp.plb     prvtdiag.plb        prvthcmp.plb   prvthpui.plb    prvtkcl.plb      prvtoctk.plb     prvtrlsa.plb     prvtsqlm.plb      prvtxdz0.plb
          dbmssqds.plb    owmrics.plb           prvtamgt.plb          prvtbfut.plb    prvtbsha.plb     prvtdmar.plb        prvthcnf.plb   prvthpu.plb     prvtkjhn.plb     prvtodci.plb     prvtrmad.plb     prvtsqlpatch.plb  prvtxdz2.plb
          dvmacfnc.plb    owmuany.plb           prvtany.plb           prvtbhdlr.plb   prvtbsln.plb     prvtdmmi.plb        prvthcrc.plb   prvthpvi.plb    prvtkppb.plb     prvtodm.plb      prvtrmge.plb     prvtsql.plb       prvtxev.plb
          exfeapvs.plb    owmuinst.plb          prvtapin.plb          prvtbiai.plb    prvtbsmc.plb     prvtdmoc.plb        prvthcut.plb   prvthpv.plb     prvtkpps.plb     prvtofln.plb     prvtrmie.plb     prvtsqlt.plb      prvtxidx.plb
          exfimpvs.plb    owmupgrd.plb          prvtappcont.plb       prvtbias.plb    prvtbsmt.plb     prvtdmpa.plb        prvthdbu.plb   prvthpw.plb     prvtkubsagt.plb  prvtofsn.plb     prvtrmin.plb     prvtsqlu.plb      prvtxlsb.plb
          exfsppvs.plb    owmutlb.plb           prvtaq8x.plb          prvtbiat.plb    prvtbsna.plb     prvtdm.plb          prvthdcl.plb   prvthrgt.plb    prvtkupc.plb     prvtolapmig.plb  prvtrmns.plb     prvtsqtk.plb      prvtxmeth.plb
          exfxppvs.plb    owmutls.plb           prvtaqad.plb          prvtbiau.plb    prvtbspa.plb     prvtdmsu.plb        prvthddl.plb   prvthrpc.plb    prvtkzrxh.plb    prvtol.plb       prvtrmpa.plb     prvtsrv.plb       prvtxmld.plb
          olaptf.plb      owmutrgb.plb          prvtaqal.plb          prvtbint.plb    prvtbsqu.plb     prvtdmtf.plb        prvthdfd.plb   prvthrrq.plb    prvtkzrxu.plb    prvtolsdd.plb    prvtrmpe.plb     prvtssb.plb       prvtxml.plb
          owmadmb.plb     owmutrgs.plb          prvtaqdi.plb          prvtbipk.plb    prvtbsrp.plb     prvtdmxf.plb        prvthdfi.plb   prvthrse.plb    prvtkzxp.plb     prvtolsdip.plb   prvtrmpr.plb     prvtssql.plb      prvtxmlp.plb
          owmadms.plb     owmvpkgb.plb          prvtaqds.plb          prvtbirp.plb    prvtbssm.plb     prvtdnfs.plb        prvthdfr.plb   prvthrut.plb    prvtkzxs.plb     prvtolsgrnt.plb  prvtrms.plb      prvtsss.plb       prvtxmlstreams.plb
          owmaqb.plb      owmvpkgs.plb          prvtaqem.plb          prvtbkrs.plb    prvtbstr.plb     prvtdpcr.plb        prvthdmn.plb   prvthsai.plb    prvtldap.plb     prvtolsldap.plb  prvtrpch.plb     prvtstai.plb      prvtxmlt.plb
          owmaqs.plb      owmvtb.plb            prvtaqim.plb          prvtblcr.plb    prvtbsts.plb     prvtdp.plb          prvthdm.plb    prvthsch.plb    prvtldh.plb      prvtolsopq.plb   prvtrpr.plb      prvtstas.plb      prvtxpln.plb
          owmasrtb.plb    owmvts.plb            prvtaqin.plb          prvtblib.plb    prvtbsut.plb     prvtdputh.plb       prvthesh.plb   prvthscp.plb    prvtlibc.plb     prvtolsstnd.plb  prvtrsch.plb     prvtstat.plb      prvtxpsw.plb
          owmasrts.plb    owmwdmlb.plb          prvtaqip.plb          prvtblid.plb    prvtbtop.plb     prvtdput.plb        prvthfgr.plb   prvthsdp.plb    prvtlmcb.plb     prvtotpt.plb     prvtrsicd.plb    prvtstts.plb      prvtxrc.plb
          owmblklb.plb    owmwdmls.plb          prvtaqis.plb          prvtblin.plb    prvtbunt.plb     prvtdrep.plb        prvthfie.plb   prvthsha.plb    prvtlmcs.plb     prvtpart.plb     prvtrtaddm.plb   prvtsum.plb       prvtxreg.plb
          owmblkls.plb    owmwmsys.plb          prvtaqiu.plb          prvtblru.plb    prvtbut2.plb     prvtdrs.plb         prvthfla.plb   prvthsld.plb    prvtlmd.plb      prvtpb.plb       prvtrupgib.plb   prvtsupp.plb      prvtxres.plb
          owmcddlb.plb    prvsadri.plb          prvtaqji.plb          prvtblut.plb    prvtbut3.plb     prvtds.plb          prvthfma.plb   prvthsmc.plb    prvtlmeb.plb     prvtpbp.plb      prvtrupgis.plb   prvtsyer.plb      prvtxrmv.plb
          owmcddls.plb    prvsadv.plb           prvtaqjm.plb          prvtbmas.plb    prvtbut4.plb     prvtdst.plb         prvthfut.plb   prvthsmt.plb    prvtlmes.plb     prvtpbt.plb      prvtrupg.plb     prvtsys.plb       prvtxschlsb.plb
          owmcmdv.plb     prvsash.plb           prvtaqme.plb          prvtbmig.plb    prvtbutl.plb     prvtdtde.plb        prvthgen.plb   prvthspa.plb    prvtlm.plb       prvtpckl.plb     prvtrwee.plb     prvttcp.plb       prvtxschnpb.plb
          owmcpkgb.plb    prvsautorepi.plb      prvtaqmi.plb          prvtbobg.plb    prvtbval.plb     prvtdumi.plb        prvthhdlr.plb  prvths.plb      prvtlmrb.plb     prvtpclx.plb     prvtrwid.plb     prvttcv.plb       prvtxschnp.plb
          owmcpkgs.plb    prvs_awr_data_cp.plb  prvtaq.plb            prvtboft.plb    prvtbxfr.plb     prvtedu.plb         prvthiai.plb   prvthsqu.plb    prvtlmrs.plb     prvtpdb.plb      prvtsath.plb     prvttlog.plb      prvtxsch.plb
          owmctrg.plb     prvs_awr_data.plb     prvtaqxe.plb          prvtbog2.plb    prvtbxstr.plb    prvtemx_admin.plb   prvthiau.plb   prvthsrp.plb    prvtlms2.plb     prvtperf.plb     prvtscnc.plb     prvttran.plb      prvtxsfsclient.plb
          owmctxb.plb     prvsawri.plb          prvtaqxi.plb          prvtbog3.plb    prvtcapi.plb     prvtemx_cell.plb    prvthidx.plb   prvthssm.plb    prvtlms.plb      prvtpexei.plb    prvtsc.plb       prvttrns.plb      prvtxslp.plb
          owmctxs.plb     prvsawr.plb           prvtarpp.plb          prvtbord.plb    prvtcbl.plb      prvtemx_dbhome.plb  prvthint.plb   prvthssq.plb    prvtlob.plb      prvtpexe.plb     prvtscrp.plb     prvttrst.plb      prvtxsrs.plb
          owmcvws.plb     prvsawrs.plb          prvtash.plb           prvtbout.plb    prvtcdcp.plb     prvtemxi.plb        prvthipk.plb   prvthstr.plb    prvtlobu.plb     prvtpexp.plb     prvtsess.plb     prvttsdpe.plb     prvtxtr.plb
          owmddlb.plb     prvsawrv.plb          prvtasrt.plb          prvtbowp.plb    prvtcdcs.plb     prvtemx_memory.plb  prvthirp.plb   prvthsts.plb    prvtlock.plb     prvtpgb.plb      prvtsjty.plb     prvttsdpm.plb     prvtxudu.plb
          owmddls.plb     prvscpaddm.plb        prvtatsk.plb          prvtbpci.plb    prvtcdcu.plb     prvtemx_perf.plb    prvthitr.plb   prvthsut.plb    prvtlog.plb      prvtpipe.plb     prvtslrt.plb     prvttsdp.plb      prvtxutil.plb
          owmdtrgb.plb    prvsemx_admin.plb     prvtatxp.plb          prvtbpc.plb     prvtcdpe.plb     prvtenc.plb         prvthjob.plb   prvthsxp.plb    prvtlsby.plb     prvtpitr.plb     prvtslxp.plb     prvttsmb.plb      prvtzexp.plb
          owmdtrgs.plb    prvsemx_cell.plb      prvtautorepi.plb      prvtbpdi.plb    prvtcdpi.plb     prvtepg.plb         prvthlcr.plb   prvthsye.plb    prvtlsib.plb     prvtplsw.plb     prvtsmaa.plb     prvttsms.plb      prvtzhlp.plb
          owmdutlb.plb    prvsemx_dbhome.plb    prvtautorep.plb       prvtbpd.plb     prvtcdpu.plb     prvterlg.plb        prvthlin.plb   prvthtop.plb    prvtlsis.plb     prvtplts.plb     prvtsma.plb      prvttxfm.plb      response.plb
          owmdutls.plb    prvsemxi.plb          prvtawex.plb          prvtbpexpi.plb  prvtchnf.plb     prvtesch.plb        prvthlrt.plb   prvthttp.plb    prvtlssb.plb     prvtpool.plb     prvtsmbi.plb     prvttxfs.plb      ruleipvs.plb
          owmerrb.plb     prvsemx_memory.plb    prvtaw.plb            prvtbpfi.plb    prvtclkm.plb     prvtfga.plb         prvthlru.plb   prvthtxn.plb    prvtlsss.plb     prvtpp.plb       prvtsmb.plb      prvttxin.plb      rulimpvs.plb
          owmerrs.plb     prvsemx_perf.plb      prvt_awr_data_cp.plb  prvtbpf.plb     prvtcmpl.plb     prvtfgd.plb         prvthlut.plb   prvthunt.plb    prvtmacp.plb     prvtpprof.plb    prvtsmgu.plb     prvttypu.plb      rulpkpvs.plb
          owmexpb.plb     prvsfus.plb           prvt_awr_data.plb     prvtbpm.plb     prvtcmp.plb      prvtfile.plb        prvthmas.plb   prvthut2.plb    prvtmail.plb     prvtprin.plb     prvtsms.plb      prvtuadv.plb      utlcoll.plb
          owmexps.plb     prvshdm.plb           prvtawri.plb          prvtbpp.plb     prvtcmpr.plb     prvtfi.plb          prvthmig.plb   prvthut3.plb    prvtmap.plb      prvtpspi.plb     prvtsmtp.plb     prvturi.plb       utlref.plb
          owmgrnt.plb     prvsrepr.plb          prvtawr.plb           prvtbprp.plb    prvtcoll.plb     prvtfspi.plb        prvthm.plb     prvthut4.plb    prvtmet2.plb     prvtpsp.plb      prvtsmv.plb      prvturl.plb
          owmiexpb.plb    prvsrept.plb          prvtawrs.plb          prvtbpui.plb    prvtcomp.plb     prvtfs.plb          prvthobg.plb   prvthutl.plb    prvtmeta.plb     prvtpstdy.plb    prvtsnap.plb     prvtutil.plb
          owmiexps.plb    prvsrtaddm.plb        prvtawrv.plb          prvtbpu.plb     prvtconsacl.plb  prvtfuse.plb        prvthofl.plb   prvthval.plb    prvtmetb.plb     prvtqopi.plb     prvtsnps.plb     prvtutils.plb
          owminst.plb     prvssmbi.plb          prvtawst.plb          prvtbpvi.plb    prvtcpaddm.plb   prvtfus.plb         prvthoft.plb   prvthxstr.plb   prvtmetd.plb     prvtratmask.plb  prvtspad.plb     prvtuttv.plb
          owmltb.plb      prvssmb.plb           prvtbadd.plb          prvtbpv.plb     prvtcrc.plb      prvtgdk.plb         prvthout.plb   prvti18n.plb    prvtmeti.plb     prvtrawb.plb     prvtspai.plb     prvtwlm.plb
          owmlts.plb      prvssmgu.plb          prvtbapp.plb          prvtbpw.plb     prvtcred.plb     prvtgen.plb         prvthowp.plb   prvtidxu.plb    prvtmetu.plb     prvtrcmp.plb     prvtspa.plb      prvtwrk.plb
          owmmigb.plb     prvsspai.plb          prvtbath.plb          prvtbrep.plb    prvtcr.plb       prvtgwmalt.plb      prvthpci.plb   prvtilm.plb     prvtmgdtypb.plb  prvtrc.plb       prvtspcu.plb     prvtwrr.plb
          owmmigs.plb     prvsspdi.plb          prvtbcap.plb          prvtbrgt.plb    prvtcrs.plb      prvtgwmcl.plb       prvthpc.plb    prvtinad.plb    prvtmgdub.plb    prvtrctf.plb     prvtspdi.plb     prvtxa.plb
          owmmpb.plb      prvsspmi.plb          prvtbcdc.plb          prvtbrmg.plb    prvtcstk.plb     prvtgwmco.plb       prvthpdi.plb   prvtindx.plb    prvtmgduib.plb   prvtrctv.plb     prvtspd.plb      prvtxdb0.plb
          
           
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *txt
          sbdoc.txt  spdoc.txt
           
           
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *lst
          agtept.lst  clntshcore_shrept.lst  shrept.lst  upobjxt.lst  upuserxt.lst  varlib.lst
           
           
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *xml
          bundledata_PSU.xml
           
           
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *pl
          catcon.pl  catctl.pl
           
           
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *pm
          catcon.pm  catconst.pm
           
           
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *ora
          externaljob.ora
           
           
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *var
          kspapv0.var  kspapv1.var  kspasv0.var  kspasv1.var  kspasv60.var
           
           
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *def
          libasmclntsh12.def  libasmperl12.def  libnfsodm12.def  libodm12.def  liboramysql12.def  libpatchgensh12.def  libqsmashr.def  libshpkavx12.def  libshpkavx212.def  libshpksse4212.def  libskgxn2.def  libskgxp12.def  libxdb.def
           
           
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *xsd
          oraaccess.xsd
           
           
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ ls *par
          spuexp.par
           
           
============================================================================================
Exemple de chaque type de fichiers - partie 1

============================================================================================          
Nous allons maintenant regarder un fichier de chaque type pour se faire une idée, même grossière, de leur rôle et démystifier un peu ce répertoire.
Suivant leur importance et leur taille, je copie soit l'intégralité du contenu soit juste un extract.

Fichiers .bsq
Parmi tous ces fichiers, le plus important est sql.bsq qui est le point de départ du CREATE DATABASE; c'est lui qui appelle tous les autres scripts qui vont créer le dictionnaire de données. Une liste des fichiers ici avec leur rôle : https://www.morganslibrary.org/reference/bsq.html.

Celui-ci appelle une vingtaine d'autres fichiers bsq.
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more sql.bsq
           
          rem Copyright (c) 1990, 2012, Oracle and/or its affiliates.
          rem All rights reserved.
          rem
          rem  MODIFIED
          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
          ...
          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.bsq
          dfba.bsq
          dpstdy.bsq
          drupg.bsq
          dtlog.bsq
          
Regardons le contenu d'un autre de ces fichiers bsq, le dcore.bsq. Celui-ci est très important car il contient la création de plusieurs tables du dictionnaire de données comme tab$. Et, si vous regardez bien, que voyez-vous? DES COMMENTAIRES pour les colonnes de tab$!!!!! alors que c'est introuvable sur le site officiel d'Oracle. Et on a même des infos sur la valeur de plusieurs colonnes :-)
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more dcore.bsq
          create table tab$                                             /* table table */
          ( obj#          number not null,                            /* object number */
            /* DO NOT CREATE INDEX ON DATAOBJ#  AS IT WILL BE UPDATED IN A SPACE
             * TRANSACTION DURING TRUNCATE */
            dataobj#      number,                          /* data layer object number */
            ts#           number not null,                        /* tablespace number */
            file#         number not null,               /* segment header file number */
            block#        number not null,              /* segment header block number */
            bobj#         number,                /* base object number (cluster / iot) */
            tab#          number,    /* table number in cluster, NULL if not clustered */
            cols          number not null,                        /* number of columns */
            clucols       number,/* number of clustered columns, NULL if not clustered */
            pctfree$      number not null, /* minimum free space percentage in a block */
            pctused$      number not null, /* minimum used space percentage in a block */
            initrans      number not null,            /* initial number of transaction */
            maxtrans      number not null,            /* maximum number of transaction */
            flags         number not null, /* 0x00     = unmodified since last backup
                                              0x01     = modified since then
                                              0x02     = DML locks restricted to <= SX
                                              0x04     = DML locks <= SX not acquired
                                              0x08     = CACHE
                                              0x10     = table has been analyzed
                                              0x20     = table has no logging
                                              0x40     = 7.3 -> 8.0 data object
                                                         migration required
                                              0x0080   = current summary dependency
                                              0x0100   = user-specified stats
                                              0x0200   = global stats
                                              0x0800   = table has security policy
                                              0x020000 = Move Partitioned Rows
                                             0x0400000 = table has sub tables
                                            0x00800000 = row dependencies enabled */
                          /* 0x10000000 = this IOT has a  physical rowid mapping table */
                          /* 0x20000000 = mapping table of an IOT(with physical rowid) */
            audit$        varchar2("S_OPFL") not null,             /* auditing options */
            rowcnt        number,                                    /* number of rows */
            blkcnt        number,                                  /* number of blocks */
            empcnt        number,                            /* number of empty blocks */
            avgspc        number,       /* average available free space/iot ovfl stats */
            chncnt        number,                            /* number of chained rows */
            avgrln        number,                                /* average row length */
            avgspc_flb    number,       /* avg avail free space of blocks on free list */
            flbcnt        number,                             /* free list block count */
            analyzetime   date,                        /* timestamp when last analyzed */
            samplesize    number,                 /* number of rows sampled by Analyze */
          /*
          * Legal values for degree, instances:
          *     NULL (used to represent 1 on disk/dictionary and implies noparallel), or
          *     2 thru EB2MAXVAL-1 (user supplied values), or
          *     EB2MAXVAL (implies use default value)
          */
            degree        number,      /* number of parallel query slaves per instance */
            instances     number,        /* number of OPS instances for parallel query */
          /* <intcols> => the number of dictionary columns => the number of columns
          * that have dictionary meta-data associated with them. This is a superset of
          * <usercols> and <kernelcols>.
          *    <intcols> = <kernelcols> + <number_of_virtual_columns>
          */
            intcols       number not null,               /* number of internal columns */
          /* <kernelcols> => the number of REAL columns (ie) columns that actually
          * store data.
          */
            kernelcols    number not null,          /* number of REAL (kernel) columns */
            property      number not null,            /* table properties (bit flags): */
                                        /* 0x01 = typed table, 0x02 = has ADT columns, */
                           /* 0x04 = has nested-TABLE columns, 0x08 = has REF columns, */
                                /* 0x10 = has array columns, 0x20 = partitioned table, */
                         /* 0x40 = index-only table (IOT), 0x80 = IOT w/ row OVerflow, */
                       /* 0x100 = IOT w/ row CLustering, 0x200 = IOT OVeRflow segment, */
                         /* 0x400 = clustered table, 0x800 = has internal LOB columns, */
                  /* 0x1000 = has primary key-based OID$ column, 0x2000 = nested table */
                              /* 0x4000 = View is Read Only, 0x8000 = has FILE columns */
                 /* 0x10000 = obj view's OID is system-gen, 0x20000 = used as AQ table */
                                             /* 0x40000 = has user-defined lob columns */
                                         /* 0x00080000 = table contains unused columns */
                                      /* 0x100000 = has an on-commit materialized view */
                                       /* 0x200000 = has system-generated column names */
                                                /* 0x00400000 = global temporary table */
                                      /* 0x00800000 = session-specific temporary table */
                                                  /* 0x08000000 = table is a sub table */
                                                  /*   0x20000000 = pdml itl invariant */
                                                    /* 0x80000000 = table is external  */
                                    /* PFLAGS2: 0x400000000 = delayed segment creation */
            /* PFLAGS2: 0x20000000000 = result cache mode FORCE enabled on this table  */
            /* PFLAGS2: 0x40000000000 = result cache mode MANUAL enabled on this table */
            /* PFLAGS2: 0x80000000000 = result cache mode AUTO enabled on this table   */
            /* PFLAGS2: 0x400000000000000 = has identity column                        */
            trigflag      number,   /* first two bytes for trigger flags, the rest for */
                             /* general use, check tflags_kqldtvc in kqld.h for detail */
                                                      /* 0x00000001 deferred RPC Queue */
                                                            /* 0x00000002 snapshot log */
                                                  /* 0x00000004 updatable snapshot log */
                                                       /* 0x00000008 = context trigger */
                                              /* 0x00000010 = synchronous change table */
                                                       /* 0x00000020 = Streams trigger */
                                                  /* 0x00000040 = Content Size Trigger */
                                                   /* 0x00000080 = audit vault trigger */
                                     /* 0x00000100 = Streams Auxiliary Logging trigger */
                               /* 0x00010000 = server-held key encrypted columns exist */
                                 /* 0x00020000 = user-held key encrypted columns exist */
                                                    /* 0x00200000 = table is read only */
                                               /* 0x00400000 = lobs use shared segment */
                                                           /* 0x00800000 = queue table */
                                             /* 0x10000000 = streams unsupported table */
                                                      /* enabled at some point in past */
                                      /* 0x80000000 = Versioning enabled on this table */
            spare1        number,                       /* used to store hakan_kqldtvc */
            spare2        number,         /* committed partition # used by drop column */
            spare3        number,                           /* summary sequence number */
            spare4        varchar2(1000),         /* committed RID used by drop column */
            spare5        varchar2(1000),      /* summary related information on table */
            spare6        date                                  /* flashback timestamp */
          )
          cluster c_obj#(obj#)
          /
           
Pour être sur que c'est bien cette table qui est créée par Oracle, faisons un DESC dessus : bingo, les colonnes matchent!          
          SQL> desc tab$
          Name                                      Null?    Type
          ----------------------------------------- -------- ----------------------------
          OBJ#                                      NOT NULL NUMBER
          DATAOBJ#                                           NUMBER
          TS#                                       NOT NULL NUMBER
          FILE#                                     NOT NULL NUMBER
          BLOCK#                                    NOT NULL NUMBER
          BOBJ#                                              NUMBER
          TAB#                                               NUMBER
          COLS                                      NOT NULL NUMBER
          CLUCOLS                                            NUMBER
          PCTFREE$                                  NOT NULL NUMBER
          PCTUSED$                                  NOT NULL NUMBER
          INITRANS                                  NOT NULL NUMBER
          MAXTRANS                                  NOT NULL NUMBER
          FLAGS                                     NOT NULL NUMBER
          AUDIT$                                    NOT NULL VARCHAR2(38)
          ROWCNT                                             NUMBER
          BLKCNT                                             NUMBER
          EMPCNT                                             NUMBER
          AVGSPC                                             NUMBER
          CHNCNT                                             NUMBER
          AVGRLN                                             NUMBER
          AVGSPC_FLB                                         NUMBER
          FLBCNT                                             NUMBER
          ANALYZETIME                                        DATE
          SAMPLESIZE                                         NUMBER
          DEGREE                                             NUMBER
          INSTANCES                                          NUMBER
          INTCOLS                                   NOT NULL NUMBER
          KERNELCOLS                                NOT NULL NUMBER
          PROPERTY                                  NOT NULL NUMBER
          TRIGFLAG                                           NUMBER
          SPARE1                                             NUMBER
          SPARE2                                             NUMBER
          SPARE3                                             NUMBER
          SPARE4                                             VARCHAR2(1000)
          SPARE5                                             VARCHAR2(1000)
          SPARE6                                             DATE
           
          
Fichiers .sql
Attention, TOUS les fichiers .sql ne sont pas appelés lors de la création d'une base Oracle. Certains sont appelés à la demande, comme addmrpt.sql qui permet de générer un rapport ADDM.

Parmi les fichiers sql, deux sont très connus, catalog.sql qui sert à créer les vues sur le dictionnaire de données et catproc.sql qui crée les packages PL/SQL. catalog est un très très vieux fichier, son en-tête remonte à 1988, soit Oracle 6.          
Ne soyez pas déçu, lui aussi ne fait qu'appeler quantité d'autres scripts mais au moins on a l'ordre d'appel de ces scripts pour aller les lire.
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more catalog.sql
          Rem
          Rem $Header: rdbms/admin/catalog.sql /main/710 2013/10/16 16:03:46 talliu Exp $ catalog.sql
          Rem
          Rem Copyright (c) 1988, 2013, Oracle and/or its affiliates.
          Rem All rights reserved.
          Rem
          Rem NAME
          Rem   CATALOG.SQL
          Rem FUNCTION
          Rem   Creates data dictionary views.
          Rem NOTES
          Rem   Must be run when connected AS SYSDBA
          Rem
          Rem
          Rem BEGIN SQL_FILE_METADATA
          Rem SQL_SOURCE_FILE: rdbms/admin/catalog.sql
          Rem SQL_SHIPPED_FILE: rdbms/admin/catalog.sql
          Rem SQL_PHASE: CATALOG
          Rem SQL_STARTUP_MODE: NORMAL
          Rem SQL_IGNORABLE_ERRORS: NONE
          Rem SQL_CALLING_FILE: NONE
          Rem END SQL_FILE_METADATA
          Rem
          Rem MODIFIED
          Rem     talliu     10/02/13  - call catblock.sql
          Rem     talliu     07/08/13  - invoke catcdbviews before cdcore
           
          ...
           
          Rem   mmoore     06/03/91 - change user$ column names
          Rem   agupta     06/07/91 - syntax error in exp_objects view
          Rem   rkooi      10/22/91 - deleted lots of comments (co truncate bug)
          Rem   Grayson    03/21/88 - Creation
           
          @@?/rdbms/admin/sqlsessstart.sql
           
          Rem **********************************************************************
          Rem
          Rem  NOTE: SQL CODE NOT PERMITTED IN THIS FILE ONLY THE EXECUTION OF A
          Rem       .SQL or .PLB file.
          Rem
          Rem **********************************************************************
           
          --CATCTL -S    Initial scripts single process
          @@cdstrt.sql
          @@cdfixed.sql
          @@catcdbviews.sql
          @@catblock.sql
          @@cdcore.sql
           
          --CATCTL -R
          --CATCTL -M
          @@cdplsql.sql
          @@cdsqlddl.sql
          @@cdmanage.sql
          @@cdtxnspc.sql
          @@cdenv.sql
          @@cdrac.sql
          @@cdsec.sql
          @@cdobj.sql
          @@cdjava.sql
          @@cdpart.sql
          @@cdrep.sql
          @@cdaw.sql
          @@cdsummgt.sql
          @@cdtools.sql
          @@cdexttab.sql
          @@cddm.sql
          @@catldr.sql
          @@cdclst.sql
           
           
          --CATCTL -R
          --CATCTL -S     Final scripts single process
          @@cdoptim.sql
          @@catsum.sql
          @@catexp.sql
          @@cddst.sql
          @@cdend.sql
           
          @?/rdbms/admin/sqlsessend.sql
           
          Rem *********************************************************************
          Rem END catalog.sql
          Rem *********************************************************************

           
Passons maintenant à catproc.sql.Lui aussi exécute d'autres scripts sql et rien de plus.
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more catproc.sql
          rem
          rem $Header: rdbms/admin/catproc.sql /main/274 2013/06/09 14:57:50 jerrede Exp $
          rem
          Rem Copyright (c) 1991, 2013, Oracle and/or its affiliates.
          Rem All rights reserved.
          Rem    NAME
          Rem      catproc.sql
          Rem    DESCRIPTION
          Rem      Run all sql scripts for the procedural option
          Rem    RETURNS
          ...
          @@?/rdbms/admin/sqlsessstart.sql
           
          Rem **********************************************************************
          Rem
          Rem  NOTE: SQL CODE NOT PERMITTED IN THIS FILE ONLY THE EXECUTION OF A
          Rem       .SQL or .PLB file.
          Rem
          Rem **********************************************************************
           
          --CATCTL -S                      Initial scripts single threaded
          @@catpstrt.sql
           
          --CATCTL -S                      Public Types + Grants
          @@catptyps.sql
          @@catpgrants.sql
          Rem
          Rem GSM roles/users/grants
          Rem
          @@catgwm.sql
          Rem
          Rem rolling upgrade views
          Rem
          @@catrupg.sql
           
          --CATCTL -R
          --CATCTL -M                      Tables and views
          @@catptabs.sql     --CATFILE -X
           
          --CATCTL -R
          --CATCTL -S                      Package specs with dependents
          @@catpspec.sql
           
          --CATCTL -R
          --CATCTL -M                      Package specs, procedures, functions
          @@catpdbms.sql     --CATFILE -X
           
          --CATCTL -R
          --CATCTL -M                      Dependent views and indexes
          @@catpdeps.sql     --CATFILE -X
           
          --CATCTL -R
          --CATCTL -S
          -- CDB Views needs to be created right after dba views are created
          -- and before packages. so that packages can refere to these views.
          @@catcdbviews.sql
           
          --CATCTL -R
          --CATCTL -M                      Package and type bodies only
          @@catpprvt.sql     --CATFILE -X
           
          --CATCTL -R                      Required configuration scripts
          --CATCTL -S
          @@catmetinsert.sql
          @@catpcnfg.sql
          @@utluppkg.sql
           
          Rem
          Rem grants for datapump import export
          Rem
          @@catdph.sql
           
          --CATCTL -R
          --CATCTL -M                      Anonymous PLSQL blocks
          @@catpexec.sql     --CATFILE -X
           
          --CATCTL -R
          --CATCTL -S                      Final scripts
          @@catpend.sql
           
          @?/rdbms/admin/sqlsessend.sql
           
          Rem *********************************************************************
          Rem END catproc.sql
          Rem *********************************************************************
           

Fichiers .plb          
A priori les fichiers .plb sont du code PL/SQL wrappé pour qu'il ne soit pas lisible par les utilisateurs de la base, même SYS.
Exemples de contenu d'un fichier .plb
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more prvttsdp.plb
          @@?/rdbms/admin/sqlsessstart.sql
          @@prvttsdpm.plb
          @@prvttsdpe.plb
          @?/rdbms/admin/sqlsessend.sql

Celui-ci semble contenir des infos sur la création du package utlref.          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more utlref.plb
          @@?/rdbms/admin/sqlsessstart.sql
          CREATE OR REPLACE PACKAGE utl_ref wrapped
          a000000
          1
          abcd
          abcd
          abcd
          abcd
          abcd
          abcd
          abcd
          abcd
          abcd
          abcd
          abcd
          abcd
          abcd
          abcd
          abcd
          9
          294 11b
          Rfw5toDaaeFxqtjPAi5VmfblysQwgw1p2Z4VfC/SiupWAFx9lcfp4/qjC/bTmw7GbtJdodK1
          VRYJid/jylYDft+CR0o4NAGyFc0jSpyGvRoTHV+xxn7Yixas6bi0qP7MIDN38m26yJ4J1StZ
          zlNxH5R6nA7WLIcfgYRAKltgmpDE8cPjB2+UgOq8KStQ1e7Tq+YMWtKhZDHsuBwSKb/3BapM
          pSVycWVXHiEgx/T5Z1h6OBR1cDZOzo2rYsDiNunI6vIUw+GsuwmfgYrLULecaA==
           
          /
          CREATE OR REPLACE PUBLIC SYNONYM utl_ref FOR sys.utl_ref
          /
          GRANT EXECUTE ON utl_ref TO PUBLIC
          /
          @?/rdbms/admin/sqlsessend.sql
           

============================================================================================
Exemple de chaque type de fichiers - partie 2

============================================================================================          
Dans cette partie je liste le contenu de quelques fichiers, pour être exhaustif, mais sans explication sur leur rôle.
          
Fichiers .def          
A quoi servent ces fichiers? D'après des recherches sur Google ce serait des fichiers pour l'application SIebel.
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more libqsmashr.def
          {
          global:
                  qsmares;
                  qsmaghw;
                  qsmaresw;
                  qsmaevs;
                  qsmaevsw;
          local:
                  *;
          };
           

Fichiers .lst          
Il s'agit de fichiers de spool.
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more agtept.lst
          #
          # This file contains list of function entry points for "genagtsh.sh" script
          #
          #  This includes functions for each from HS agent object file needed
          #  except the file defining main().
          #  In general, most linkers only need the reference of one extern function
          #  from an object to force the object to be included in a shared lib
          #  and all externs from the object exported implicitly,
          #  if it's not already referenced by other related code.  However,
          #  there may be porting exceptions which require additional symbols
          #  be explicitly exported.
          #  Any port-specific symbols should be added to the end of the file.
          #  Please keep all lists in sorted order, and please ensure not duplicates
          #  exist.
           
          #
          # Format:
          #       product : function
          #
          rdbms : hocdrv
          rdbms : hocdtc
          rdbms : hocdtc1
          rdbms : hocdtc2
          rdbms : hocdtc3
          rdbms : hocdtc4
          rdbms : hocdtc5
          rdbms : hocireg
          ...
           
           
Fichiers .ora
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more externaljob.ora
          # $Header: externaljob.ora 16-dec-2005.20:47:13 rramkiss Exp $
          #
          # Copyright (c) 2005, Oracle. All rights reserved.
          # NAME
          #   externaljob.ora
          # FUNCTION
          #   This configuration file is used by dbms_scheduler when executing external
          #   (operating system) jobs. It contains the user and group to run external
          #   jobs as. It must only be writable by the owner and must be owned by root.
          #   If extjob is not setuid then the only allowable run_user
          #   is the user Oracle runs as and the only allowable run_group is the group
          #   Oracle runs as.
          #
          # NOTES
          #   For Porters: The user and group specified here should be a lowly privileged
          #                user and group for your platform. For Linux this is nobody
          #                and nobody.
          # MODIFIED
          #     rramkiss   12/09/05 -  Creation
          #
          ##############################################################################
          # External job execution configuration file externaljob.ora
          #
          # This file is provided by Oracle Corporation to help you customize
          # your RDBMS installation for your site.  Important system parameters
          # are discussed, and default settings given.
          #
          # This configuration file is used by dbms_scheduler when executing external
          # (operating system) jobs. It contains the user and group to run external
          # jobs as. It must only be writable by the owner and must be owned by root.
          # If extjob is not setuid then the only allowable run_user
          # is the user Oracle runs as and the only allowable run_group is the group
          # Oracle runs as.
           
          run_user = nobody
          run_group = nobody
          
           
Fichiers .par          
Fichiers de paramétrage?
          -rw-r--r--. 1 ora1210 oinstall 588 Mar 15  2000 spuexp.par
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more spuexp.par
          #
          #   $Header: spuexp.par 16-feb-00.16:50:53 cdialeri Exp $
          #
          #   spuexp.sql
          #
          #    Copyright (c) Oracle Corporation 1999, 2000. All Rights Reserved.
          #
          #      NAME
          #        spuexp.par
          #
          #      DESCRIPTION
          #        Export parameter file used to export the whole STATSPACK user.
          #
          #      NOTES
          #        Must be run as the STATSPACK owner, PERFSTAT
          #
          #      MODIFIED   (MM/DD/YY)
          #      cdialeri    02/16/00 - 1191805
          #      cdialeri    08/13/99 - Created for heri
          #
          file=spuexp.dmp log=spuexp.log compress=y grants=y indexes=y rows=y constraints=y owner=PERFSTAT consistent=y
          
           
Fichiers .pl          
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more catcon.pl
          #!/usr/local/bin/perl
          #
          # $Header: rdbms/admin/catcon.pl /st_rdbms_12.1/8 2014/06/14 18:07:54 gravipat Exp $
          #
          # catcon.pl
          #
          # Copyright (c) 2011, 2014, Oracle and/or its affiliates. All rights reserved.
          #
          #    NAME
          #      catcon.pl - CONtainer-aware Perl script for creating/upgrading CATalogs
          #
          #    DESCRIPTION
          #      This script defines subroutines which can be used to execute one or
          #      more SQL statements or a SQL*Plus script in
          #      - a non-Consolidated Database,
          #      - all Containers of a Consolidated Database, or
          #      - a specified Container of a Consolidated Database
           
          #use strict "vars";
           
          use File::Basename qw();
          BEGIN {
            my ($name, $path, $suffix) = File::Basename::fileparse($0);
            push @INC, $path;
          }
           
          use Getopt::Std;      # to parse command line options
           
          use catcon qw( catconInit catconExec catconWrapUp catconXact catconForce catconReverse catconRevertPdbSeedMode catconEZConnect);
          ...
           
           
Fichiers .pm          
          -rw-r--r--  1 ora1210 oinstall   1429 Dec 21  2016 catconst.pm
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more catconst.pm
          #!/usr/local/bin/perl
          #
          # catconst.pm
          #
          # Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved.
          #
          #    NAME
          #      catconst.pm - Declare Build Constants.
          #
          #    DESCRIPTION
          #      catconst.pm is created from catcommon.pl.
          #      catconst.pm declares constants shared by datapatch
          #      and upgrade.
          #
          #    NOTES
          #      Currently used for Version Information
          #
          #    MODIFIED   (MM/DD/YY)
          #    surman      12/14/15 - 19219946: Add CATCONST_CURRENT_YEAR
          #    jerrede     06/25/15 - Generate User Tablespaces SQL
          #    jerrede     08/21/14 - Added CATCONST_MAXPDBS
          #    jerrede     08/21/14 - Create catconst.pm
          #    jerrede     08/21/14 - Creation
          #
           
          package catconst;
           
          use strict;
          use warnings;
          require Exporter;
           
          #
          # Export the Constants
          #
          our @ISA = qw( Exporter );
          our @EXPORT = qw( CATCONST_BUILD_VERSION
                            CATCONST_BUILD_STATUS
                            CATCONST_BUILD_LABEL
                            CATCONST_MAXPDBS
                            CATCONST_CURRENT_YEAR );
           
          #
          # Database Release Version
          #
          use constant CATCONST_BUILD_VERSION => '12.1.0.2.0';
          #
          # Database Release or Beta Status
          #
          use constant CATCONST_BUILD_STATUS  => 'production';
          #
          # Database Build Label
          #
          use constant CATCONST_BUILD_LABEL   => 'RDBMS_12.1.0.2.0DBPSU_LINUX.X64_161210';
          #
          # Max Number of PDBs
          #
          use constant CATCONST_MAXPDBS       => 254;
          #
          # Current year as defined by the Makefile
          #
          use constant CATCONST_CURRENT_YEAR  => 2016;
           
          1;
           
          
Fichiers .txt          
Ce sont deux fichiers de documentation sur l'utilitaire STATSPACK.
          -rw-r--r--. 1 ora1210 oinstall   1936 May 19  2010 sbdoc.txt
          -rw-r--r--. 1 ora1210 oinstall 159969 Feb 16  2014 spdoc.txt

           
Fichiers .var                     
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more kspapv0.var
          kspapv0.var
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more kspapv1.var
          kspapv1.var
          
           
Fichiers .xml                     
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more bundledata_PSU.xml
          <bundledata version="12.1.0.2.1" series="Patch Set Update">
            <bundle id="1" description="PSU 12.1.0.2.1">
              <component id="CATPROC" name="Oracle Database Packages and Types" schema="SYS">
                <file mode="apply,rollback" new="no">rdbms/admin/prvtpckl.plb</file>
              </component>
            </bundle>
            <bundle id="2" description="PSU 12.1.0.2.2">
              <component id="CATPROC" name="Oracle Database Packages and Types" schema="SYS">
                <file mode="apply,rollback" new="no">rdbms/admin/utluppkg.sql</file>
                <file mode="apply" new="yes">rdbms/admin/bug19532017_upgrade.sql</file>
                <file mode="rollback" new="yes">rdbms/admin/bug19532017_downgrade.sql</file>
              </component>
            </bundle>
            <bundle id="3" description="PSU 12.1.0.2.3">
              <component id="CATPROC" name="Oracle Database Packages and Types" schema="SYS">
                <file mode="apply,rollback" new="yes">rdbms/admin/bug18909599.sql</file>
                <file mode="apply" new="yes">rdbms/admin/bug19532017_upgrade.sql</file>
                <file mode="apply,rollback" new="no">rdbms/admin/utluppkg.sql</file>
              </component>
            </bundle>
           
           
Fichiers .xsd                      
          [ora1210@PPALIORACLEPA03 [TAIAS1] /opt/oracle/srv/12.1.0/rdbms/admin]$ more oraaccess.xsd
          <?xml version="1.0" encoding="UTF-8"?>
          <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
                     targetNamespace="http://xmlns.oracle.com/oci/oraaccess"
                     elementFormDefault="qualified"
                     xmlns:oci="http://xmlns.oracle.com/oci/oraaccess"
                     xmlns="http://xmlns.oracle.com/oci/oraaccess">
           
               <!-- This file is auto generated. Do not modify. -->
           
           
              <!-- define memory size type. valid suffixes are k/K/m/M and no suffix -->
              <xs:simpleType name="memSizeType">
                  <xs:restriction base="xs:string">
                    <xs:pattern value="[0-9]+[k|K|m|M]|[0-9]+"/>
                      <xs:whiteSpace value="collapse"/>
                  </xs:restriction>
              </xs:simpleType>
           
              <!--  percentType -->
              <xs:simpleType name="percentType">
                  <xs:restriction base="xs:double">
                      <xs:minInclusive value="0.000"/>
                      <xs:maxInclusive value="100.000"/>
                  </xs:restriction>
              </xs:simpleType>
           
              <!--  TraceEvents -->
              <xs:simpleType name="traceEventNumberType">
              <!-- allowed values -->
                 <xs:restriction base="xs:unsignedInt">
                   <xs:enumeration value="10883"/>
                 </xs:restriction>
             </xs:simpleType>
           
             <xs:simpleType name="fanSubsFailureActionType"> <!-- allowed values -->
                 <xs:restriction base="xs:string">
                   <xs:enumeration value="error"/>
                   <xs:enumeration value="trace"/>
                   <xs:whiteSpace value="collapse"/>
                 </xs:restriction>
             </xs:simpleType>
          ...