sys.obj$ 表是oracle 数据库字典表中的对象基础表,所有对象都在该表中有记录,其中type#字段表明对象类型,比如有一个表 test ,则该对象在sys.obj$ 中存在一条记录,name列为test, type#列为2,表示该对象是一个表。

该列的其他数值含义如下表所示,以供参考。

解释
0 next object
1 index
2 table
3 cluster
4 view
5 synonym
6 sequence
7 procedure
8 function
9 package
11 package body
12 trigger
13 type
14 type body
19 table partition
20 index partition
21 lob
22 library
23 directory
24 queue
28 java source
29 java class
30 java resource
32 indextype
33 operator
34 table subpartition
35 index subpartition
40 lob partition
41 lob subpartition
43 dimension
44 context
46 rule set
47 resource plan
48 consumer group
51 subscription
52 location
55 xml schema
56 java data
57 edition
59 rule
60 capture
61 apply
62 evaluation context
66 job
67 program
68

job class

69 windows
72 scheduler group
74 schedule
79 chain
81 file group
82 mining model
90 credential
92 cube dimension
93 cube
94 measure folder
95 cube build process
100 file watcher
101 destination

 

 

posted on 2017-03-02 13:41  dspeeding  阅读(1271)  评论(0编辑  收藏  举报