重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: 创建oracle数据字典基表的sql文件是哪个文件. [打印本页]

作者: 郑全 时间: 2013-6-13 15:53
标题: 创建oracle数据字典基表的sql文件是哪个文件.

如题.

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

作者: 郑全 时间: 2013-6-13 16:00

找到了,是由一个参数决定:_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

作者: 郑全 时间: 2013-6-13 16:01

察看 ?/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

作者: 郑全 时间: 2013-6-13 16:03

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#)

作者: 郑全 时间: 2013-6-13 16:05

user$表中,有一个字段lcount

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

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

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

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

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)