oracle注释数据字典,Oracle 数据字典及注释查询

[oracle@oracledb

~]$ cd $ORACLE_HOME/rdbms/admin/

[oracle@oracledb

admin]$ ls -l *.bsq

-rw-r--r--

1 oracle oinstall   25905 Mar 19  2009 daw.bsq

-rw-r--r--

1 oracle oinstall   91730 Jul 22  2011 dcore.bsq

-rw-r--r--

1 oracle oinstall    2832 Oct 23  2006 ddm.bsq

-rw-r--r--

1 oracle oinstall     674 Jul 14  2008 ddst.bsq

-rw-r--r--

1 oracle oinstall   17993 Feb 23  2010 denv.bsq

-rw-r--r--

1 oracle oinstall    1364 Oct 31  2005 dexttab.bsq

-rw-r--r--

1 oracle oinstall    4937 Oct 31  2005 dfmap.bsq

-rw-r--r--

1 oracle oinstall     728 Oct 31  2005 djava.bsq

-rw-r--r--

1 oracle oinstall   33697 Apr 26  2011 dlmnr.bsq

-rw-r--r--

1 oracle oinstall    9632 Dec  8  2009

dmanage.bsq

-rw-r--r--

1 oracle oinstall   25509 Jun  8  2007

dobj.bsq

-rw-r--r--

1 oracle oinstall   32867 May 18  2011 doptim.bsq

-rw-r--r--

1 oracle oinstall   47093 Nov 12  2009 dpart.bsq

-rw-r--r--

1 oracle oinstall   16679 Jan  8  2007

dplsql.bsq

-rw-r--r--

1 oracle oinstall   17811 Oct  9  2009

drac.bsq

-rw-r--r--

1 oracle oinstall  128181 May 13  2011 drep.bsq

-rw-r--r--

1 oracle oinstall  139898 Jun 11  2010 dsec.bsq

-rw-r--r--

1 oracle oinstall   17751 Mar  9  2009

dsqlddl.bsq

-rw-r--r--

1 oracle oinstall   19958 Jul 30  2008 dsummgt.bsq

-rw-r--r--

1 oracle oinstall   15830 Apr 29  2011 dtools.bsq

-rw-r--r--

1 oracle oinstall    5474 Oct 31  2006 dtxnspc.bsq

-rw-r--r--

1 oracle oinstall 2495314 Sep 18  2011

recover.bsq

-rw-r--r--

1 oracle oinstall   53130 Jul 14  2008 sql.bsq [oracle@oracledb admin]$

[oracle@oracledb

admin]$ find . -name "*.bsq" | xargs grep "create table

obj"

./dmanage.bsq:create

table object_usage

/* object usage statistics */

./dcore.bsq:create

table obj$                                            /*

object table */

./dcore.bsq:create

table objerror$

./dcore.bsq:create

table objauth$                           /* table authorization

table */

./dcore.bsq:create

table objpriv$                       /*

privileges granted to objects */

[oracle@oracledb

admin]$ more dcore.bsq

REM   sanagara

07/18/11 - add spare columns to sqlerror$

REM   yifeng

04/04/10 - add comments to opqtype$ flags

REM   gravipat

10/15/09 - add sqlerror$

REM   rmacnico

04/14/09 - add comments for seg$, ts$ flag bits

REM   shvenugo

03/19/09 - add comments to opqtype$ flags

REM   mbastawa

04/06/08 - add result cache for tab$.property

REM   schakrab

03/24/08 - add comments on obj$ flag

Rem   mziauddi

01/25/08 - use spare2+spare3 of cdef$ for constraint ddl SCN

REM   ramekuma

03/13/08 - bug-6865413: add comments on i_obj2 index

REM   jaeblee

02/06/08 - add i_syn2

REM   bvaranas

01/30/08 - project 25274: Add deferred_stg$

REM   ssonawan

07/13/07 - bug-6020455: add comments on user$ table

REM   achoi

04/20/07 - add i_obj5

REM   sfeinste

04/09/07 - fix comments for type# column of obj$

REM   wechen

01/22/07 - fix comments for type# column of obj$

REM   krajaman

03/01/07 - add objerror$

REM   achoi

11/07/06 - obj$.spare3 stores base user#

REM   jaeblee

10/26/06 - moved edition$ creation from denv.bsq

REM   jiyang

09/07/06 - add comments for audit vault trigger

REM   akruglik

09/01/06 - replace CMV$ with EV$, CMVCOL$ with EVCOL$ +

REM                        rename app_edition#

with edition_obj#

REM   wechen

07/31/06 - add comments for type# column of obj$

REM   akruglik

04/07/06 - add EV$ and EVCOL$

REM   suelee

02/16/06 - bug 4956995 - moved objauth$ et al from dsec.bsq

REM   achoi

12/15/05 - tab$.trigflag 0x200000 indicates read-only table

REM   vmarwah

11/08/05 - Versioning Enabled flag in tab$

REM   jklein

08/01/05 - creation

create

tablespace SYSTEM datafile "D_DBFN"

"D_DSTG" online

/

create

rollback segment SYSTEM tablespace SYSTEM

storage (initial 50K next 50K)

/

create

cluster c_obj# (obj# number)

pctfree 5 size 800                           /* don't waste too much space */

/* A table of 32 cols, 2 index, 2 col per

index requires about 2K.

* A table of 10 cols, 2 index, 2 col per

index requires about 750.

*/

storage (initial 130K next 200k maxextents

unlimited pctincrease 0)

/* avoid space management during IOR I */

/

create

index i_obj# on cluster c_obj#

/

REM NOTE

REM

Logminer/Streams uses contents of this table.

REM

Please do not reuse any flags without verifying the impact of your

REM

changes on inter-op.

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) */

/create

table obj

...skipping

REM

Please do not reuse any flags without verifying the impact of your

REM

changes on inter-op.