SQL.BSQ file that creates the data dictionary is neat. Its good for getting into arguments. Since alot of DBAs like to correct you when you say 'v$ view', they insist 'v$ table', you open sql.bsq and its 'create or replace view v_$'
There is alot of neat stuff in sql.bsq. Notes that were placed in years ago. Nothing insanely useful(though I havent exactly scoured it). The Standard package in sql.bsq is interesting because you see how oracle overloads the operatings like 'is not null'. Fairly similiar to how its done in 'C'. catalog scripts for creating the data dictionary views were boring and already well documented. I didnt find anything in there that I cant get off of the data dictionary doc on OTN or out of the source in DBA_VIEWS. Catproc files were somewhat useful. Though most of what is in the headers are on OTN. I heard that before Oracle 7.0, Oracle didnt encrypt the PL/SQL packages and you could actually read all the source code. anyone have a copy of that source code lying around? Id like a copy. > > From: DENNIS WILLIAMS <[EMAIL PROTECTED]> > Date: 2003/09/05 Fri AM 11:24:29 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Oracle Script Documentation > > Jay > Here is your chance to join the big league and become an expert in your > own area. One thing I've noticed in tracing the scripts is that many of the > scripts call each other. Something like catproc must call dozens of the > other scripts. Not that much need to understand every low-level script. But > then there are probably some overlooked gems that we aren't aware of. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Friday, September 05, 2003 9:45 AM > To: Multiple recipients of list ORACLE-L > > > Hi Jay, > > I know this is obvious but each script generally has a short description > at the top of each file. Some of these are pretty short one liners bear > in mind but it is a start!. > > If you do find a complete list let us know it sounds like it could be > useful to know where a list for the future. > > hth > > kind regards > > Pete > -- > Pete Finnigan > email:[EMAIL PROTECTED] > Web site: http://www.petefinnigan.com - Oracle security audit specialists > Book:Oracle security step-by-step Guide - see http://store.sans.org for > details. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Pete Finnigan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
