In an Oracle tenant, each database object belongs to only one schema. Each schema has a unique name which is generally the same as the username. By default, a user can only access a database object in the schema that has the same name as the user. To access a database object in other schemas, you need to prefix the object name with the schema name and have relevant access permission.
The following database objects are supported in a schema:
Tables
A table is the most basic unit of data storage within OceanBase Database A table contains one or more rows of independent data records. Each row contains one or more columns, with each column representing a field of the record.
Indexes
Indexes are used to increase the performance of queries on tables. A table can contain zero, one, or more index objects.
Views
Views are used to show all or part of the data from one or more tables in a single object. A view can also reference tables or another view.
Sequences
When all the records in a table must be distinct from each other, you can use the sequence object to generate a sequence of unique numbers for the numeric columns (for example, the ID columns) of the table. Each number represents the ID column in each row. A sequence is an independent database object and does not belong to any column in a table. The Sequence object generates sequential values for the ID column of a table.
Synonyms
A synonym is an alias for a database object. You can use synonyms to ensure secure and convenient database access. For example, you can use synonyms to mask the owners of objects or simplify SQL statements.