Database Objects

**Table 1** Schema objects
No.	Oracle Database	GaussDB	Difference
1	Analytic views	Not supported.	-
2	Attribute dimensions	Not supported.	-
3	Clusters	Supported.	-
4	Constraints	Supported.	-
5	Database links	Supported.	-
6	Database triggers	Supported.	-
7	Dimensions	Supported.	-
8	External procedure libraries	Not supported.	-
9	Hierarchies	Not supported.	-
10	Index-organized tables	Not supported.	-
11	Indexes	Supported.	-
12	Index types	Not supported.	-
13	Java classes	Not supported.	-
14	Java resources	Not supported.	-
15	Java source code	Not supported.	-
16	Join groups	Not supported.	-
17	Materialized views	Supported.	-
18	Materialized view logs	Not supported.	-
19	Mining models	Not supported.	-
20	Object tables	Not supported.	-
21	Object types	Not supported.	-
22	Object views	Not supported.	-
23	Operators	Supported.	-
24	Packages	Supported.	-
25	Sequences	Supported.	-
26	Storage functions	Supported.	-
27	Stored procedures	Supported.	-
28	Synonyms	Supported, with differences.	The names of Oracle Database objects in the same namespace must be unique. In GaussDB, the name of a synonym can be the same as that of a table, view, function, or package in the same namespace. In this case, GaussDB preferentially accesses the table, view, function, or package object with the same name. If no such object is not found, GaussDB searches for the synonym object. In addition, the PUBLIC synonym is searched only when the schema name of the object to which the synonym points is a username. For details about the search sequence, see "SQL Reference > SQL Syntax > C > CREATE SYNONYM" in Developer Guide.
29	Tables	Supported.	-
30	Views	Supported.	-
31	Zone map	Not supported.	-

**Table 2** Non-schema objects
No.	Oracle Database	GaussDB
1	Contexts	Not supported.
2	Directories	Supported.
3	Editions	Not supported.
4	Flashback archives	Not supported.
5	Lockdown profiles	Not supported.
6	Profiles	Not supported.
7	Restore points	Supported.
8	Roles	Supported.
9	Rollback segments	Ustore supports rollback segments. Astore does not support rollback segments.
10	Tablespaces	Supported.
11	Tablespace sets	Not supported.
12	Unified audit policies	Supported.
13	Users	Supported.