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

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

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

job class

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