Database objects are components that can be manipulated and used in a database by executing SQL statements. A database is composed of various database objects. This topic describes the types and storage methods of database objects that are supported by OceanBase Database in Oracle mode. This topic also describes the dependencies between database objects.
OceanBase Database in Oracle mode supports the following database objects: tables, views, indexes, partitions, sequences, synonyms, triggers, and various procedural language (PL) objects such as PL subprograms and packages.
In OceanBase Database in Oracle mode, an authorized user can access a database and own database objects.
In OceanBase Database in Oracle mode, a schema is a collection of database objects that are owned by a user. Schemas are used to manage privileges and isolate namespaces. Generally, one schema corresponds to one application. A default schema is specified for a user when the user is created. The schema name is the same as the username.
A user can also access and use other schemas in addition to the default schema. When a user accesses an object in a schema, the system automatically adds the default schema name to the object name if the schema to which the object belongs is not specified.
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.