ITPub博客

首页 > 数据库 > Oracle > dba_objects 中不包含 constraint

dba_objects 中不包含 constraint

原创 Oracle 作者:psufnxk2000 时间:2014-04-28 23:35:25 0 删除 编辑
dba_objects 中不包含 constraint,  
其基表 obj$中也不包含 constraint;
constraint (约束)的基表是 con$.


SQL> conn song/song
Connected.


SQL> drop table t purge;


Table dropped.


SQL> create table t (id number);


Table created.


SQL> alter table t add primary key (id);


Table altered.


SQL> select constraint_name from user_constraints where table_name='T';


CONSTRAINT_NAME
------------------------------------------------------------
SYS_C007611


SQL> SELECT index_name from user_indexes where index_name='SYS_C007611';


INDEX_NAME
------------------------------------------------------------
SYS_C007611




SQL> SELECT OBJECT_NAME,OBJECT_TYPE FROM USER_OBJECTS WHERE OBJECT_NAME='SYS_C007611';


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
--------------------------------------
SYS_C007611
INDEX
从 obj$表的字段中可以看出:
type#         number not null,                 /* object type (see KQD.H): */
  /* 1 = INDEX, 2 = TABLE, 3 = CLUSTER, 4 = VIEW, 5 = SYNONYM, 6 = SEQUENCE, */
             /* 7 = PROCEDURE, 8 = FUNCTION, 9 = PACKAGE, 10 = NON-EXISTENT, */
              /* 11 = PACKAGE BODY, 12 = TRIGGER, 13 = TYPE, 14 = TYPE BODY, */
      /* 19 = TABLE PARTITION, 20 = INDEX PARTITION, 21 = LOB, 22 = LIBRARY, */
                                             /* 23 = DIRECTORY , 24 = QUEUE, */
    /* 25 = IOT, 26 = REPLICATION OBJECT GROUP, 27 = REPLICATION PROPAGATOR, */
    /* 28 = JAVA SOURCE, 29 = JAVA CLASS, 30 = JAVA RESOURCE, 31 = JAVA JAR, */
                 /* 32 = INDEXTYPE, 33 = OPERATOR , 34 = TABLE SUBPARTITION, */
                                                  /* 35 = INDEX SUBPARTITION */
                                                 /* 82 = (Data Mining) MODEL */
  
  这里的类型也没有 constraint.
  
  SQL> select name from con$ where name='SYS_C007611';


NAME
------------------------------------------------------------
SYS_C007611

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/25099483/viewspace-1151222/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 索引和主键
下一篇: expdp会导出空表
请登录后发表评论 登录
全部评论

注册时间:2011-05-31

  • 博文量
    215
  • 访问量
    700288