Database objects, the components of a database, are objects that can be manipulated and used in the database by executing SQL statements. This topic describes the types and storage methods of database objects that are supported by the Oracle mode of OceanBase Database. This topic also describes the dependencies between database objects.
The Oracle mode of OceanBase Database supports the following database objects: tables, views, indexes, partitions, sequences, synonyms, triggers, and various procedural language (PL) objects such as PL subprograms and packages.
The Oracle mode of OceanBase Database allows authorized users to access a database and own database objects.
OceanBase Database uses a schema to refer to a set of database objects belonging to a user and perform privilege management and namespace isolation based on the schema. A schema corresponds to an application. When a user is created, it has a default schema. The schema name is the same as the username.
A user can access and use schemas of other users. When you access an object without specifying a schema, the system automatically adds the default schema name of the object.
Schema objects are database objects in a schema, such as tables, views, and indexes. Non-schema objects are database objects that do not belong to a schema, such as users, roles, tablespaces, and directories.