Database Objects

**Table 1** Schema objects
No.	Oracle	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 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 object with the original name. If the object with the original name is not found, GaussDB searches for the object to which the synonym points. PUBLIC synonyms are searched only when the schema name is a username.
29	Tables	Supported.	-
30	Views	Supported.	-
31	Zone map	Not supported.	-

**Table 2** Nonschema objects
No.	Oracle	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.