创建oracle数据字典基表的sql文件是哪个文件.

郑全

如题.

 

比如 dba_users数据字典,是建立在user$这个基表上的一个视图,那么oracle在创建数据库时,是通过哪个sql文件来创建的这个文件.

 

 

 

郑全

找到了,是由一个参数决定:_init_sql_file'

select x.ksppinm name,y.ksppstvl value,x.ksppdesc describe
  from sys.x$ksppi x,sys.x$ksppcv y
 where x.indx=y.indx
  and x.ksppinm='_init_sql_file';

 

NAME                 VALUE                          DESCRIBE
-------------------- ------------------------------ -----------------------------------------------------------------
_init_sql_file       ?/rdbms/admin/sql.bsq          File containing SQL statements to execute upon database creation

郑全

察看  ?/rdbms/admin/sql.bsq          ,发现以下信息:

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

郑全

create table user$                                             /* user table */
( user#         number not null,                   /* user identifier number */
  name          varchar2("M_IDEN") not null,                 /* name of user */
               /* 0 = role, 1 = user, 2 = adjunct schema, 3 = schema synonym */
  type#         number not null,
  password      varchar2("M_IDEN"),                    /* encrypted password */
  datats#       number not null, /* default tablespace for permanent objects */
  tempts#       number not null,  /* default tablespace for temporary tables */
  ctime         date not null,                 /* user account creation time */
  ptime         date,                                /* password change time */
  exptime       date,                     /* actual password expiration time */
  ltime         date,                         /* time when account is locked */
  resource$     number not null,                        /* resource profile# */
  audit$        varchar2("S_OPFL"),                    /* user audit options */
  defrole       number not null,                  /* default role indicator: */
               /* 0 = no roles, 1 = all roles granted, 2 = roles in defrole$ */
  defgrp#       number,                                /* default undo group */
  defgrp_seq#   number,               /* global sequence number for  the grp *
  spare         varchar2("M_IDEN"),                   /* reserved for future */
  astatus       number default 0 not null,          /* status of the account */
                /* 0x00 =       0 = Open                                     */
                /* 0x01 =       1 = Locked                                   */
                /* 0x02 =       2 = Expired                                  */
                /* 0x03 =       3 = Locked and Expired                       */
                /* 0x10 =      16 = Password matches a default value         */
  lcount        number default 0 not null, /* count of failed login attempts */
  defschclass   varchar2("M_IDEN"),                /* initial consumer group */
  ext_username  varchar2("M_VCSZ"),                     /* external username */
                             /* also as base schema name for adjunct schemas */
  spare1        number, /* used for schema level supp. logging: see ktscts.h */
  /* spare2 is used to store                                                 */
  /* - edition id for adjunct schemas (type# = 2)                            */
  /* - base schema id for schema synonyms (type# = 3)                        */
  spare2        number,     
  spare3        number,
  spare4        varchar2(1000),
  spare5        varchar2(1000),
  spare6        date
)
cluster c_user#(user#)

郑全

user$表中,有一个字段lcount

lcount        number default 0 not null, /* count of failed login attempts */

记录失败登陆的次数,如何察看用户登录失败的次数,就可以看这个字段

select name,lcount from user$ where name='具体的用户名';

成功登陆后,这个值会置为零.