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 |