Tuesday, August 4, 2009

Different Object types in Oracle 11g DB

Different Object types in Oracle 11g DB:
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
92 = OLAP CUBE DIMENSION,
93 = OLAP CUBE ,
94 = OLAP MEASURE FOLDER,
95 = OLAP CUBE BUILD PROCESS


Source: 11g: dcore.bsq . The object types 92-95 are newly introduced in 11g DB for "On-line Analytical Processing".
Futher detail visit site: "http://www.oracle.com/technology/products/bi/olap/index.html"

No comments: