Database objects are essential components of a database, including tables, indexes, views, triggers, and sequences. OceanBase Database provides database object management capabilities based on its compatibility with both MySQL and Oracle modes.
This chapter describes the operations of the following database objects:
Database Object Type |
Supported Mode |
Database Object Management Description |
|---|---|---|
| Database (Database) | MySQL mode | Describes how to create, view, modify, and delete databases. For more information, see Create a database. |
| Table (Table) | MySQL/Oracle mode | Describes how to create, modify, delete, lock, and clear tables, as well as define column attributes and set constraint types. For more information, see About tables (MySQL mode) and About tables (Oracle mode). |
| External Table (External Table) | MySQL/Oracle mode | Describes how to create external tables, create external table partitions, manage external files, and map data types. For more information, see About external tables (MySQL mode) and About external tables (Oracle mode). |
| Partition (Partition) | MySQL/Oracle mode | Describes how to create, split, and dynamically manage partitions, as well as adjust partition rules, add, and delete partitions. For more information, see Partition overview (MySQL mode) and Partition overview (MySQL mode). |
| Table Group (TableGroup) | MySQL/Oracle mode | Describes how to create, view, add tables, modify SHARDING attributes, and delete table groups. For more information, see About table groups (MySQL mode) and About table groups (Oracle mode). |
| Index (Index) | MySQL/Oracle mode | Describes how to create, view, monitor, and delete indexes, as well as support for function indexes. For more information, see About indexes (MySQL mode) and About indexes (Oracle mode). |
| View (View) | MySQL/Oracle mode | Describes how to create, modify, and delete normal views. For more information, see Manage normal views (MySQL mode) and Manage normal views (Oracle mode). |
| Materialized View (Materialized View) | MySQL/Oracle mode | Describes how to create, refresh, query rewrite, modify attributes, and isolate resources for materialized views. For more information, see Materialized views overview (MySQL mode) and Materialized views overview (Oracle mode). |
| Sequence (Sequence) | MySQL/Oracle mode | Describes how to create, view, modify, and delete sequences. For more information, see Create a sequence (MySQL mode) and Manage sequences (Oracle mode). |
| Trigger (Trigger) | MySQL/Oracle mode | Describes how to create, view, and delete triggers. For more information, see Overview (MySQL mode) and Overview (Oracle mode). |
| DBLink (database link) | MySQL/Oracle mode | Describes how to create, view, and delete a DBLink. For more information, see Create a DBLink (MySQL mode) and Create a DBLink (Oracle mode). |
| Catalog (data catalog) | MySQL mode | Describes how to create, view, and delete a catalog. For more information, see Overview of Catalog. |
| Hotspot cache policy (storage_cache_policy) | MySQL mode | Describes how to create, modify, and manage a hotspot cache policy. For more information, see Overview of custom hotspot cache policies. |
| Synonym | Oracle mode | Describes how to create and delete a synonym. For more information, see Manage synonyms. |
| Directory | Oracle mode | Describes how to create and delete a directory. For more information, see Manage directories. |