Database objects are a crucial component of a database, primarily including tables, indexes, views, triggers, sequences, and more. OceanBase Database provides relevant database object management capabilities based on two compatibility modes: MySQL and Oracle.
This chapter on database object management covers the following operations:
Database Object Type |
Supported modes |
Database Object Management |
|---|---|---|
| Database | MySQL-compatible mode | This topic describes how to create, view, modify, and drop databases. For more information, see Create a database. |
| Table | MySQL/Oracle-compatible mode | This topic describes how to create, modify, drop, lock, and truncate tables, as well as define column attributes and set constraint types. For more information, see About tables (MySQL-compatible mode) and About tables (Oracle-compatible mode). |
| External Table | MySQL/Oracle-compatible mode | This topic describes how to create external tables, create partitions of external tables, manage external files, and perform data type mapping. For more information, see About external tables (MySQL-compatible mode) and About external tables (Oracle-compatible mode). |
| Partition | MySQL/Oracle-compatible mode | This topic describes how to create, split, and manage dynamic partitions of a partitioned table, as well as adjust partitioning rules and add or drop partitions. For more information, see Partition overview (MySQL-compatible mode) and Partition overview (Oracle-compatible mode). |
| TableGroup | MySQL/Oracle-compatible mode | This topic describes how to create, view, add tables to, modify the SHARDING attribute of, and delete a table group. For more information, see About table groups (MySQL-compatible mode) and About table groups (Oracle-compatible mode). |
| Index | MySQL/Oracle-compatible mode | This topic describes how to create, view, monitor, and drop indexes, and describes the support for function-based indexes. For more information, see About indexes (MySQL-compatible mode) and About indexes (Oracle-compatible mode). |
| View | MySQL/Oracle-compatible mode | This topic describes how to create, modify, and drop normal views. For more information, see Manage normal views (MySQL-compatible mode) and Manage normal views (Oracle-compatible mode). |
| Materialized view | MySQL/Oracle-compatible mode | This topic describes how to create and refresh materialized views, rewrite queries, modify their attributes, and isolate their resources. For more information, see Materialized view overview (MySQL-compatible mode) and Materialized view overview (Oracle-compatible mode). |
| Sequence | MySQL/Oracle-compatible mode | This topic describes how to create, view, modify, and drop sequences. For more information, see Create a sequence (MySQL-compatible mode) and Manage sequences (Oracle-compatible mode). |
| Trigger | MySQL/Oracle-compatible mode | This topic describes how to create, view, and drop triggers. For more information, see Overview (MySQL-compatible mode) and Overview (Oracle-compatible mode). |
| DBLink | MySQL/Oracle-compatible mode | This topic describes how to create, view, and delete DBLinks. For more information, see Create a DBLink (MySQL-compatible mode) and Create a DBLink (Oracle-compatible mode). |
| Catalog | MySQL-compatible mode | This topic describes how to create, view, and delete a catalog. For more information, see Catalog overview. |
| Synonym | Oracle-compatible mode | This topic describes how to create and drop synonyms. For more information, see Manage synonyms. |
| Directory | Oracle-compatible mode | This topic describes how to create and drop directories. For more information, see Manage directories. |