OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Database

SQL - V4.2.0

  • What is OceanBase Database
    • Overview
    • Differences between the Enterprise Edition and the Community Edition
    • System architecture
    • Compatibility with Oracle
      • Overview
      • SQL data types
      • Built-in functions
      • System views
    • Compatibility with MySQL
    • Limitations
  • Get Started
    • Get started with OceanBase Database
    • Learn OceanBase SQL
      • Before you begin
      • Basic SQL operations (MySQL mode)
      • Basic SQL operations (Oracle mode)
    • Build a sample application (MySQL mode)
      • Build a Python application
      • Build a Java application
      • Build a C application
      • Build a Go application
    • Build a sample application (Oracle mode)
      • Build a Java application
      • Build a C application
    • Try out advanced features of OceanBase Database
      • Scalable OLTP
        • Run the TPC-C benchmark in OceanBase Database
        • Try out the hot row update capability of OceanBase Database
      • Try out operational OLAP
      • Try out parallel import and data compression
      • Try out the multi-tenant feature
    • Video tutorials
  • Develop
    • Develop applications in MySQL mode
      • Connect to OceanBase Database
        • Overview
        • Connect to an OceanBase Database tenant by using the mysql client
        • Connect to an OceanBase Database tenant by using OBClient
        • Connect to OceanBase Database by using ODC
        • Connect to OceanBase Database by using Spring Boot
        • Connect to OceanBase Database by using Spring Batch
        • Connect to OceanBase Database by using Spring JDBC
        • Connect to OceanBase Database by using Spring Data JPA
        • Connect to OceanBase Database by using Hibernate
        • Connect to OceanBase Database by using MyBatis
        • Use database connection pool
          • Database connection pool configuration
          • Configure a Tomcat connection pool
          • Configure a C3P0 connection pool
          • Configure a Proxool connection pool
          • Configure a HiKariCP connection pool
          • Configure a DBCP connection pool
          • Configure a CommonPool connection pool
      • Sample applications
        • Python
          • mysqlclient
          • PyMySQL
      • Plan database objects
        • Create a database
        • Create a table group
        • Create a table
        • Create an index
        • Create an external table
      • Write data
        • Insert data
        • Update data
        • Delete data
        • Replace data
      • Read data
        • Single-table queries
        • Join tables
          • INNER JOIN queries
          • FULL JOIN queries
          • LEFT JOIN queries
          • RIGHT JOIN queries
          • Subqueries
        • Use operators and functions in queries
          • Use arithmetic operators in queries
          • Use numerical functions in queries
          • Use string concatenation operators in queries
          • Use string functions in queries
          • Use datetime functions in queries
          • Use type conversion functions in queries
          • Use aggregate functions in queries
          • Use NULL-related functions in queries
          • Use the CASE conditional operator in queries
          • Use the SELECT ... FOR UPDATE statement to lock query results
          • Use the SELECT ... LOCK IN SHARE MODE statement to lock query results
        • Use a DBLink in queries
        • Set operations
      • Transactions
        • Overview
        • Start a transaction
        • Savepoints
          • Mark a savepoint
          • Roll back a transaction to a savepoint
          • Release a savepoint
        • Commit a transaction
        • Roll back a transaction
      • Application errors
        • Troubleshooting guidelines
          • About error codes
          • Error handling specifications for MySQL-compatible applications
        • Common errors and troubleshooting practices
          • Disconnected from the server, with ERROR 2013 reported
          • Idle transaction timed out, with ERROR 6002 reported
          • Transaction timed out, with ERROR 4012 reported
          • User locked, with ERROR 3118 reported
          • Incorrect user password, with ERROR 1045 reported
          • Table already exists, with ERROR 1050 reported
          • Table does not exist, with ERROR 1146 reported
          • Duplicate data inserted, with ERROR 1062 reported
          • ERROR 1215 reported in foreign key addition
          • Data truncated while being inserted, with ERROR 1265 reported
    • Develop applications in Oracle mode
      • Connect to OceanBase Database
        • Overview
        • Connect to an OceanBase Database tenant by using OBClient
        • Connect to OceanBase Database by using ODC
        • Connect to OceanBase Database by using Spring Boot
        • Connect to OceanBase Database by using Spring Batch
        • Connect to OceanBase Database by using Spring JDBC
        • Connect to OceanBase Database by using Spring Data JPA
        • Connect to OceanBase Database by using Hibernate
        • Connect to OceanBase Database by using MyBatis
        • Use database connection pool
          • Database connection pool configuration
          • Configure a Tomcat connection pool
          • Configure a C3P0 connection pool
          • Configure a Proxool connection pool
          • Configure a HiKariCP connection pool
          • Configure a DBCP connection pool
          • Configure a CommonPool connection pool
          • Configure a JDBC connection pool
      • Sample applications
        • Java
          • OceanBase Connector/J
      • Plan database objects
        • Create a table group
        • Create a table
        • Create an index
        • Create an external table
      • Write data
        • Insert data
        • Update data
        • Delete data
        • Replace data
      • Read data
        • Single-table queries
        • Join tables
          • INNER JOIN queries
          • FULL JOIN queries
          • LEFT JOIN queries
          • RIGHT JOIN queries
          • Subqueries
        • Use operators and functions in queries
          • Use arithmetic operators in queries
          • Use numerical functions in queries
          • Use string concatenation operators in queries
          • Use string functions in queries
          • Use datetime functions in queries
          • Use type conversion functions in queries
          • Use aggregate functions in queries
          • Use NULL-related functions in queries
          • Use CASE functions in queries
          • Use the SELECT ... FOR UPDATE statement to lock query results
        • Use a DBLink in queries
        • Set operations
      • Transactions
        • Overview
        • Start a transaction
        • Savepoints
          • Mark a savepoint
          • Roll back a transaction to a savepoint
        • Commit a transaction
        • Roll back a transaction
      • Application errors
        • Troubleshooting guidelines
          • About error codes
          • Error handling specifications for Oracle-compatible applications
        • Common errors and troubleshooting practices
          • Idle transaction timed out, with Error ORA-24761 reported
          • Transaction timed out, with Error ORA-00600 reported
          • User locked, with ERROR 3118 reported
          • Incorrect user password, with ERROR 1045 reported
          • Table already exists, with Error ORA-00955 reported
          • Table does not exist, with Error ORA-04043 reported
          • Duplicate data inserted, with Error ORA-00001 reported
          • Error ORA-00600 reported in foreign key addition
          • Inconsistent data types, with Error ORA-00932 reported
  • Deploy
    • Overview
    • High availability deployment solutions for OceanBase clusters
    • Deploy OceanBase Database Enterprise Edition
      • Deployment process
      • Before deployment
        • Prepare servers
        • Server configuration
        • Prepare installation packages
        • Deploy OAT
      • Deploy through GUI
        • Configure deployment environment using OAT
          • Add a server
        • Deploy OCP
          • Overview
          • Upload installation packages
          • Create MetaDB
          • Deploy OCP
        • Deploy OceanBase clusters using OCP
          • Add a server to the resource pool
          • Deploy a two-replica OceanBase cluster with the arbitration service by using OCP
          • Deploy a single-replica OceanBase cluster by using OCP
          • Deploy a three-replica OceanBase cluster by using OCP
        • (Optional) Deploy ODP
      • Deploy through CLI
        • Configure deployment environment
          • Initialize an OBServer node by using oatcli
          • (Optional) Configure the clock source
        • Deploy OceanBase clusters using CLI
          • Deploy an OceanBase cluster with two replicas and an arbitration service using the CLI
          • Deploy a single-replica OceanBase cluster using the CLI
          • Deploy a three-replica OceanBase cluster using the CLI
        • (Optional) Deploy ODP
    • Deploy OceanBase Database Community Edition
      • Overview
      • Deploy locally
        • Software and hardware requirements
        • Before deployment
          • (Optional) Check resources
          • (Optional) Set password-free SSH logon
          • (Optional) Configure the clock source
          • (Optional) Perform disk planning
          • (Optional) Configure limits.conf
          • (Optional) Configure sysctl.conf
          • (Optional) Disable the firewall and SELinux
          • (Optional) Create a user
        • Deploy through GUI
          • Deploy an OceanBase cluster through the GUI of OBD
          • Deploy an OceanBase cluster through the GUI of OCP
        • Deploy OceanBase Database in a production environment by using the CLI
      • Deploy OceanBase Database in a Kubernetes cluster
    • Clear out an old cluster
  • Migrate
    • Overview
    • Migrate from MySQL databases to OceanBase Database
      • Use OMS to migrate data from a MySQL database to a MySQL tenant of OceanBase Database
      • Use mydumper and myloader to migrate data from a MySQL database to OceanBase Database
      • Use DBCAT to migrate schemas from a MySQL database to OceanBase Database
      • Use DataX to migrate table data from a MySQL database to OceanBase Database
      • Use CloudCanal to migrate data from a MySQL database to OceanBase Database
      • Use Canal to synchronize data from a MySQL database to OceanBase Database
      • Use Flink CDC to synchronize data from a MySQL database to OceanBase Database
      • Use ChunJun to migrate data from a MySQL database to OceanBase Database
    • Migrate from OceanBase Database to MySQL databases
      • Use OMS to migrate data from a MySQL tenant of OceanBase Database to a MySQL database
      • Use OMS to migrate incremental data from an Oracle tenant of OceanBase Database to a MySQL database
      • Use DBCAT to migrate schemas from OceanBase Database to a MySQL database
      • Use DataX to migrate table data from OceanBase Database to a MySQL database
      • Synchronize data from OceanBase Database to a MySQL database using Canal
      • Migrate data from a MySQL OceanBase database to a MySQL database using CloudCanal
      • Use Flink CDC to migrate data from OceanBase Database to a MySQL database
      • Migrate data from a MySQL database in OceanBase Database to a MySQL database using ChunJun
    • Migrate from Oracle databases to OceanBase Database
      • Use OMS to migrate data from an Oracle database to a MySQL tenant of OceanBase Database
      • Use OMS to migrate data from an Oracle database to an Oracle tenant of OceanBase Database
      • Use DBCAT to migrate schemas from an Oracle database to OceanBase Database
      • Use DataX to migrate table data from an Oracle database to OceanBase Database
    • Migrate from OceanBase Database to Oracle databases
      • Use OMS to migrate data from an Oracle tenant of OceanBase Database to an Oracle database
      • Use DBCAT to migrate schemas from OceanBase Database to an Oracle database
      • Use DataX to migrate table data from OceanBase Database to an Oracle database
    • Migrate from DB2 databases to OceanBase Database
      • Use OMS to migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database
      • Use OMS to migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database
      • Use DBCAT to migrate table schemas from a DB2 LUW database to OceanBase Database
    • Migrate from OceanBase Database to DB2 databases
      • Use OMS to migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database
      • Use OMS to migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database
    • Migrate from TiDB databases to OceanBase Database
      • Use OMS to migrate data from a TiDB database to a MySQL tenant of OceanBase Database
    • Migrate from PostgreSQL databases to OceanBase Database
      • Use OMS to migrate data from a PostgreSQL database to a MySQL tenant of OceanBase Database
    • Migrate from CSV files to OceanBase Database
      • Use DataX to migrate CSV files to OceanBase Database
      • Import data by using the LOAD DATA statement
    • Import data from SQL files to OceanBase Database
    • Migrate data between OceanBase Database
      • Use OMS to migrate data from an OceanBase Database tenant to another of the same type
      • Use OMS to migrate data from an OceanBase Database tenant to another of the same type in active-active disaster recovery scenarios
      • Use OBLOADER & OBDUMPER to migrate data between MySQL tenants in OceanBase Database
      • Use OBLOADER & OBDUMPER to migrate data from a MySQL tenant to an Oracle tenant in OceanBase Database
      • Use OBLOADER & OBDUMPER to migrate data between Oracle tenants in OceanBase Database
      • Use OBLOADER & OBDUMPER to migrate data from an Oracle tenant to a MySQL tenant in OceanBase Database
    • Migrate data using SQL statements
      • Migrate data between tables
      • Migrate resource units
      • Export data by using OUTFILE statements
    • Bypass import
      • Overview of direct load
      • Import data in bypass mode by using the LOAD DATA statement
      • Import data in bypass mode by using the INSERT INTO SELECT statement
  • Manage
    • Log on to an OceanBase Database tenant
    • Manage clusters
      • Overview
      • Cluster parameters
      • Common cluster operations
        • View a zone
        • View a node
        • Restart a node
        • Add a node
        • Delete a node
        • Isolate a node
        • Replace a node
        • Start a zone
        • Add a zone
        • Delete a zone
        • Modify a zone
        • Isolate a zone
        • View cluster parameters
        • Modify cluster parameters
        • Upgrade clusters
          • Upgrade OceanBase Database Enterprise Edition
            • Overview
            • Upgrade the arbitration service
            • Upgrade an OceanBase cluster
            • Check upgrade results
          • Upgrade OceanBase Database Community Edition
            • Upgrade OceanBase Database by using OBD
      • Troubleshoot common problems
        • Failures of a minority of nodes
        • Failures of the majority of nodes
    • Manage tenants
      • Tenants
      • Tenant capacity
      • Tenant types
      • User tenants
      • System variables of a tenant
      • Common tenant operations
        • Create a tenant
        • Resource isolation
          • Overview
          • Manage resource isolation (Oracle mode)
            • Configure cgroups
            • Calibrate the disk performance
            • Configure user-level resource isolation
            • Configure SQL statement-level resource isolation
            • Update a resource management plan config
            • Delete a resource management plan config
            • Delete a resource management plan
            • Delete a resource group
            • Clear cgroup configurations
          • Manage resource isolation (MySQL mode)
            • Configure cgroups
            • Configure user-level resource isolation
            • Calibrate the disk performance
            • Configure SQL statement-level resource isolation
            • Update a resource management plan config
            • Delete a resource management plan config
            • Delete a resource management plan
            • Delete a resource group
            • Clear cgroup configurations
        • View tenant and resource information
        • View and set a tenant allowlist
        • View system variables of a tenant
        • Modify system variables of a tenant
        • Scale in/out
          • Tenant scaling
          • Modify the unit configs for a tenant
          • Modify the number of resource units for a tenant
          • Modify the number of primary zones for a tenant
        • Modify attributes of a resource pool
        • Modify attributes of a tenant
        • Lock and unlock a tenant
        • Drop a tenant
        • Restore a tenant
        • Rename a tenant
        • Manage resource pools
          • View resource pools
          • Allocate a resource pool to a tenant
          • Remove a resource pool from a tenant
          • Merge resource pools and split a resource pool
          • Drop a resource pool
        • Manage unit configs
          • Query unit configs
          • Modify a unit config
          • Drop a unit config
    • Manage replicas
      • Overview
      • Replica distribution
        • Locality
        • Locality common operations
          • View locality
          • Modify locality
          • Add replicas
          • Remove replicas
          • Adjust the distribution of replicas
          • View the locality change history
          • Migrate units
      • Traffic distribution
      • Data distribution
    • High availability
      • Overview
      • Multi-replica disaster recovery
        • Data links
        • High availability of ODP
        • Database-level high availability
        • Disaster recovery architecture and levels
      • Physical standby database disaster recovery
        • Overview
        • Limitations
        • Create a standby tenant
          • Preparations
          • Create an empty standby tenant
          • Create a standby tenant by using the backup and recovery feature
          • Create a standby tenant by using the BACKUP DATABASE PLUS ARCHIVELOG feature
        • Log transmission service
          • Overview
          • Configure log transmission service
            • Specify a log restore source
            • Specify a log restore end point
          • View the log restore source
          • View the log synchronization progress
          • Suspend or enable log synchronization
          • Optimize the log synchronization performance
          • Specify log synchronization throttling
          • Specify log compression
        • Log storage service
        • Switch roles
          • Overview
          • Switchover
          • Failover
        • Drop a primary or standby tenant
      • Arbitration high availability
        • Overview
        • Enable the arbitration service for a tenant
        • Disable the arbitration service for a tenant
        • Modify the log stream downgrade control time
        • Replace the arbitration service for a cluster
        • Remove the arbitration service for a cluster
        • Clear residual cluster information
      • Manage recycle bin
        • Overview
        • Enable or disable the recycle bin
        • View objects in the recycle bin
        • Restore objects from the recycle bin
        • Purge the recycle bin
      • Flashback queries
    • Security and permissions
      • Overview
      • Identification and authentication
        • MySQL mode
          • Identity authentication
          • Password complexity
          • Logon failure processing
        • Oracle mode
          • Identity authentication
          • Password complexity
          • Logon failure processing
      • Access control
        • Overview
        • Users and permissions
          • Overview
          • MySQL mode
            • Create a user
            • Privilege types in MySQL mode
            • Grant privileges
            • Privilege delegation
            • View user privileges
            • Modify user privileges
            • Lock or unlock a user
            • Drop a user
          • Oracle mode
            • Privilege types in Oracle mode
            • Create a user
            • Grant direct privileges
            • Privilege delegation
            • Manage roles
              • Overview
              • Create a role
              • Grant a role to another role
              • Grant a role to a user
              • Activate or deactivate roles for a user
              • View roles
              • Modify a role
              • Revoke a role
              • Drop a role
            • Grant indirect privileges
            • View user privileges
            • Modify user privileges
            • Lock or unlock a user
            • Drop a user
        • Network security access control
        • RPC connection authentication
        • Row-level access control
      • Data transmission encryption
        • Overview
        • OBServer transmission encryption
        • ODP transmission encryption
      • Transparent data encryption
        • Overview
        • MySQL mode
          • Enable transparent data encryption for new tables
          • Enable transparent data encryption for existing tables
          • Decrypt a table
        • Oracle mode
          • Enable transparent data encryption for new tables
          • Enable transparent data encryption for existing tables
          • Decrypt a table
      • Security audit
        • Overview
        • Enable security audit
        • Set and view audit rules
        • View audit records
        • Audit user logon operations
        • Audit user operations
        • Audit specified database objects
    • Backup and restore
      • Introduction to physical backup and restore
      • Deploy NFS
      • Log archive
        • Overview
        • Prepare for log archiving
        • Enable ARCHIVELOG
        • Disable ARCHIVELOG
        • View information about pieces
        • View the archiving progress
        • View the archiving history
        • View the archiving parameter settings
        • Change the destination of log archiving
        • Views related to log archiving
      • Data backup
        • Preparations
        • Initiate a full data backup job
        • Initiate an incremental data backup job
        • Stop a backup job
        • View the data backup progress
        • View the data backup history
        • View data backup parameter settings
        • Change the backup destination
        • Views related to data backup
      • Clear backup data
        • Automatic cleanup of expired backups
        • Stop backup cleanup
        • Query the backup cleanup progress
        • Query the backup cleanup history
        • Backup cleanup parameter
        • Views related to backup cleanup
      • Restore data
        • Preparations
        • Perform a physical restore
        • Cancel physical restore
        • Query the restore progress
        • Query the restore result
        • Upgrade a tenant after restore
        • Convert a standby tenant into primary tenant
        • Replay logs to a standby tenant
        • Physical restore parameters
        • Views related to physical restore
    • Monitor
      • Overview
      • Metrics
        • System monitoring
          • Overview
          • Metrics
          • Wait events
          • Latch events
        • SQL monitoring
          • Overview
          • SQL audit
          • Execution plans
      • Cases
    • Logs
      • Overview
      • Log levels
      • Log stability
      • Log control
      • Log metrics
      • View logs
        • Search for the logs of a specific SQL request
        • Query the log of a previous SQL request by using the SQL Trace feature
    • Daily inspection
      • Overview
      • Check cluster parameters
      • Check the host status
      • Check tenant resource usage
      • Check cluster resource usage
      • Check the OBServer node status
      • Check the NTP offset
      • Deadlock detection
      • End-to-end tracing
        • Overview
        • Process
        • Methods
        • Show end-to-end tracing information
    • Performance tuning
      • Overview
      • Identify bottlenecks on a link
      • Identify bottlenecks within components
        • ODP performance bottlenecks
        • ODP performance analysis
        • OBServer performance bottlenecks
          • Overview
          • Non-optimal plan
            • Non-optimal plans
            • Buffer tables
            • Cardinality
          • Hard parsing
          • Capacity issues
          • Internal wait events
      • SQL tuning
        • Execution plan optimization
          • Statistics and cost-based optimization
            • Statistic information
              • Collect statistic information
                • Automatic statistics collection
        • Business logic optimization
          • Schema Specification
        • Locate and analyze slow queries (1)
        • Locate and analyze slow queries (II)
    • Troubleshooting
      • Overview
      • Bootstrap
      • Storage
        • Minor compaction and major compaction
        • Memory-related errors
        • Migration, replication, and rebuild tasks
      • Election
        • Election
        • Leader switchover exceptions
        • Absence of the leader
      • Transaction
        • Transaction-related errors
        • Transaction rollbacks
        • Long-running transactions
        • Suspended transactions
        • Idle transactions
      • Log synchronization-related errors
      • Troubleshoot SQL execution errors
      • Application error -- the error message does not contain an OceanBase error code
      • Application error -- the error message contains an OceanBase error code
    • Emergency response
      • Analysis, diagnostics, and decision-making process
      • Common emergency problem handling
        • Problems caused by capacity changes
          • High disk I/O on a node
          • Tenant memory full
  • Reference
    • System principles
      • Overall architecture of OceanBase Database
      • Development of OceanBase Database
      • Multi-tenant architecture
        • Overview
        • Compatibility modes
        • Tenants
        • Tenants and resource management
          • Tenant resource management
          • Multi-tenant resource isolation
          • Resource unit balancing
      • Database objects
        • Oracle mode
          • Introduction
            • Overview
            • Database object types
            • Database object storage
            • Dependencies between database objects
          • Tables
            • Overview
            • Data type
              • Overview
              • Character data types
              • Numeric data types
              • Date and time data types
              • Rowid data types
              • LOB data types
              • Format model
                • Overview
                • Number format models
                • Datetime format models
              • Multi-model data types
            • Integrity constraints
            • Table storage
            • Table compression
            • Partitioned table
            • Tables with and without a primary key
            • Temporary tables
          • Indexes
            • Overview
            • Local and global indexes
            • Unique and non-unique indexes
            • Index usage
            • Index storage
          • Partitions
            • Overview
            • Partitioning keys
            • Partitioning types
            • Partitioned indexes
          • Views
            • Overview
            • Data manipulation in views
            • Data access from views
            • Updatable views
          • Other objects
            • Sequences
            • Synonyms
          • System views
            • Dictionary views
            • Performance views
          • Data integrity
            • Data integrity overview
            • Integrity constraint type
              • Overview
              • NOT NULL constraints
              • UNIQUE constraints
              • PRIMARY KEY constraints
              • FOREIGN KEY constraints
              • CHECK constraints
            • Use of integrity constraints
        • MySQL mode
          • Introduction
            • Overview
            • Database object types
            • Database object storage
            • Dependencies between database objects
          • Tables
            • Overview
            • Data type
              • Overview
              • Numeric data types
              • Date and time data types
              • Character data types
              • LOB data types
              • Multi-model data types
              • Spatial data types
            • Integrity constraints
            • Table storage
            • Table compression
            • Partitioned table
            • Tables with and without a primary key
          • Indexes
            • Overview of indexes
            • Local and global indexes
            • Unique and non-unique indexes
            • Index usage
            • Index storage
          • Partitions
            • Overview
            • Partitioning keys
            • Partitioning types
            • Partitioned indexes
          • Views
            • Overview
            • Data manipulation in views
            • Data access from views
            • Updatable views
          • System views
            • Dictionary views
            • Performance views
          • Data integrity
            • Data integrity overview
            • Integrity constraint type
              • Overview
              • NOT NULL constraints
              • UNIQUE KEY constraints
              • PRIMARY KEY constraints
              • FOREIGN KEY constraints
            • Use of integrity constraints
      • Distributed database objects
        • Overview
        • Cluster architecture
        • Data partitions and replicas
          • Overview
          • Log streams
          • Partition replica type
            • Overview
            • Full-featured replica
          • Multi-replica consensus protocols
        • Dynamic scaling
          • Cluster scaling
          • Tenant resource scaling
            • Overview
            • Horizontal scaling of tenant resources
            • Vertical scaling of tenant resources
            • Cross-zone management of tenant resources
      • Data link
        • Overview
        • Database proxy
          • Overview
          • SQL routing
          • Connection management
          • ODP configuration management
          • Logs and monitoring
        • Database connector
          • Overview
          • OBCI
          • OceanBase Connector/J
          • OceanBase Connector/C
      • User interface and query language
        • SQL
          • Introduction
            • SQL overview
            • SQL data access
            • SQL standards
          • SQL statements
            • SQL statement overview
            • DDL statements
            • DML statements
            • DCL statements
          • Execution process of SQL queries
          • Query SQL execution plans
          • Distributed execution plan
            • Perform distributed execution and parallel queries
            • Generate distributed execution plans
            • Run and disable a parallel query
            • Manage distributed execution plans
            • Perform parameter tuning for a parallel query
        • PL
          • PL concepts
            • Oracle mode
              • Subprograms
              • Stored Procedures
              • Functions
              • Triggers
              • Packages
            • MySQL mode
              • Subprograms
              • Stored procedures
              • Functions
              • Triggers
          • PL subprogram execution mechanism
        • Client programming languages
      • Transaction management
        • Transaction
          • Overview
          • Transaction structure
          • Statement-level atomicity
          • GTS
          • Transaction control
            • Overview
            • Active transactions
            • Savepoint
            • Transaction control statements
              • MySQL transaction control
              • Oracle transaction control
          • Redo logs
          • Local transactions
          • Distributed transaction
            • Overview
            • Two-phase commit
          • XA transactions
        • Transaction concurrency and consistency
          • Overview
          • Multi-version read consistency
          • Concurrency control
            • Overview
            • Lock mechanism
          • Transaction isolation level
            • Overview
            • Transaction isolation levels in Oracle mode
            • Transaction isolation levels in MySQL mode
          • Weak consistency read
      • Storage architecture
        • Overview
        • Data storage
          • Overview
          • MemTables
          • SSTable
          • Compression and encoding
        • Compaction
          • Overview
          • Minor compaction
          • Merges
        • Multi-level caches
        • Query processing
        • Data integrity
          • Detect silent data corruption
      • Data reliability and high availability
        • High availability architecture
          • Overview
          • ODP high availability
          • Leader election in distributed systems
          • Multi-replica log synchronization
          • Paxos protocol
          • Automatic handling of node faults
        • Deployment solutions for disaster recovery
        • Data protection
          • Overview
          • Flashback queries
          • Recycle bin variables
        • Backup and restore
          • Overview
          • Backup directory structures
          • Backup architecture
          • Restore architecture
      • Database security
        • Overview
        • Authentication
        • Access control
        • Data transmission encryption
        • Data storage encryption
        • Monitoring and alert
        • Security audit
      • OBServer node architecture
        • Structure of the OBServer node working directory
        • Configuration files
        • observer thread model
          • Threads
          • Worker threads
          • Background threads
        • Logs
        • Memory management
          • Overview
          • Memory-related parameters
          • Memory-related views
          • Memory usage logs
          • Diagnose memory errors
    • System management
      • Configuration management
        • Overview
        • Set parameters
        • Set variables
        • General system parameters
        • Default production parameters
        • Minimum resource configurations
      • Storage management
        • Minor compaction management
          • Overview
          • Automatically trigger a minor compaction
          • Manually initiate a minor compaction
          • View the details of minor compactions
          • Modify minor compaction configurations
        • Major compaction management
          • Overview
          • Automatically trigger a major compaction
          • Configure scheduled major compactions
          • Adaptive major compaction
          • Manually initiate a major compaction
          • Manually control a major compaction
          • View the compaction process
          • Modify major compaction parameters
        • Data compression
          • Overview
          • Data encoding and compression
      • Memory management
        • Overview
        • Memory structure
        • Set the maximum memory for an OceanBase database
        • Manage internal system memory
        • Manage internal tenant memory
        • Manage the memory of the plan cache
        • Memleak-based regular memory leak diagnostics mechanism
        • Query memory usage information
        • Common memory issues
      • Process management
        • Overview
        • Multi-tenant threads of OceanBase Database
        • View the thread status
        • Background threads of OceanBase Database
        • FAQ about multi-tenant threads
      • Disk management
        • Configure automatic scale-out of disk space for data files
    • Database object management
      • Overview
      • MySQL mode
        • Create and manage databases
          • Create a database
          • View databases
          • Modify a database
          • Drop a database
        • Create and manage tables
          • Overview
          • Create a table
          • Define an auto-increment column
          • Define column constraints
          • Query the definition of a table
          • Modify a table
          • Empty a table
          • Drop a table
          • Lock a table
          • Create and manage external tables
            • Overview
            • Create an external table
            • Manage external files
        • Create and manage partitions
          • Overview
          • Create a partitioned table
          • Modify partitioning rules
          • Add a partition
          • Drop a partition
          • Truncate a partition
          • Partition pruning
          • Query data in specified partitions
          • Create indexes on partitioned tables
            • Overview
            • Local indexes
            • Global indexes
        • Create and manage table groups
          • Overview
          • Create a table group
          • Query information about a table group
          • Add tables to a table group
          • Modify the SHARDING attribute of a table group
          • Manage tables in a table group
          • Drop a table group
        • Create and manage indexes
          • Overview
          • Create an index
          • Query indexes
          • Drop an index
          • System functions supported for function-based indexes
          • System functions not supported for function-based indexes
        • Manage views
        • Create and manage sequences
          • Create a sequence
          • Query sequences
          • Reference a sequence
          • Modify a sequence
          • Drop a sequence
        • Create and manage triggers
          • Overview
          • Create a DML trigger
          • Query trigger information
          • Drop a trigger
        • Create and manage DBLinks
          • Create a DBLink
          • Query a DBLink
          • Use a DBLink to access data in a remote database
          • Drop a DBLink
      • Oracle mode
        • Create and manage tables
          • Overview
          • Create a table
          • Define column constraints
          • Query the definition of a table
          • Modify a table
          • Empty a table
          • Drop a table
          • Lock a table
          • Create and manage external tables
            • Overview
            • Create an external table
            • Manage external files
        • Create and manage partitions
          • Overview
          • Create a partitioned table
          • Modify partitioning rules
          • Add a partition
          • Drop a partition
          • Truncate a partition
          • Partition pruning
          • Query data in specified partitions
          • Create indexes on partitioned tables
            • Overview
            • Local indexes
            • Global indexes
        • Create and manage table groups
          • Overview
          • Create a table group
          • Query information about a table group
          • Add tables to a table group
          • Modify the SHARDING attribute of a table group
          • Manage tables in a table group
          • Drop a table group
        • Create and manage indexes
          • Overview
          • Create an index
          • Query indexes
          • Drop an index
          • System functions supported for function-based indexes
          • System functions not supported for function-based indexes
        • Manage views
        • Manage sequences
        • Manage synonyms
        • Create and manage triggers
          • Overview
          • Create a DML trigger
          • Create an INSTEAD OF trigger
          • Create a composite trigger
          • Modify and drop a trigger
          • Disable or enable a trigger
          • Query trigger information
        • Manage directory objects
        • Create and manage DBLinks
          • Create a DBLink
          • Query existing DBLinks
          • Use a DBLink to access data in a remote database
          • Use a DBLink to modify data in a remote database
          • Drop a DBLink
          • Install and configure OCI
    • Database design specifications and practices
      • Object naming conventions
        • Overview
        • Tenant naming conventions
        • User naming conventions
        • Table naming conventions
        • Field naming conventions
        • Other naming conventions
      • Object structure design specifications
        • Field design
        • Table structure design
        • Partitioned table design
        • Index design
        • Other structural designs
      • Character set specifications
      • Database connection specifications
      • Comments
      • ORM conventions
      • Exception handling
    • SQL reference
      • SQL syntax
        • System tenants
          • Overview
          • ALTER SYSTEM
            • ACTIVATE
            • ARCHIVELOG
            • ARBITRATION
            • BOOTSTRAP
            • BACKUP
            • BALANCE TASK
            • CANCEL MIGRATE UNIT
            • MERGE
            • MIGRATE UNIT
            • DELETE BACKUP
            • FAILOVER
            • FLUSH PLAN CACHE
            • JOB
            • LOG RESTORE SOURCE
            • PARAMETER
            • RECOVER
            • REFRESH
            • RESTORE
            • SERVER
            • SWITCHOVER
            • THROTTLE
            • ZONE
          • ALTER RESOURCE POOL
          • ALTER RESOURCE TENANT
          • ALTER RESOURCE UNIT
          • ALTER TENANT
          • CREATE RESOURCE POOL
          • CREATE RESOURCE UNIT
          • CREATE TENANT
          • DROP RESOURCE POOL
          • DROP RESOURCE UNIT
          • DROP TENANT
          • SET DECRYPTION
          • SET ENCRYPTION
        • User tenants (MySQL mode)
          • Basic elements
            • Data types
              • Overview
              • Numeric types
                • Overview
                • Integer data types
                • Fixed-point data types
                • Floating-point data types
                • Bit value data type
              • Date and time types
                • Overview
                • DATE, DATETIME, and TIMESTAMP types
                • TIME type
                • YEAR type
              • String types
                • Overview
                • CHAR and VARCHAR
                • BINARY and VARBINARY
              • Large objects and text types
                • Overview
                • BLOB types
                • TEXT types
              • ENUM type
              • SET type
              • JSON data types
                • Overview
                • Create a JSON value
                • Query and modify JSON values
                • Convert a JSON data type
              • Spatial data types
                • Overview
                • SRS
                • Create a spatial column
                • Create a spatial index
                • Spatial data formats
            • Expressions
              • Overview
              • Expression syntax
              • Convert data types in expression evaluation
            • Character set and collation
              • Overview
              • Character sets
              • Collations
              • Database-level character sets and collations
              • Table-level character sets and collations
              • Column-level character sets and collations
              • Character sets and collations for character expressions
              • Character sets and collations for client connection
            • Literals
              • Overview
              • Strings
              • Numbers
              • Date and time values
              • Bit values
              • Boolean values
              • NULLs
            • Schema object names
            • User-defined variables
            • Comments
          • Operators
            • Overview
            • Operator precedence
            • Arithmetic operators
            • Bitwise operators
            • Comparison operators
            • Logical operators
            • Assignment operators
            • Date and time operators
            • Concatenation operators
            • BINARY operator
            • CASE conditional operator
          • Sequence pseudocolumns
          • Functions
            • Overview
            • Single-row functions
              • Date and time functions
                • ADDDATE
                • CONVERT_TZ
                • CURDATE
                • CURRENT_DATE
                • CURRENT_TIME
                • CURRENT_TIMESTAMP
                • CURTIME
                • DATE
                • DATE_ADD
                • DATE_FORMAT
                • DATE_SUB
                • DATEDIFF
                • DAYOFMONTH
                • DAYOFWEEK
                • DAYOFYEAR
                • EXTRACT
                • FROM_DAYS
                • FROM_UNIXTIME
                • GET_FORMAT
                • HOUR
                • LAST_DAY
                • LOCALTIME
                • LOCALTIMESTAMP
                • MAKEDATE
                • MAKETIME
                • MICROSECOND
                • MINUTE
                • MONTH
                • MONTHNAME
                • NOW
                • PERIOD_ADD
                • PERIOD_DIFF
                • QUARTER
                • SEC_TO_TIME
                • SECOND
                • STR_TO_DATE
                • SUBDATE
                • SUBTIME
                • SYSDATE
                • TIME
                • TIME_FORMAT
                • TIME_TO_SEC
                • TIME_TO_USEC
                • TIMEDIFF
                • TIMESTAMP
                • TIMESTAMPADD
                • TIMESTAMPDIFF
                • TO_DAYS
                • TO_SECONDS
                • UNIX_TIMESTAMP
                • USEC_TO_TIME
                • UTC_DATE
                • UTC_TIME
                • UTC_TIMESTAMP
                • WEEK
                • WEEKDAY
                • WEEKOFYEAR
                • YEARWEEK
                • YEAR
                • ADDTIME
                • DAYNAME
                • DAY
              • String functions
                • ASCII
                • BIN
                • BIT_LENGTH
                • CHAR
                • CHAR_LENGTH
                • CHARACTER_LENGTH
                • CONCAT
                • CONCAT_WS
                • ELT
                • EXPORT_SET
                • FIELD
                • FIND_IN_SET
                • FORMAT
                • HEX
                • INSERT
                • INSTR
                • INT2IP
                • IP2INT
                • LCASE
                • LEFT
                • LENGTH
                • LOCATE
                • LOWER
                • LPAD
                • LTRIM
                • MAKE_SET
                • MID
                • OCT
                • OCTET_LENGTH
                • ORD
                • POSITION
                • QUOTE
                • REGEXP
                • REGEXP_INSTR
                • REGEXP_LIKE
                • REGEXP_REPLACE
                • REGEXP_SUBSTR
                • REPEAT
                • REPLACE
                • REVERSE
                • RIGHT
                • RLIKE
                • RPAD
                • RTRIM
                • SPACE
                • STRCMP
                • SUBSTR
                • SUBSTRING
                • SUBSTRING_INDEX
                • TRIM
                • UCASE
                • UNHEX
                • UPPER
                • WEIGHT_STRING
                • TO_BASE64
                • FROM_BASE64
                • SOUNDEX
              • Conversion functions
                • CAST
                • CONVERT
                • SCN_TO_TIMESTAMP
                • TIMESTAMP_TO_SCN
              • Mathematical functions
                • ABS
                • ACOS
                • ASIN
                • ATAN
                • ATAN2
                • BIT_COUNT
                • CEIL
                • CEILING
                • CONV
                • COS
                • COT
                • CRC32
                • DEGREES
                • EXP
                • FLOOR
                • GENERATOR
                • LN
                • LOG
                • LOG10
                • LOG2
                • MOD
                • NEG
                • NORMAL
                • PI
                • POW
                • POWER
                • RADIANS
                • RAND
                • RANDOM
                • RANDSTR
                • ROUND
                • SIGN
                • SIN
                • SQRT
                • TAN
                • TRUNCATE
                • UNIFORM
                • ZIPF
              • Comparison functions
                • GREATEST
                • INTERVAL
                • ISNULL
                • LEAST
              • Process control functions
                • CASE
                • IF
                • IFNULL
                • NULLIF
                • ORA_DECODE
            • Aggregate functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • GROUP_CONCAT
              • GROUPING
              • MAX
              • MIN
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
            • Analysis functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • CUME_DIST
              • DENSE_RANK
              • FIRST_VALUE
              • LAG
              • LAST_VALUE
              • LEAD
              • MAX
              • MIN
              • NTH_VALUE
              • NTILE
              • PERCENT_RANK
              • RANK
              • ROW_NUMBER
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
            • Encryption functions
              • AES_DECRYPT
              • AES_ENCRYPT
              • COMPRESS
              • DECODE
              • DES_DECRYPT
              • DES_ENCRYPT
              • ENCODE
              • ENCRYPT
              • MD5
              • UNCOMPRESS
              • UNCOMPRESSED_LENGTH
              • RANDOM_BYTES
              • SHA
              • SHA1
              • SHA2
              • VALIDATE_PASSWORD_STRENGTH
            • Information functions
              • BENCHMARK
              • CHARSET
              • COERCIBILITY
              • COLLATION
              • CONNECTION_ID
              • CURRENT_USER
              • DATABASE
              • FOUND_ROWS
              • LAST_INSERT_ID
              • ICU_VERSION
              • ROW_COUNT
              • SCHEMA
              • SESSION_USER
              • SYSTEM_USER
              • USER
              • VERSION
              • OB_VERSION
            • JSON functions
              • Create JSON text functions
                • JSON_ARRAY
                • JSON_OBJECT
                • JSON_QUOTE
              • Search JSON text functions
                • JSON_CONTAINS
                • JSON_CONTAINS_PATH
                • JSON_EXTRACT
                • JSON_KEYS
                • JSON_OVERLAPS
                • JSON_SEARCH
                • JSON_VALUE
                • MEMBER OF
              • Modify JSON text functions
                • JSON_ARRAY_APPEND
                • JSON_ARRAY_INSERT
                • JSON_INSERT
                • JSON_MERGE
                • JSON_MERGE_PATCH
                • JSON_MERGE_PRESERVE
                • JSON_REMOVE
                • JSON_REPLACE
                • JSON_SET
                • JSON_UNQUOTE
              • Return JSON text property functions
                • JSON_DEPTH
                • JSON_LENGTH
                • JSON_TYPE
                • JSON_VALID
              • JSON utility functions
                • JSON_PRETTY
                • JSON_STORAGE_SIZE
              • JSON aggregate functions
                • JSON_ARRAYAGG
                • JSON_OBJECTAGG
            • Spatial functions
              • Functions that create geometry values
              • Spatial operation functions
              • Spatial relation functions
              • Geometry property functions
              • Geometry format conversion functions
            • Performance schema functions
              • FORMAT_BYTES
              • FORMAT_PICO_TIM
            • Other functions
              • ANY_VALUE
              • BIN_TO_UUID
              • COALESCE
              • DEFAULT
              • NAME_CONST
              • INET_ATON
              • INET_NTOA
              • INET6_ATON
              • INET6_NTOA
              • IS_IPV4
              • IS_IPV4_COMPAT
              • IS_IPV6
              • IS_UUID
              • NVL
              • UUID_TO_BIN
              • SLEEP
              • UUID
              • UUID_SHORT
              • VALUES
          • Queries and subqueries
            • Overview
            • Subqueries
            • Joins
          • SQL statements
            • General syntax
            • Common Table Expressions
            • ALTER DATABASE
            • ALTER EXTERNAL TABLE
            • ALTER OUTLINE
            • ALTER SEQUENCE
            • MERGE
            • ALTER TABLE
            • ALTER TABLEGROUP
            • ALTER USER
            • ALTER VIEW
            • ANALYZE
            • CREATE DATABASE LINK
            • CREATE DATABASE
            • CREATE EXTERNAL TABLE
            • CREATE INDEX
            • CREATE OUTLINE
            • DROP RESTORE POINT
            • CREATE SEQUENCE
            • CREATE TABLE
            • CREATE TABLEGROUP
            • CREATE USER
            • CREATE VIEW
            • DEALLOCATE PREPARE
            • DROP DATABASE LINK
            • DELETE
            • DESCRIBE
            • DROP DATABASE
            • DROP INDEX
            • DROP OUTLINE
            • DROP TABLE
            • DROP TABLEGROUP
            • DROP SEQUENCE
            • DROP USER
            • DROP VIEW
            • EXECUTE
            • EXPLAIN
            • FLASHBACK
            • GRANT
            • HELP
            • INSERT
            • KILL
            • LOAD DATA
            • LOCK TABLES
            • MERGE
            • OPTIMIZE
            • PREPARE
            • PURGE
            • PURGE RECYCLEBIN
            • RENAME USER
            • RENAME TABLE
            • REPLACE
            • REVOKE
            • SAVEPOINT
            • SCHEMA
            • SELECT INTO
            • SELECT
              • SELECT statement
              • JOIN clause
              • OVER clause
              • UNION clause
            • SET
            • SET CHARSET
            • SET NAMES
            • SET PASSWORD
            • SET TRANSACTION
            • SHOW
            • TRANSACTION
            • TRUNCATE TABLE
            • UPDATE
            • USE
          • DDL feature
            • Overview
            • Index operations
            • Primary key operations
            • Column operations
            • Generated column operations
            • Foreign key operations
            • Table operations
            • Partition operations
            • Column type change rules
        • User tenants (Oracle mode)
          • Introduction to SQL
          • Pseudo columns
            • Overview
            • Hierarchical query pseudocolumns
            • Sequence pseudocolumns
            • ORA_ROWSCN pseudocolumn
            • ROWNUM pseudocolumn
            • ROWID pseudocolumn
          • Basic elements
            • Built-in data types
              • Overview
              • Character data types
                • Overview
                • CHAR data type
                • NCHAR data type
                • NVARCHAR2 data type
                • VARCHAR2 data type
                • VARCHAR data type
              • Numeric data types
                • Overview
                • NUMBER data type
                • FLOAT data type
                • Floating-point numbers
                • Precedence of numeric data types
              • Date, time, and interval data types
                • Overview
                • DATE data type
                • TIMESTAMP data type
                • TIMESTAMP WITH TIME ZONE data type
                • TIMESTAMP WITH LOCAL TIME ZONE data type
                • INTERVAL YEAR TO MONTH data type
                • INTERVAL DAY TO SECOND data type
                • Calculation of dates, timestamps, and intervals
              • RAW data type
              • Large object data types
                • Overview
                • BLOB data type
                • CLOB data type
              • Rowid data types
              • User-defined data types
              • Any types
              • JSON data types
                • Overview
                • Create JSON columns
                • Query JSON data
                • Conversion rules for JSON data types
              • XML data types
                • Overview
                • XML data definition
                • Create an XMLType column
                • Query XMLType data
                • Convert XMLType data
            • Data type comparison rules
              • Overview
              • Numeric value comparison rules
              • Date value comparison rules
              • Character value comparison rules
              • Data type precedence
              • Data type conversion rules
              • Security considerations for data conversion
            • Literals
              • Overview
              • Text literals
              • Numeric literals
              • Date and time literals
                • Date literals
                • Timestamp literals
              • Interval literals
            • Format model
              • Overview
              • Number format models
              • Datetime format models
              • RR datetime format element
              • String-to-date conversion rules
            • NULL value
              • Overview
              • NULLs in SQL functions
              • NULLs in comparison conditions
              • NULLs in conditional expressions
            • Annotations
              • Overview
              • Comments within SQL statements
              • Comments on schema and nonschema objects
              • Hints
                • Overview
                • Hint list
                  • Hints related to access path
                  • Hints related to join orders
                  • Hints related to joins
                  • Hints related to parallel execution
                  • Hints related to query strategy
                  • Hints related to query conversion
                  • Other hints
            • Database objects
              • Schema objects
              • Non-schema objects
            • Database naming conventions
              • Overview
              • Suggestions on schema object names
            • Database object reference methods
              • Overview
              • Reference schema objects
              • Reference objects in a remote database
                • Create a DBLink
                • Reference a DBLink
              • Reference partitioned tables and indexes
              • Reference an attribute or method of an object type
            • Character sets and collations
          • Operators
            • Overview
            • Operator precedence
            • Arithmetic operators
            • Concatenation operator
            • Hierarchical query operators
            • Set operators
            • COLLATE operator
          • Functions
            • Overview
            • Single-row functions
              • Numeric functions
                • ABS
                • ACOS
                • ASIN
                • ATAN
                • ATAN2
                • BITAND
                • CEIL
                • COS
                • COSH
                • EXP
                • FLOOR
                • GENERATOR
                • LN
                • LOG
                • MOD
                • NANVL
                • NORMAL
                • POWER
                • REMAINDER
                • ROUND
                • RANDOM
                • RANDSTR
                • SIGN
                • SIN
                • SINH
                • SQRT
                • TAN
                • TANH
                • TRUNC
                • UNIFORM
                • WIDTH_BUCKET
                • ZIPF
              • String functions that return a string
                • CHR
                • CONCAT
                • INITCAP
                • LOWER
                • LPAD
                • LTRIM
                • NLS_LOWER
                • NLSSORT
                • NLS_UPPER
                • REGEXP_REPLACE
                • REGEXP_SUBSTR
                • REPLACE
                • RPAD
                • RTRIM
                • SUBSTR
                • TRANSLATE
                • TRANSLATE ... USING
                • TRIM
                • UPPER
              • String functions that return numbers
                • ASCII
                • INSTR
                • LENGTH
                • REGEXP_COUNT
                • REGEXP_INSTR
              • Date and time functions
                • ADD_MONTHS
                • CURRENT_DATE
                • CURRENT_TIMESTAMP
                • DBTIMEZONE
                • EXTRACT(datetime)
                • FROM_TZ
                • LAST_DAY
                • LOCALTIMESTAMP
                • MONTHS_BETWEEN
                • NEXT_DAY
                • NUMTODSINTERVAL
                • NUMTOYMINTERVAL
                • ROUND(date)
                • SESSIONTIMEZONE
                • SYS_EXTRACT_UTC
                • SYSDATE
                • SYSTIMESTAMP
                • TO_CHAR(datetime)
                • TO_DSINTERVAL
                • TO_TIMESTAMP
                • TO_TIMESTAMP_TZ
                • TO_YMINTERVAL
                • TRUNC(date)
                • TZ_OFFSET
              • Generic comparison functions
                • GREATEST
                • LEAST
              • Conversion functions
                • ASCIISTR
                • CAST
                • CHARTOROWID
                • CONVERT
                • HEXTORAW
                • NUMTODSINTERVAL
                • NUMTOYMINTERVAL
                • RAWTOHEX
                • ROWIDTOCHAR
                • ROWIDTONCHAR
                • SCN_TO_TIMESTAMP
                • TIMESTAMP_TO_SCN
                • TO_BINARY_DOUBLE
                • TO_BINARY_FLOAT
                • TO_BLOB
                • TO_CHAR(character)
                • TO_CHAR(datetime)
                • TO_CHAR(number)
                • TO_CLOB
                • TO_DATE
                • TO_DSINTERVAL
                • TO_MULTI_BYTE
                • TO_NUMBER
                • TO_NCHAR(character)
                • TO_NCHAR(datetime)
                • TO_NCHAR(number)
                • TO_SINGLE_BYTE
                • TO_TIMESTAMP
                • TO_TIMESTAMP_TZ
                • TO_YMINTERVAL
                • UNISTR
              • Encoding and decoding functions
                • DECODE
                • DUMP
                • ORA_HASH
                • VSIZE
              • Null value related functions
                • COALESCE
                • LNNVL
                • NANVL
                • NULLIF
                • NVL
                • NVL2
              • Environment and identifier functions
                • SYS_CONTEXT
                • SYS_GUID
                • UID
                • USER
                • USERENV
                • OB_VERSION
              • Hierarchical functions
                • SYS_CONNECT_BY_PATH
              • JSON functions
                • Overview
                • Create JSON text functions
                  • JSON_ARRAY
                  • JSON_OBJECT
                  • JSON_ARRAYAGG
                  • JSON_OBJECTAGG
                • Query JSON text functions
                  • JSON_VALUE
                  • JSON_QUERY
                  • JSON_EXISTS
                  • JSON_TABLE
                • Validate JSON text functions
                  • JSON_EQUAL
                • Modify JSON text functions
                  • JSON_MERGEPATCH
              • XML functions
                • Overview
                • Construct XMLType data functions
                  • XMLAGG
                  • XMLATTRIBUTES
                  • XMLELEMENT
                  • XMLPARSE
                • Query XMLType data functions
                  • EXTRACT
                  • EXTRACT VALUE
                  • XMLSERIALIZE
                  • XMLCAST
                • Modify XMLType data functions
                  • UPDATEXML
            • Aggregate functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • CORR
              • COUNT
              • COVAR_POP
              • COVAR_SAMP
              • CUME_DIST
              • DENSE_RANK
              • GROUPING
              • KEEP
              • LISTAGG
              • MAX
              • MEDIAN
              • MIN
              • PERCENT_RANK
              • PERCENTILE_CONT
              • PERCENTILE_DISC
              • RANK
              • REGR_(Linear Regression)
              • ROLLUP
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • WMSYS.WM_CONCAT/WM_CONCAT
            • Analysis functions
              • Analytic functions
              • AVG
              • CORR
              • COUNT
              • COVAR_POP
              • COVAR_SAMP
              • CUME_DIST
              • DENSE_RANK
              • FIRST_VALUE
              • KEEP
              • LAG
              • LAST_VALUE
              • LEAD
              • LISTAGG
              • MAX
              • MEDIAN
              • MIN
              • NTILE
              • NTH_VALUE
              • PERCENT_RANK
              • PERCENTILE_CONT
              • PERCENTILE_DISC
              • RANK
              • RATIO_TO_REPORT
              • REGR_(Linear Regression)
              • ROW_NUMBER
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • WMSYS.WM_CONCAT/WM_CONCAT
          • Expressions
            • Overview
            • Simple expressions
            • Compound expressions
            • Case expressions
            • Column expressions
            • CURSOR expressions
            • Datetime expressions
            • Function expressions
            • Interval expressions
            • Scalar subquery expressions
            • Type constructor expressions
            • Expression list
          • Conditions
            • Overview
            • Condition precedence
            • Comparison conditions
            • Floating-point conditions
            • Logical conditions
            • Pattern-matching conditions
            • Null conditions
            • Compound conditions
            • BETWEEN condition
            • EXISTS condition
            • IN condition
          • Queries and subqueries
            • Overview
            • Simple query
            • Hierarchical query
            • Compound query
            • Join query
            • Subquery
            • DUAL table query
          • SQL statements
            • DDL
              • ALTER EXTERNAL TABLE
              • ALTER INDEX
              • ALTER KEYSTORE
              • ALTER OUTLINE
              • ALTER PROFILE
              • ALTER ROLE
              • ALTER SEQUENCE
              • ALTER SESSION
              • ALTER SYSTEM FLUSH PLAN CACHE
              • ALTER SYSTEM PARAMETER
              • ALTER TABLE
              • ALTER TABLEGROUP
              • ALTER USER
              • CREATE CONTEXT
              • CREATE DIRECTORY
              • CREATE DATABASE LINK
              • CREATE EXTERNAL TABLE
              • CREATE INDEX
              • CREATE KEYSTORE
              • CREATE OUTLINE
              • CREATE PROFILE
              • CREATE ROLE
              • CREATE SEQUENCE
              • CREATE SYNONYM
              • CREATE TABLE
              • CREATE TABLEGROUP
              • CREATE TABLESPACE
              • CREATE USER
              • CREATE VIEW
              • DROP CONTEXT
              • DROP DATABASE LINK
              • DROP DIRECTORY
              • DROP INDEX
              • DROP OUTLINE
              • DROP PROFILE
              • DROP ROLE
              • DROP SEQUENCE
              • DROP SYNONYM
              • DROP TABLE
              • DROP TABLEGROUP
              • DROP TABLESPACE
              • DROP USER
              • DROP VIEW
              • RENAME
              • TRUNCATE TABLE
              • ALTER SYSTEM MAJOR FREEZE
            • DML
              • DELETE
              • INSERT
              • MERGE
              • PURGE
              • EXPLAIN
              • SELECT
                • SIMPLE SELECT
                • Set-based SELECT
                • WITH CLAUSE
              • UPDATE
            • DCL
              • ANALYZE
              • AUDIT
              • COMMENT
              • COMMIT
              • FLASHBACK TABLE BEFORE DROP
              • GRANT
              • KILL
              • LOAD DATA
              • LOCK TABLE
              • REVOKE
              • ROLLBACK
              • SAVEPOINT
              • SET NAMES
              • SET PASSWORD
              • SET ROLE
              • SET VARIABLE
              • SHOW
              • SHRINK
              • TRANSACTION
          • DDL feature
            • Overview
            • Index operations
            • Primary key operations
            • Column operations
            • Generated column operations
            • Foreign key operations
            • Table operations
            • Partition operations
            • Column type change rules
      • SQL specifications and practices
        • Limitations on writing SQL statements
        • SQL writing specifications
          • SELECT statements
          • DML statements
          • Multi-table join statements
          • Table scan
          • Transactions
          • Cache
          • Hint
          • Other specifications
        • SQL statement examples
          • Implicit data type conversion
          • JOIN tables
          • Weak consistency read
          • Pagination queries
      • PL reference
        • What is PL
          • Overview
          • Main features of PL
          • PL architecture
        • PL reference (MySQL mode)
          • Syntax of PL stored programs
          • PL stored procedures
            • Overview
            • Variables in stored programs
            • Stored procedures
            • Stored functions
            • Trigger
            • Limitations on stored programs
          • PL cursors
            • Overview
            • Cursor execution process
            • Limitations on server cursors
          • PL conditional control statements
            • CASE
            • IF
            • ITERATE
            • LEAVE
            • LOOP
            • REPEAT
            • RETURN
            • WHILE
          • PL data manipulation statements
            • CALL
            • DO
          • PL data definition statements
            • ALTER FUNCTION
            • ALTER PROCEDURE
            • CREATE FUNCTION
            • CREATE PROCEDURE
            • CREATE TRIGGER
            • DROP FUNCTION
            • DROP PROCEDURE
            • DROP TRIGGER
          • PL database management statements
            • SHOW CREATE FUNCTION
            • SHOW CREATE PROCEDURE
            • SHOW CREATE TRIGGER
            • SHOW FUNCTION STATUS
            • SHOW PROCEDURE STATUS
            • SHOW TRIGGERS
          • PL related dictionary views
            • INFORMATION_SCHEMA PARAMETERS
            • INFORMATION_SCHEMA ROUTINES
            • INFORMATION_SCHEMA TRIGGERS
          • PL exception handling
            • Overview
            • DECLARE ... CONDITION
            • DECLARE ... HANDLER
            • GET DIAGNOSTICS
            • RESIGNAL
            • SIGNAL
            • Effective scope of an exception handler
            • Diagnostics area
            • Exception handling and OUT/INOUT parameters
            • Limitations on exception handling
          • PL system packages
            • Overview
            • DBMS_RESOURCE_MANAGER
              • Overview
              • CREATE_CONSUMER_GROUP
              • CREATE_PLAN
              • CREATE_PLAN_DIRECTIVE
              • DELETE_CONSUMER_GROUP
              • DELETE_PLAN
              • DELETE_PLAN_DIRECTIVE
              • SET_CONSUMER_GROUP_MAPPING
              • UPDATE_PLAN_DIRECTIVE
            • DBMS_STATS
              • Overview
              • ALTER_STATS_HISTORY_RETENTION
              • CREATE_STAT_TABLE
              • DELETE_COLUMN_STATS
              • DELETE_INDEX_STATS
              • DELETE_TABLE_STATS
              • DELETE_SCHEMA_STATS
              • DELETE_SCHEMA_PREFS
              • DELETE_TABLE_PREFS
              • DROP_STAT_TABLE
              • EXPORT_COLUMN_STATS
              • EXPORT_INDEX_STATS
              • EXPORT_TABLE_STATS
              • EXPORT_SCHEMA_STATS
              • FLUSH_DATABASE_MONITORING_INFO
              • GATHER_INDEX_STATS
              • GATHER_TABLE_STATS
              • GATHER_SCHEMA_STATS
              • GET_STATS_HISTORY_AVAILABILITY
              • GET_STATS_HISTORY_RETENTION
              • GET_PARAM
              • GET_PREFS
              • IMPORT_INDEX_STATS
              • IMPORT_COLUMN_STATS
              • IMPORT_TABLE_STATS
              • IMPORT_SCHEMA_STATS
              • LOCK_PARTITION_STATS
              • LOCK_SCHEMA_STATS
              • LOCK_TABLE_STATS
              • RESTORE_TABLE_STATS
              • RESTORE_SCHEMA_STATS
              • RESET_GLOBAL_PREF_DEFAULTS
              • RESET_PARAM_DEFAULTS
              • PURGE_STATS
              • SET_COLUMN_STATS
              • SET_INDEX_STATS
              • SET_TABLE_STATS
              • SET_GLOBAL_PREFS
              • SET_PARAM
              • SET_SCHEMA_PREFS
              • SET_TABLE_PREFS
              • UNLOCK_PARTITION_STATS
              • UNLOCK_SCHEMA_STATS
              • UNLOCK_TABLE_STATS
            • DBMS_UDR
              • Overview
              • CREATE_RULE
              • DISABLE_RULE
              • ENABLE_RULE
              • REMOVE_RULE
            • DBMS_XPLAN
              • Overview
              • DISPLAY_ACTIVE_SESSION_PLAN
              • DISPLAY_CURSOR
              • DISPLAY
              • DISABLE_OPT_TRACE
              • DISPLAY_SQL_PLAN_BASELINE
              • ENABLE_OPT_TRACE
              • SET_OPT_TRACE_PARAMETER
          • Reserved and non-reserved PL keywords
        • PL reference (Oracle mode)
          • PL language basics
            • Character sets
            • Lexical units
            • Declare
            • Reference identifiers
            • Scope and visibility of identifiers
            • Assign values
            • Expressions
            • PL blocks
            • Subprograms
            • Error-reporting functions
          • PL data types
            • Overview
            • SQL data types
            • LOB data types
            • BOOLEAN type
            • User-defined subtypes
            • PLS_INTEGER and BINARY_INTEGER
            • Arrays
            • PL JSON data types
          • PL process control
            • Overview
            • Conditional control
            • Loop control
            • Sequential control
          • PL collections and records
            • Overview
            • Collections
            • Associative arrays
            • Varrays
            • Nested tables
            • Collection constructor function
            • Collection methods
              • Overview
              • DELETE method
              • TRIM method
              • EXTEND method
              • EXISTS method
              • FIRST and LAST methods
              • COUNT method
              • LIMIT method
              • PRIOR and NEXT methods
            • Records
            • Insert records into a table and update a table by using records
            • Create and call a subprogram with record type parameters
          • PL static SQL
            • Overview
            • Cursors
              • Overview
              • Cursor attributes
              • Implicit cursors
              • Explicit cursors
              • Cursor variables
              • Traverse cursor data by using the FOR loop
              • Modify and drop a cursor
            • Transaction processing and control
            • Autonomous transactions
              • Overview
              • Control autonomous transactions
              • Autonomous triggers
              • Call autonomous functions from SQL statements
          • PL dynamic SQL
            • Overview
            • Execute dynamic SQL statements
            • DBMS_SQL system package
          • PL stored procedures and functions
            • Overview
            • Create a stored procedure
            • Create a function
            • Manage stored procedures and functions
            • Privilege control
            • Pipeline functions
              • Overview
              • Create a pipelined table function
              • Application
            • User-defined functions
              • Overview
              • Interface for user-defined aggregate functions
              • Create user-defined aggregate functions
              • Use user-defined aggregate functions
            • Collection of stored procedure information and its impact on parallel SQL execution
          • PL triggers
            • Overview
            • Create a DML trigger
            • Modify and drop a trigger
            • Disable or enable a trigger
            • Query trigger information
            • INSTEAD OF DML trigger
            • Compound DML trigger
          • PL packages
            • Overview
            • Create a program package
            • Overloaded programs in a package
            • Manage program packages
            • Definition of the PL environment by the STANDARD package
          • PL exception handling
            • Overview
            • Compile-time alerts
            • Exception types
            • Exception handling processes
          • DDL operations on stored PL units
            • Overview
            • ALTER FUNCTION
            • ALTER PACKAGE
            • ALTER PROCEDURE
            • ALTER TRIGGER
            • ALTER TYPE
            • CREATE FUNCTION
            • CREATE PACKAGE
            • CREATE PACKAGE BODY
            • CREATE PROCEDURE
            • CREATE TRIGGER
            • CREATE TYPE
            • CREATE TYPE BODY
            • DROP FUNCTION
            • DROP PACKAGE
            • DROP PROCEDURE
            • DROP TRIGGER
            • DROP TYPE
            • DROP TYPE BODY
          • PL label security package
            • Overview
            • SA_SYSDBA policy management package
              • Overview
              • SA_SYSDBA.ALTER_POLICY
              • SA_SYSDBA.CREATE_POLICY
              • SA_SYSDBA.DROP_POLICY
            • SA_COMPONENTS label component package
              • Overview
              • SA_COMPONENTS.ALTER_LEVEL
              • SA_COMPONENTS.CREATE_LEVEL
              • SA_COMPONENTS.DROP_LEVEL
            • SA_LABEL_ADMIN label management package
              • Overview
              • SA_LABEL_ADMIN.ALTER_LABEL
              • SA_LABEL_ADMIN.CREATE_LABEL
              • SA_LABEL_ADMIN.DROP_LABEL
            • SA_POLICY_ADMIN policy management package
              • Overview
              • SA_POLICY_ADMIN.APPLY_TABLE_POLICY
              • SA_POLICY_ADMIN.DISABLE_TABLE_POLICY
              • SA_POLICY_ADMIN.ENABLE_TABLE_POLICY
              • SA_POLICY_ADMIN.REMOVE_TABLE_POLICY
            • SA_USER_ADMIN user label management package
              • Overview
              • SA_USER_ADMIN.SET_LEVELS
            • SA_SESSION session management package
              • Overview
              • SA_SESSION.LABEL
              • SA_SESSION.RESTORE_DEFAULT_LABELS
              • SA_SESSION.ROW_LABEL
              • SA_SESSION.SET_LABEL
              • SA_SESSION.SET_ROW_LABEL
          • PL system package (Oracle mode)
            • Overview
            • DBMS_APPLICATION_INFO
              • Overview
              • READ_CLIENT_INFO
              • READ_MODULE
              • SET_ACTION
              • SET_CLIENT_INFO
              • SET_MODULE
            • DBMS_AUDIT_MGMT
              • Overview
              • CLEAN_AUDIT_TRAIL
              • CREATE_PURGE_JOB
              • DROP_PURGE_JOB
              • SET_LAST_ARCHIVE_TIMESTAMP
              • SET_PURGE_JOB_STATUS
            • DBMS_CRYPTO
              • Overview
              • ENCRYPT
              • DECRYPT
              • HASH
            • DBMS_DEBUG
              • Overview
              • ATTACH_SESSION
              • CONTINUE
              • DEBUG_ON
              • DEBUG_OFF
              • DETACH_SESSION
              • DELETE_BREAKPOINT
              • DISABLE_BREAKPOINT
              • ENABLE_BREAKPOINT
              • GET_VALUE
              • GET_VALUES
              • GET_RUNTIME_INFO
              • GET_TIMEOUT_BEHAVIOUR
              • INITIALIZE
              • PROBE_VERSION
              • PRINT_BACKTRACE
              • SET_TIMEOUT
              • SET_TIMEOUT_BEHAVIOUR
              • SET_BREAKPOINT
              • SHOW_BREAKPOINTS
            • DBMS_DESCRIBE
              • Overview
              • DESCRIBE_PROCEDURE
            • DBMS_JOB
              • Overview
              • BROKEN
              • CHANGE
              • ZONE
              • INTERVAL
              • NEXT_DATE
              • REMOVE
              • RUN
              • SUBMIT
              • USER_EXPORT
              • WHAT
            • DBMS_LOB
              • Overview
              • APPEND
              • CLOSE
              • COPY
              • CREATETEMPORARY
              • ERASE
              • FREETEMPORARY
              • GETLENGTH
              • ISOPEN
              • INSTR
              • OPEN
              • READ
              • SUBSTR
              • TRIM
              • WRITE
              • WRITEAPPEND
            • DBMS_LOCK
              • Overview
              • SLEEP
            • DBMS_METADATA
              • Overview
              • GET_DDL
            • DBMS_OUTPUT
              • Overview
              • DISABLE
              • ENABLE
              • GET_LINE
              • GET_LINES
              • NEW_LINE
              • PUT
              • PUT_LINE
            • DBMS_PLAN_CACHE
              • Overview
              • PURGE
            • DBMS_RANDOM
              • Overview
              • INITIALIZE
              • NORMAL
              • RANDOM
              • SEED
              • STRING
              • TERMINATE
              • VALUE
            • DBMS_RESOURCE_MANAGER
              • Overview
              • CREATE_CONSUMER_GROUP
              • CREATE_PLAN
              • CREATE_PLAN_DIRECTIVE
              • DELETE_CONSUMER_GROUP
              • DELETE_PLAN
              • DELETE_PLAN_DIRECTIVE
              • SET_CONSUMER_GROUP_MAPPING
              • UPDATE_PLAN_DIRECTIVE
            • DBMS_SCHEDULER
              • Overview
              • CREATE_JOB
              • CREATE_PROGRAM
              • DEFINE_PROGRAM_ARGUMENT
              • DISABLE
              • DROP_JOB
              • DROP_PROGRAM
              • ENABLE
              • GENERATE_JOB_NAME
              • RUN_JOB
              • SET_ATTRIBUTE
              • SET_JOB_ARGUMENT_VALUE
            • DBMS_SESSION
              • Overview
              • CLEAR_ALL_CONTEXT
              • CLEAR_CONTEXT
              • CLEAR_IDENTIFIER
              • RESET_PACKAGE
              • SET_CONTEXT
              • SET_IDENTIFIER
            • DBMS_SQL
              • Overview
              • BIND_VARIABLE
              • CLOSE_CURSOR
              • COLUMN_VALUE
              • DEFINE_COLUMN
              • DEFINE_ARRAY
              • DESCRIBE_COLUMNS
              • EXECUTE
              • EXECUTE_AND_FETCH
              • FETCH_ROWS
              • IS_OPEN
              • LAST_ERROR_POSITION
              • OPEN_CURSOR
              • PARSE
            • DBMS_STATS
              • Overview
              • ALTER_STATS_HISTORY_RETENTION
              • CREATE_STAT_TABLE
              • DELETE_COLUMN_STATS
              • DELETE_INDEX_STATS
              • DELETE_TABLE_STATS
              • DELETE_SCHEMA_STATS
              • DELETE_SCHEMA_PREFS
              • DELETE_TABLE_PREFS
              • DROP_STAT_TABLE
              • EXPORT_COLUMN_STATS
              • EXPORT_INDEX_STATS
              • EXPORT_TABLE_STATS
              • EXPORT_SCHEMA_STATS
              • FLUSH_DATABASE_MONITORING_INFO
              • GATHER_INDEX_STATS
              • GATHER_TABLE_STATS
              • GATHER_SCHEMA_STATS
              • GET_STATS_HISTORY_AVAILABILITY
              • GET_STATS_HISTORY_RETENTION
              • GET_PARAM
              • GET_PREFS
              • IMPORT_INDEX_STATS
              • IMPORT_COLUMN_STATS
              • IMPORT_TABLE_STATS
              • IMPORT_SCHEMA_STATS
              • LOCK_PARTITION_STATS
              • LOCK_SCHEMA_STATS
              • LOCK_TABLE_STATS
              • RESTORE_TABLE_STATS
              • RESTORE_SCHEMA_STATS
              • RESET_GLOBAL_PREF_DEFAULTS
              • RESET_PARAM_DEFAULTS
              • PURGE_STATS
              • SET_COLUMN_STATS
              • SET_INDEX_STATS
              • SET_TABLE_STATS
              • SET_GLOBAL_PREFS
              • SET_PARAM
              • SET_SCHEMA_PREFS
              • SET_TABLE_PREFS
              • UNLOCK_PARTITION_STATS
              • UNLOCK_SCHEMA_STATS
              • UNLOCK_TABLE_STATS
            • DBMS_UDR
              • Overview
              • CREATE_RULE
              • DISABLE_RULE
              • ENABLE_RULE
              • REMOVE_RULE
            • DBMS_UTILITY
              • Overview
              • ACTIVE_INSTANCES
              • COMMA_TO_TABLE
              • CURRENT_INSTANCE
              • DB_VERSION
              • FORMAT_CALL_STACK
              • FORMAT_ERROR_BACKTRACE
              • FORMAT_ERROR_STACK
              • GET_ENDIANNESS
              • GET_HASH_VALUE
              • GET_PARAMETER_VALUE
              • GET_SQL_HASH
              • GET_TIME
              • IS_BIT_SET
              • IS_CLUSTER_DATABASE
              • NAME_RESOLVE
              • NAME_TOKENIZE
              • OLD_CURRENT_SCHEMA
              • OLD_CURRENT_USER
              • PORT_STRING
              • TABLE_TO_COMMA
            • DBMS_WORKLOAD_REPOSITORY
              • Overview
              • ASH_REPORT
            • DBMS_XA
              • Overview
              • DBMS_XA constants
              • DBMS_XA_XID object type
              • DIST_TXN_SYNC
              • XA_COMMIT
              • XA_END
              • XA_FORGET
              • XA_GETLASTOER
              • XA_PREPARE
              • XA_RECOVER
              • XA_ROLLBACK
              • XA_SETTIMEOUT
              • XA_START
            • DBMS_XMLGEN
              • Overview
              • CONVERT
            • DBMS_XPLAN
              • Overview
              • DISPLAY_ACTIVE_SESSION_PLAN
              • DISPLAY_CURSOR
              • DISPLAY
              • DISABLE_OPT_TRACE
              • DISPLAY_SQL_PLAN_BASELINE
              • ENABLE_OPT_TRACE
              • SET_OPT_TRACE_PARAMETER
            • ODCIConst
              • Overview
              • ODCIArgDesc.ArgType
              • ODCIEnv.CallProperty
              • ODCIEnv.Envflags
              • ODCIIndexAlter
              • ODCIIndexAlter parameter alter_option
              • ODCIIndexInfo.IndexInfoFlags
              • ODCIIndexInfo.IndexParaDegree
              • ODCIPredInfo.Flags
              • ODCIQueryInfo.Flags
              • ODCIStatsOptions.Flags
              • ODCIStatsOptions.Options
              • Return Status
              • ScnFlg
            • UTL_ENCODE
              • Overview
              • BASE64_DECODE
              • BASE64_ENCODE
            • UTL_FILE
              • Overview
              • FCLOSE
              • FFLUSH
              • FOPEN
              • FGETPOS
              • FREMOVE
              • FRENAME
              • FSEEK
              • NEW_LINE
              • GET_LINE
              • PUT
              • PUT_LINE
            • UTL_I18N
              • Overview
              • RAW_TO_CHAR
              • STRING_TO_RAW
            • UTL_RAW
              • Overview
              • BIT_AND
              • BIT_COMPLEMENT
              • BIT_OR
              • BIT_XOR
              • CAST_FROM_BINARY_DOUBLE
              • CAST_FROM_BINARY_FLOAT
              • CAST_FROM_BINARY_INTEGER
              • CAST_FROM_NUMBER
              • CAST_TO_BINARY_DOUBLE
              • CAST_TO_BINARY_FLOAT
              • CAST_TO_BINARY_INTEGER
              • CAST_TO_NUMBER
              • CAST_TO_RAW
              • CAST_TO_VARCHAR2
              • COMPARE
              • CONCAT
              • COPIES
              • LENGTH
              • REVERSE
              • SUBSTR
            • ANYDATA TYPE
              • Overview
              • BEGINCREATE static procedure
              • ENDCREATE member procedure
              • GET* member functions
              • GETTYPE member function
              • GETTYPENAME member function
              • PIECEWISE member procedure
              • SET* member procedures
            • XMLType
              • Overview
              • CREATEXML
              • GETCLOBVAL
              • GETSTRINGVAL
              • TRANSFORM
              • XMLTYPE
          • Reserved PL keywords
      • Reserved keywords (MySQL mode)
      • Reserved keywords (Oracle mode)
    • Multi-model API
      • TableAPI
        • Introduction
          • Implementation of TableAPI
          • Differences between replace and insert_or_update
          • TableAPI data models
        • Use the TableAPI client
          • Introduction to the client and instructions for use
          • Set client parameters
          • An example of client use
        • FAQ
      • HBaseAPI
        • HBaseAPI solution introduction
        • HBaseAPI storage model
        • Usage instructions of the HBaseAPI client
    • System views
      • Overview
      • Overview of system views
      • Changes in views in OceanBase Database V3.x and V4.x
      • SYS tenant views
        • Dictionary views
          • information_schema.CHARACTER_SETS
          • oceanbase.DBA_OB_SERVER_JOBS
          • oceanbase.DBA_OB_SERVERS
          • oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_TABLES
          • oceanbase.DBA_OB_TABLEGROUPS
          • oceanbase.DBA_OB_TABLET_REPLICAS
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TENANT_JOBS
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_UNIT_JOBS
          • oceanbase.DBA_OB_UNIT_CONFIGS
          • oceanbase.DBA_OB_UNITS
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OB_ZONES
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.CDB_IND_COLUMNS
          • oceanbase.CDB_IND_PARTITIONS
          • oceanbase.CDB_IND_SUBPARTITIONS
          • oceanbase.CDB_INDEXES
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_RESOURCE_POOLS
          • oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
          • oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.CDB_OB_DATABASES
          • oceanbase.CDB_OB_LS_LOCATIONS
          • oceanbase.CDB_OB_MAJOR_COMPACTION
          • oceanbase.CDB_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_RESTORE_PROGRESS
          • oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_TABLES
          • oceanbase.CDB_OB_TABLEGROUPS
          • oceanbase.CDB_OB_TABLET_REPLICAS
          • oceanbase.CDB_OB_TABLET_TO_LS
          • oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.CDB_OBJECTS
          • oceanbase.CDB_PART_INDEXES
          • oceanbase.CDB_PART_KEY_COLUMNS
          • oceanbase.CDB_PART_TABLES
          • oceanbase.CDB_SUBPART_KEY_COLUMNS
          • oceanbase.CDB_SUBPARTITION_TEMPLATES
          • oceanbase.CDB_TAB_COL_STATISTICS
          • oceanbase.CDB_TAB_COLS
          • oceanbase.CDB_TAB_COLS_V$
          • oceanbase.CDB_TAB_PARTITIONS
          • oceanbase.CDB_TAB_SUBPARTITIONS
          • oceanbase.CDB_TABLES
          • oceanbase.CDB_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.CDB_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.CDB_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.CDB_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.CDB_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.CDB_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.CDB_OB_SYS_VARIABLES
          • oceanbase.CDB_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • information_schema.QUERY_RESPONSE_TIME
          • oceanbase.CDB_OB_LS
          • oceanbase.DBA_OB_LS
          • oceanbase.CDB_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_SERVER_EVENT_HISTORY
          • oceanbase.CDB_OB_FREEZE_INFO
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • oceanbase.CDB_OB_AUTO_INCREMENT
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_OB_USERS
          • oceanbase.CDB_OB_USERS
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.CDB_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_ARBITRATION_SERVICE
          • oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.CDB_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.CDB_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.CDB_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.CDB_OB_BALANCE_TASKS
          • oceanbase.CDB_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASKS
          • oceanbase.CDB_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_ACCESS_POINT
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_DB_LINKS
          • oceanbase.CDB_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.CDB_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
        • Performance views
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_KVCACHE
          • GV$OB_PARAMETERS
          • GV$OB_PROCESSLIST
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_SERVERS
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_UNITS
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$SESSION_EVENT
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SYSTEM_EVENT
          • GV$SESSTAT
          • GV$OB_IO_BENCHMARK
          • GV$OB_SQL_AUDIT
          • GV$LATCH
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_RPC_OUTGOING
          • GV$OB_RPC_INCOMING
          • GV$SQL_PLAN_MONITOR
          • GV$SYSSTAT
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$SESSION_LONGOPS
          • GV$OB_PX_WORKER_STAT
          • GV$OB_PS_STAT
          • GV$OB_PS_ITEM_INFO
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_SSTABLES
          • GV$OB_TENANT_MEMORY
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_KVCACHE
          • V$OB_PARAMETERS
          • V$OB_PROCESSLIST
          • V$OB_PX_TARGET_MONITOR
          • V$OB_SERVERS
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_UNITS
          • V$STATNAME
          • V$EVENT_NAME
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SYSTEM_EVENT
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_SQL_AUDIT
          • V$OB_RPC_OUTGOING
          • V$OB_RPC_INCOMING
          • V$SQL_PLAN_MONITOR
          • V$SESSION_LONGOPS
          • V$LATCH
          • V$OB_PX_WORKER_STAT
          • V$OB_PS_STAT
          • V$OB_PS_ITEM_INFO
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_MERGE_INFO
          • V$SQL_MONITOR_STATNAME
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$OB_SSTABLES
          • V$OB_TENANT_MEMORY
          • GV$SQL_WORKAREA_ACTIVE
          • GV$OB_MEMSTORE_INFO
          • V$OB_MEMSTORE_INFO
          • GV$OB_IO_CALIBRATION_STATUS
          • V$OB_IO_CALIBRATION_STATUS
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_IO_BENCHMARK
          • V$SYSSTAT
          • V$SESSION_EVENT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • GV$OB_LOG_STAT
          • V$OB_LOG_STAT
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_ARCHIVE_DEST_STATUS
          • V$RSRC_PLAN
          • GV$OB_THREAD
          • V$OB_THREAD
          • GV$OB_ARBITRATION_SERVICE_STATUS
          • V$OB_ARBITRATION_SERVICE_STATUS
          • GV$OB_ARBITRATION_MEMBER_INFO
          • GV$OB_ARBITRATION_MEMBER_INFO
          • V$OB_ARBITRATION_MEMBER_INFO
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_LOCKS
          • V$OB_LOCKS
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_TIMESTAMP_SERVICE
          • GV$OB_PX_P2P_DATAHUB
          • V$OB_PX_P2P_DATAHUB
          • GV$SQL_JOIN_FILTER
          • V$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • V$OB_SQL_PLAN
      • MySQL tenant views
        • Dictionary views
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATIONS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLUMNS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.ENGINES
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.STATISTICS
          • information_schema.TABLES
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.db
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_RESOURCE_POOLS
          • oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
          • oceanbase.DBA_OB_SERVER_JOBS
          • oceanbase.DBA_OB_SERVERS
          • oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_TABLES
          • oceanbase.DBA_OB_TABLEGROUPS
          • oceanbase.DBA_OB_TABLET_REPLICAS
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TENANT_JOBS
          • oceanbase.DBA_OB_UNIT_JOBS
          • oceanbase.DBA_OB_UNIT_CONFIGS
          • oceanbase.DBA_OB_UNITS
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OB_ZONES
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.CDB_IND_COLUMNS
          • oceanbase.CDB_IND_PARTITIONS
          • oceanbase.CDB_IND_SUBPARTITIONS
          • oceanbase.CDB_INDEXES
          • oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.CDB_OB_DATABASES
          • oceanbase.CDB_OB_LS_LOCATIONS
          • oceanbase.CDB_OB_MAJOR_COMPACTION
          • oceanbase.CDB_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_RESTORE_PROGRESS
          • oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_TABLES
          • oceanbase.CDB_OB_TABLEGROUPS
          • oceanbase.CDB_OB_TABLET_REPLICAS
          • oceanbase.CDB_OB_TABLET_TO_LS
          • oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.CDB_OBJECTS
          • oceanbase.CDB_PART_INDEXES
          • oceanbase.CDB_PART_KEY_COLUMNS
          • oceanbase.CDB_PART_TABLES
          • oceanbase.CDB_SUBPART_KEY_COLUMNS
          • oceanbase.CDB_SUBPARTITION_TEMPLATES
          • oceanbase.CDB_TAB_COL_STATISTICS
          • oceanbase.CDB_TAB_COLS
          • oceanbase.CDB_TAB_COLS_V$
          • oceanbase.CDB_TAB_PARTITIONS
          • oceanbase.CDB_TAB_SUBPARTITIONS
          • oceanbase.CDB_TABLES
          • oceanbase.CDB_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.CDB_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.CDB_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.CDB_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.CDB_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.CDB_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.CDB_OB_SYS_VARIABLES
          • oceanbase.CDB_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • information_schema.QUERY_RESPONSE_TIME
          • oceanbase.CDB_OB_LS
          • oceanbase.DBA_OB_LS
          • oceanbase.CDB_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_SERVER_EVENT_HISTORY
          • oceanbase.CDB_OB_FREEZE_INFO
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • oceanbase.CDB_OB_AUTO_INCREMENT
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_OB_USERS
          • oceanbase.CDB_OB_USERS
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.CDB_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
          • information_schema.ST_GEOMETRY_COLUMNS
          • information_schema.ST_SPATIAL_REFERENCE_SYSTEMS
          • oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.CDB_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.CDB_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.CDB_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.CDB_OB_BALANCE_TASKS
          • oceanbase.CDB_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASKS
          • oceanbase.CDB_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_ACCESS_POINT
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_DB_LINKS
          • oceanbase.CDB_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.CDB_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
        • Performance views
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_KVCACHE
          • GV$OB_PARAMETERS
          • GV$OB_PROCESSLIST
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_SERVERS
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_UNITS
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$SESSION_EVENT
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SYSTEM_EVENT
          • GV$SESSTAT
          • GV$OB_SQL_AUDIT
          • GV$LATCH
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_RPC_OUTGOING
          • GV$OB_RPC_INCOMING
          • GV$SQL_PLAN_MONITOR
          • GV$SESSION_LONGOPS
          • GV$OB_PX_WORKER_STAT
          • GV$OB_PS_STAT
          • GV$OB_PS_ITEM_INFO
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_SSTABLES
          • GV$OB_TENANT_MEMORY
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_KVCACHE
          • V$OB_PARAMETERS
          • V$OB_PROCESSLIST
          • V$OB_PX_TARGET_MONITOR
          • V$OB_SERVERS
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_UNITS
          • V$STATNAME
          • V$EVENT_NAME
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SYSTEM_EVENT
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_SQL_AUDIT
          • V$OB_RPC_OUTGOING
          • V$OB_RPC_INCOMING
          • V$SQL_PLAN_MONITOR
          • V$SESSION_LONGOPS
          • V$LATCH
          • V$OB_PX_WORKER_STAT
          • V$OB_PS_STAT
          • V$OB_PS_ITEM_INFO
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_MERGE_INFO
          • V$SQL_MONITOR_STATNAME
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$OB_SSTABLES
          • V$OB_TENANT_MEMORY
          • GV$SQL_WORKAREA_ACTIVE
          • GV$OB_MEMSTORE_INFO
          • V$OB_MEMSTORE_INFO
          • GV$SYSSTAT
          • V$SYSSTAT
          • V$SESSION_EVENT
          • GV$ACTIVE_SESSION_HISTORY
          • V$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • V$DML_STATS
          • GV$OB_LOG_STAT
          • V$OB_LOG_STAT
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_ARCHIVE_DEST_STATUS
          • V$RSRC_PLAN
          • GV$OB_THREAD
          • V$OB_THREAD
          • GV$OB_ARBITRATION_SERVICE_STATUS
          • V$OB_ARBITRATION_SERVICE_STATUS
          • GV$OB_ARBITRATION_MEMBER_INFO
          • V$OB_ARBITRATION_MEMBER_INFO
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_LOCKS
          • V$OB_LOCKS
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_TIMESTAMP_SERVICE
          • GV$OB_PX_P2P_DATAHUB
          • V$OB_PX_P2P_DATAHUB
          • GV$SQL_JOIN_FILTER
          • V$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • V$OB_SQL_PLAN
      • Oracle tenant views
        • Dictionary views
          • ALL_ALL_TABLES
          • ALL_ARGUMENTS
          • ALL_COL_COMMENTS
          • ALL_COLL_TYPES
          • ALL_COL_PRIVS
          • ALL_CONSTRAINTS
          • ALL_CONS_COLUMNS
          • ALL_DEF_AUDIT_OPTS
          • ALL_ERRORS
          • ALL_INDEXES
          • ALL_IND_COLUMNS
          • ALL_IND_EXPRESSIONS
          • ALL_IND_PARTITIONS
          • ALL_IND_SUBPARTITIONS
          • ALL_METHOD_PARAMS
          • ALL_OBJECTS
          • ALL_PART_INDEXES
          • ALL_PART_KEY_COLUMNS
          • ALL_PART_TABLES
          • ALL_PROCEDURES
          • ALL_PROFILES
          • ALL_SCHEDULER_JOB_ARGS
          • ALL_SCHEDULER_PROGRAM_ARGS
          • ALL_SEQUENCES
          • ALL_SOURCE
          • ALL_SUBPARTITION_TEMPLATES
          • ALL_SUBPART_KEY_COLUMNS
          • ALL_SYNONYMS
          • ALL_TABLES
          • ALL_TAB_COLS
          • ALL_TAB_COLUMNS
          • ALL_TAB_COMMENTS
          • ALL_TAB_PARTITIONS
          • ALL_TAB_PRIVS
          • ALL_TAB_STATS_HISTORY
          • ALL_TAB_SUBPARTITIONS
          • ALL_TRIGGERS
          • ALL_TYPES
          • ALL_TYPE_ATTRS
          • ALL_TYPE_METHODS
          • ALL_USERS
          • ALL_VIEWS
          • ALL_DIRECTORIES
          • ALL_DEPENDENCIES
          • ALL_PART_COL_STATISTICS
          • ALL_PART_HISTOGRAMS
          • ALL_SUBPART_COL_STATISTICS
          • ALL_SUBPART_HISTOGRAMS
          • ALL_TAB_COL_STATISTICS
          • ALL_TAB_HISTOGRAMS
          • ALL_TAB_STATISTICS
          • AUDIT_ACTIONS
          • DBA_ALL_TABLES
          • DBA_ARGUMENTS
          • DBA_AUDIT_EXISTS
          • DBA_AUDIT_OBJECT
          • DBA_AUDIT_SESSION
          • DBA_AUDIT_STATEMENT
          • DBA_AUDIT_TRAIL
          • DBA_COLL_TYPES
          • DBA_COL_COMMENTS
          • DBA_COL_PRIVS
          • DBA_CONSTRAINTS
          • DBA_CONS_COLUMNS
          • DBA_CONTEXT
          • DBA_ERRORS
          • DBA_INDEXES
          • DBA_IND_COLUMNS
          • DBA_IND_EXPRESSIONS
          • DBA_IND_PARTITIONS
          • DBA_IND_SUBPARTITIONS
          • DBA_OB_DATABASES
          • DBA_OB_LS_LOCATIONS
          • DBA_OB_MAJOR_COMPACTION
          • DBA_OB_TABLEGROUP_TABLES
          • DBA_OB_TABLEGROUP_SUBPARTITIONS
          • DBA_OB_TABLEGROUP_PARTITIONS
          • DBA_OB_TABLEGROUPS
          • DBA_OB_TABLET_REPLICAS
          • DBA_OB_TABLET_TO_LS
          • DBA_OB_ZONE_MAJOR_COMPACTION
          • DBA_METHOD_PARAMS
          • DBA_OBJECTS
          • DBA_OBJ_AUDIT_OPTS
          • DBA_PART_INDEXES
          • DBA_PART_KEY_COLUMNS
          • DBA_PART_TABLES
          • DBA_PROCEDURES
          • DBA_PROFILES
          • DBA_ROLES
          • DBA_ROLE_PRIVS
          • DBA_SCHEDULER_JOB_ARGS
          • DBA_SCHEDULER_JOBS
          • DBA_SCHEDULER_PROGRAM
          • DBA_SCHEDULER_PROGRAM_ARGS
          • DBA_SEGMENTS
          • DBA_SOURCE
          • DBA_STMT_AUDIT_OPTS
          • DBA_SUBPARTITION_TEMPLATES
          • DBA_SUBPART_KEY_COLUMNS
          • DBA_SYNONYMS
          • DBA_SYS_PRIVS
          • DBA_TABLES
          • DBA_TABLESPACES
          • DBA_TAB_COLS
          • DBA_TAB_COLUMNS
          • DBA_TAB_COMMENTS
          • DBA_TAB_PARTITIONS
          • DBA_TAB_PRIVS
          • DBA_TAB_STATS_HISTORY
          • DBA_TAB_SUBPARTITIONS
          • DBA_TRIGGERS
          • DBA_TYPES
          • DBA_TYPE_ATTRS
          • DBA_TYPE_METHODS
          • DBA_USERS
          • DBA_VIEWS
          • DBA_RECYCLEBIN
          • DBA_DEPENDENCIES
          • DBA_RSRC_CONSUMER_GROUPS
          • DBA_RSRC_GROUP_MAPPINGS
          • DBA_RSRC_PLANS
          • DBA_RSRC_PLAN_DIRECTIVES
          • DBA_DIRECTORIES
          • DBA_JOBS
          • DBA_JOBS_RUNNING
          • DBA_PART_COL_STATISTICS
          • DBA_PART_HISTOGRAMS
          • DBA_SUBPART_COL_STATISTICS
          • DBA_SUBPART_HISTOGRAMS
          • DBA_TAB_COL_STATISTICS
          • DBA_TAB_HISTOGRAMS
          • DBA_TAB_STATISTICS
          • NLS_DATABASE_PARAMETERS
          • NLS_INSTANCE_PARAMETERS
          • NLS_SESSION_PARAMETERS
          • STMT_AUDIT_OPTION_MAP
          • TENANT_VIRTUAL_GLOBAL_VARIABLE
          • TENANT_VIRTUAL_SESSION_VARIABLE
          • USER_ALL_TABLES
          • USER_ARGUMENTS
          • USER_AUDIT_OBJECT
          • USER_AUDIT_SESSION
          • USER_AUDIT_STATEMENT
          • USER_AUDIT_TRAIL
          • USER_COLL_TYPES
          • USER_COL_COMMENTS
          • USER_COL_PRIVS
          • USER_CONSTRAINTS
          • USER_CONS_COLUMNS
          • USER_ERRORS
          • USER_INDEXES
          • USER_IND_COLUMNS
          • USER_IND_EXPRESSIONS
          • USER_IND_PARTITIONS
          • USER_IND_SUBPARTITIONS
          • USER_OBJECTS
          • USER_PART_INDEXES
          • USER_PART_KEY_COLUMNS
          • USER_PART_TABLES
          • USER_PROCEDURES
          • USER_PROFILES
          • USER_ROLE_PRIVS
          • USER_SEGMENTS
          • USER_SEQUENCES
          • USER_SOURCE
          • USER_SUBPARTITION_TEMPLATES
          • USER_SUBPART_KEY_COLUMNS
          • USER_SYNONYMS
          • USER_SYS_PRIVS
          • USER_TAB_STATS_HISTORY
          • USER_TAB_SUBPARTITIONS
          • USER_TRIGGERS
          • USER_TABLES
          • USER_TABLESPACES
          • USER_TAB_COLS
          • USER_TAB_COLUMNS
          • USER_TAB_COMMENTS
          • USER_TAB_PARTITIONS
          • USER_TAB_PRIVS
          • USER_TYPES
          • USER_TYPE_ATTRS
          • USER_TYPE_METHODS
          • USER_VIEWS
          • USER_JOBS
          • USER_RECYCLEBIN
          • USER_DEPENDENCIES
          • USER_PART_COL_STATISTICS
          • USER_PART_HISTOGRAMS
          • USER_SUBPART_COL_STATISTICS
          • USER_SUBPART_HISTOGRAMS
          • USER_TAB_COL_STATISTICS
          • USER_TAB_HISTOGRAMS
          • USER_TAB_STATISTICS
          • ROLE_TAB_PRIVS
          • ROLE_SYS_PRIVS
          • ROLE_ROLE_PRIVS
          • DICTIONARY
          • DICT
          • DBA_OB_BACKUP_SET_FILES
          • DBA_OB_BACKUP_JOBS
          • DBA_OB_BACKUP_JOB_HISTORY
          • DBA_OB_BACKUP_TASKS
          • DBA_OB_BACKUP_TASK_HISTORY
          • DBA_OB_ARCHIVELOG_PIECE_FILES
          • DBA_OB_RESTORE_PROGRESS
          • DBA_OB_RESTORE_HISTORY
          • DBA_OB_ARCHIVELOG
          • DBA_OB_ARCHIVELOG_SUMMARY
          • DBA_OB_BACKUP_PARAMETER
          • DBA_OB_ARCHIVE_DEST
          • DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • DBA_OB_OUTLINES
          • DBA_OB_CONCURRENT_LIMIT_SQL
          • DBA_OB_BACKUP_DELETE_JOBS
          • DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • DBA_OB_BACKUP_DELETE_TASKS
          • DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • DBA_OB_BACKUP_STORAGE_INFO
          • DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • DBA_OB_BACKUP_DELETE_POLICY
          • DBA_OB_DEADLOCK_EVENT_HISTORY
          • ALL_IND_STATISTICS
          • DBA_IND_STATISTICS
          • USER_IND_STATISTICS
          • ALL_TAB_MODIFICATIONS
          • DBA_TAB_MODIFICATIONS
          • USER_TAB_MODIFICATIONS
          • DBA_SQL_PLAN_BASELINES
          • DBA_SQL_MANAGEMENT_CONFIG
          • USER_SCHEDULER_JOB_ARGS
          • USER_SCHEDULER_PROGRAM_ARGS
          • DBA_OB_LS
          • DBA_OB_TABLE_LOCATIONS
          • DBA_OB_FREEZE_INFO
          • DBA_OB_LS_REPLICA_TASKS
          • DBA_SEQUENCES
          • DBA_SCHEDULER_WINDOWS
          • ALL_SCHEDULER_WINDOWS
          • DBA_OB_DATABASE_PRIVILEGE
          • DBA_OB_USER_DEFINED_RULES
          • DBA_OB_TENANTS
          • DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • DBA_POLICIES
          • ALL_POLICIES
          • USER_POLICIES
          • DBA_POLICY_GROUPS
          • ALL_POLICY_GROUPS
          • USER_POLICY_GROUPS
          • DBA_POLICY_CONTEXTS
          • ALL_POLICY_CONTEXTS
          • USER_POLICY_CONTEXTS
          • DBA_SEC_RELEVANT_COLS
          • ALL_SEC_RELEVANT_COLS
          • USER_SEC_RELEVANT_COLS
          • DBA_OB_LS_ARB_REPLICA_TASKS
          • DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
          • ALL_TRIGGER_ORDERING
          • DBA_TRIGGER_ORDERING
          • USER_TRIGGER_ORDERING
          • DBA_OB_RSRC_IO_DIRECTIVES
          • ALL_DB_LINKS
          • DBA_DB_LINKS
          • USER_DB_LINKS
          • DBA_OB_DATA_DICTIONARY_IN_LOG
          • DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • DBA_OB_LOG_RESTORE_SOURCE
          • DBA_OB_TABLE_STAT_STALE_INFO
          • DBA_OB_EXTERNAL_TABLE_FILES
          • ALL_OB_EXTERNAL_TABLE_FILES
          • DBA_OB_BALANCE_JOBS
          • DBA_OB_BALANCE_JOB_HISTORY
          • DBA_OB_BALANCE_TASKS
          • DBA_OB_BALANCE_TASK_HISTORY
          • DBA_OB_TRANSFER_TASKS
          • DBA_OB_TRANSFER_TASK_HISTORY
          • DBA_OB_ACCESS_POINT
          • DBA_OB_LS_HISTORY
          • DBA_OB_TENANT_EVENT_HISTORY
        • Performance views
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_KVCACHE
          • GV$OB_PARAMETERS
          • GV$OB_PROCESSLIST
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_UNITS
          • GV$DBLINK
          • GV$INSTANCE
          • GV$OB_MEMORY
          • GV$OB_PX_WORKER_STAT
          • GV$OB_MEMSTORE
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$OB_SQL_AUDIT
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSTEM_EVENT
          • GV$GLOBAL_TRANSACTION
          • GV$OB_SSTABLES
          • GV$OB_TENANT_MEMORY
          • V$GLOBALCONTEXT
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_KVCACHE
          • V$OB_PARAMETERS
          • V$OB_PROCESSLIST
          • V$OB_PX_TARGET_MONITOR
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_UNITS
          • V$DBLINK
          • V$INSTANCE
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$NLS_PARAMETERS
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PX_WORKER_STAT
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$OB_SQL_AUDIT
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$SYSTEM_EVENT
          • V$VERSION
          • V$SQL_MONITOR_STATNAME
          • V$GLOBAL_TRANSACTION
          • V$TIMEZONE_NAMES
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$RSRC_PLAN
          • V$OB_SSTABLES
          • V$OB_TENANT_MEMORY
          • GV$OB_MEMSTORE_INFO
          • V$OB_MEMSTORE_INFO
          • GV$SYSSTAT
          • V$SYSSTAT
          • V$EVENT_NAME
          • GV$ACTIVE_SESSION_HISTORY
          • V$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • V$DML_STATS
          • GV$OB_LOG_STAT
          • V$OB_LOG_STAT
          • GV$SQL_PLAN_MONITOR
          • V$SQL_PLAN_MONITOR
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_GLOBAL_TRANSACTION
          • V$OB_GLOBAL_TRANSACTION
          • V$OB_LS_REPLICA_TASK_PLAN
          • GV$OPEN_CURSOR
          • V$OPEN_CURSOR
          • V$OB_ARCHIVE_DEST_STATUS
          • GV$OB_LOG_STAT
          • GV$OB_THREAD
          • V$OB_THREAD
          • GV$OB_ARBITRATION_SERVICE_STATUS
          • V$OB_ARBITRATION_SERVICE_STATUS
          • GV$OB_ARBITRATION_MEMBER_INFO
          • V$OB_ARBITRATION_MEMBER_INFO
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_LOCKS
          • V$OB_LOCKS
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_TIMESTAMP_SERVICE
          • GV$OB_PX_P2P_DATAHUB
          • V$OB_PX_P2P_DATAHUB
          • GV$SQL_JOIN_FILTER
          • V$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • V$OB_SQL_PLAN
      • Common statistics events
    • Parameters and variables
      • Overview
      • Parameters
        • Overview
        • Cluster-level parameters
          • all_cluster_list
          • all_server_list
          • auto_broadcast_location_cache_rate_limit
          • auto_leader_switch_interval
          • auto_refresh_location_cache_rate_limit
          • autoinc_cache_refresh_interval
          • backup_backup_dest
          • backup_backup_dest_option
          • backup_dest_option
          • backup_concurrency
          • backup_dest
          • backup_data_file_size
          • backup_log_archive_option
          • backup_net_limit
          • backup_recovery_window
          • backup_region
          • backup_zone
          • balance_blacklist_failure_threshold
          • balance_blacklist_retry_interval
          • balancer_emergency_percentage
          • balancer_log_interval
          • balancer_task_timeout
          • balancer_timeout_check_interval
          • balancer_tolerance_percentage
          • bf_cache_miss_count_threshold
          • bf_cache_priority
          • builtin_db_data_verify_cycle
          • cache_wash_threshold
          • clog_disk_utilization_threshold
          • clog_expire_days
          • clog_cache_priority
          • clog_disk_usage_limit_percentage
          • clog_sync_time_warn_threshold
          • clog_transport_compress_func
          • cpu_reserved
          • cluster
          • cluster_id
          • config_additional_dir
          • cpu_count
          • data_copy_concurrency
          • data_dir
          • data_disk_usage_limit_percentage
          • data_storage_error_tolerance_time
          • data_storage_warning_tolerance_time
          • datafile_disk_percentage
          • datafile_size
          • dead_socket_detection_timeout
          • debug_sync_timeout
          • default_compress
          • default_compress_func
          • default_transport_compress_func
          • default_row_format
          • devname
          • disk_io_thread_count
          • dtl_buffer_size
          • election_cpu_quota
          • election_blacklist_interval
          • enable_async_syslog
          • enable_auto_refresh_location_cache
          • enable_auto_leader_switch
          • enable_ddl
          • enable_global_freeze_trigger
          • enable_log_archive
          • enable_election_group
          • enable_major_freeze
          • enable_merge_by_turn
          • enable_manual_merge
          • enable_ob_ratelimit
          • enable_one_phase_commit
          • enable_perf_event
          • enable_pg
          • enable_record_trace_id
          • enable_record_trace_log
          • enable_rereplication
          • enable_rich_error_msg
          • enable_separate_sys_clog
          • enable_smooth_leader_switch
          • enable_rootservice_standalone
          • enable_sql_audit
          • enable_sql_operator_dump
          • enable_sys_table_ddl
          • enable_sys_unit_standalone
          • enable_syslog_recycle
          • enable_syslog_wf
          • enable_tcp_keepalive
          • fast_recovery_concurrency
          • enable_upgrade_mode
          • flush_log_at_trx_commit
          • gc_wait_archive
          • fuse_row_cache_priority
          • global_index_build_single_replica_timeout
          • global_major_freeze_residual_memory
          • get_leader_candidate_rpc_timeout
          • global_write_halt_residual_memory
          • high_priority_net_thread_count
          • ignore_replay_checksum_error
          • ignore_replica_checksum_error
          • index_clog_cache_priority
          • index_info_block_cache_priority
          • index_cache_priority
          • ilog_index_expire_time
          • internal_sql_execute_timeout
          • large_query_threshold
          • large_query_worker_percentage
          • leak_mod_to_check
          • lease_time
          • location_cache_cpu_quota
          • location_cache_priority
          • location_cache_expire_time
          • location_cache_refresh_min_interval
          • location_cache_refresh_rpc_timeout
          • location_cache_refresh_sql_timeout
          • location_fetch_concurrency
          • location_refresh_thread_count
          • log_archive_batch_buffer_limit
          • log_archive_checkpoint_interval
          • max_kept_major_version_number
          • max_px_worker_count
          • max_string_print_length
          • max_syslog_file_count
          • memory_chunk_cache_size
          • memory_limit
          • memory_limit_percentage
          • memory_reserved
          • memstore_limit_percentage
          • merge_stat_sampling_ratio
          • merge_thread_count
          • merger_completion_percentage
          • merger_switch_leader_duration_time
          • merger_warm_up_duration_time
          • micro_block_merge_verify_level
          • migrate_concurrency
          • migration_disable_time
          • min_observer_version
          • minor_deferred_gc_time
          • mysql_port
          • net_thread_count
          • ob_event_history_recycle_interval
          • ob_ratelimit_stat_period
          • obconfig_url
          • tablet_meta_table_check_interval
          • tablet_meta_table_scan_batch_count
          • plan_cache_evict_interval
          • plan_cache_high_watermark
          • plan_cache_low_watermark
          • px_task_size
          • px_workers_per_cpu_quota
          • rdma_io_thread_count
          • recyclebin_object_expire_time
          • ls_meta_table_check_interval
          • resource_hard_limit
          • rebuild_replica_data_lag_threshold
          • rootservice_async_task_queue_size
          • rootservice_async_task_thread_count
          • rootservice_list
          • rootservice_memory_limit
          • rootservice_ready_check_interval
          • row_compaction_update_limit
          • rpc_port
          • rpc_timeout
          • schema_history_expire_time
          • schema_history_recycle_interval
          • server_balance_cpu_mem_tolerance_percent
          • server_balance_critical_disk_waterlevel
          • server_balance_disk_tolerance_percent
          • server_check_interval
          • server_cpu_quota_max
          • server_cpu_quota_min
          • server_permanent_offline_time
          • server_data_copy_out_concurrency
          • server_data_copy_in_concurrency
          • ssl_client_authentication
          • ssl_external_kms_info
          • stack_size
          • sql_audit_memory_limit
          • sys_bkgd_migration_change_member_list_timeout
          • sys_bkgd_migration_retry_num
          • sys_bkgd_net_percentage
          • switchover_process_thread_count
          • syslog_io_bandwidth_limit
          • sys_bkgd_io_high_percentage
          • syslog_level
          • sys_bkgd_io_low_percentage
          • sys_cpu_limit_trigger
          • system_memory
          • system_trace_level
          • tableapi_transport_compress_func
          • tablet_size
          • tcp_keepcnt
          • system_cpu_quota
          • tcp_keepidle
          • tcp_keepintvl
          • tenant_cpu_variation_per_server
          • tenant_task_queue_size
          • token_reserved_percentage
          • trace_log_sampling_interval
          • trace_log_slow_query_watermark
          • trx_2pc_retry_interval
          • tenant_groups
          • use_large_pages
          • user_block_cache_priority
          • trx_force_kill_threshold
          • user_row_cache_priority
          • trx_try_wait_lock_timeout
          • unit_balance_resource_weight
          • virtual_table_location_cache_expire_time
          • weak_read_version_refresh_interval
          • user_iort_up_percentage
          • workers_per_cpu_quota
          • zone
          • user_tab_col_stat_cache_priority
          • wait_leader_batch_count
          • log_disk_size
          • log_disk_percentage
          • tablet_ls_cache_priority
          • opt_tab_stat_cache_priority
          • zone_merge_concurrency
          • index_block_cache_priority
          • zone_merge_order
          • sql_login_thread_count
          • zone_merge_timeout
          • enable_asan_for_memory_context
          • ob_esi_rpc_port
          • enable_cgroup
          • enable_ob_esi_process
          • diag_syslog_per_error_limit
          • ob_esi_session_timeout
          • ob_esi_io_concurrency
          • ob_startup_mode
          • ob_esi_memory_limit
          • log_storage_warning_tolerance_time
          • ob_esi_syslog_level
          • ob_esi_max_syslog_file_count
          • sql_net_thread_count
          • minor_freeze_times
          • minor_merge_concurrency
          • minor_warm_up_duration_time
          • multiblock_read_gap_size
          • multiblock_read_size
          • ofs_list
          • partition_table_check_interval
          • replica_safe_remove_time
          • resource_soft_limit
          • restore_concurrency
          • rpc_client_authentication_method
          • rpc_server_authentication_method
          • row_purge_thread_count
          • datafile_maxsize
          • datafile_next
          • standby_fetch_log_bandwidth_limit
          • local_ip
          • observer_id
          • storage_meta_cache_priority
        • Tenant-level parameters
          • audit_sys_operations
          • audit_trail
          • clog_max_unconfirmed_log_count
          • clog_persistence_compress_func
          • connection_control_failed_connections_threshold
          • connection_control_min_connection_delay
          • connection_control_max_connection_delay
          • enable_clog_persistence_compress
          • enable_early_lock_release
          • enable_monotonic_weak_read
          • external_kms_info
          • enable_sql_extension
          • default_progressive_merge_num
          • io_category_config
          • log_disk_utilization_limit_threshold
          • log_disk_utilization_threshold
          • major_compact_trigger
          • compaction_low_thread_score
          • max_stale_time_for_weak_consistency
          • compaction_high_thread_score
          • minor_compact_trigger
          • compaction_mid_thread_score
          • ob_enable_batched_multi_statement
          • ob_proxy_readonly_transaction_routing_policy
          • ob_ssl_invited_common_names
          • open_cursors
          • plsql_code_type
          • plsql_debug
          • plsql_optimize_level
          • plsql_warnings
          • sql_work_area
          • tde_method
          • writing_throttling_maximum_duration
          • writing_throttling_trigger_percentage
          • workarea_size_policy
          • plsql_v2_compatibility
          • job_queue_processes
          • ha_high_thread_score
          • ha_mid_thread_score
          • ha_low_thread_score
          • ob_compaction_schedule_interval
          • default_auto_increment_mode
          • ob_query_switch_leader_retry_timeout
          • default_enable_extended_rowid
          • major_freeze_duty_time
          • undo_retention
          • query_response_time_stats
          • query_response_time_flush
          • query_response_time_range_base
          • merger_check_interval
          • freeze_trigger_percentage
          • cpu_quota_concurrency
          • arbitration_timeout
          • compatible
          • log_transport_compress_all
          • log_transport_compress_func
          • rpc_memory_limit_percentage
          • tenant_sql_login_thread_count
          • tenant_sql_net_thread_count
          • dump_data_dictionary_to_log_interval
          • enable_user_defined_rewrite_rules
          • partition_balance_schedule_interval
          • log_disk_throttling_percentage
          • enable_rebalance
          • balancer_idle_time
          • log_disk_throttling_maximum_duration
          • ls_gc_delay_time
          • standby_db_preferred_upstream_log_region
          • archive_lag_target
          • range_optimizer_max_mem_size
          • log_restore_concurrency
          • log_archive_concurrency
          • standby_db_fetch_log_rpc_timeout
      • System variables
        • System variable summary
        • Global variables
          • auto_increment_cache_size
          • auto_increment_increment
          • auto_increment_offset
          • autocommit
          • binlog_row_image
          • block_encryption_mode
          • character_set_client
          • character_set_connection
          • character_set_database
          • character_set_filesystem
          • character_set_results
          • character_set_server
          • character_set_system
          • collation_connection
          • collation_database
          • collation_server
          • connect_timeout
          • cursor_sharing
          • datadir
          • debug_sync
          • default_password_lifetime
          • div_precision_increment
          • error_on_overlap_time
          • explicit_defaults_for_timestamp
          • foreign_key_checks
          • group_concat_max_len
          • identity
          • init_connect
          • innodb_strict_mode
          • interactive_timeout
          • license
          • lower_case_table_names
          • max_allowed_packet
          • max_connections
          • max_sp_recursion_depth
          • max_user_connections
          • net_buffer_length
          • net_read_timeout
          • net_write_timeout
          • nls_calendar
          • nls_characterset
          • nls_comp
          • nls_currency
          • nls_date_format
          • nls_date_language
          • nls_dual_currency
          • nls_iso_currency
          • nls_length_semantics
          • nls_nchar_characterset
          • nls_nchar_conv_excp
          • nls_numeric_characters
          • nls_sort
          • nls_territory
          • nls_timestamp_format
          • nls_timestamp_tz_format
          • ob_bnl_join_cache_size
          • ob_create_table_strict_mode
          • ob_default_replica_num
          • ob_compatibility_mode
          • ob_enable_blk_nestedloop_join
          • ob_early_lock_release
          • ob_enable_hash_group_by
          • ob_enable_aggregation_pushdown
          • ob_enable_index_direct_select
          • ob_enable_jit
          • ob_enable_plan_cache
          • ob_enable_sql_audit
          • ob_enable_transformation
          • ob_enable_transmission_checksum
          • ob_enable_truncate_flashback
          • ob_global_debug_sync
          • ob_log_level
          • ob_pl_block_timeout
          • ob_plan_cache_evict_high_percentage
          • ob_plan_cache_evict_low_percentage
          • ob_plan_cache_percentage
          • ob_proxy_global_variables_version
          • ob_query_timeout
          • ob_read_consistency
          • ob_reserved_meta_memory_percentage
          • ob_route_policy
          • ob_sql_audit_percentage
          • ob_sql_work_area_percentage
          • ob_tcp_invited_nodes
          • ob_temp_tablespace_size_percentage
          • ob_timestamp_service
          • ob_trx_idle_timeout
          • ob_trx_lock_timeout
          • ob_trx_timeout
          • optimizer_capture_sql_plan_baselines
          • optimizer_use_sql_plan_baselines
          • parallel_max_servers
          • parallel_servers_target
          • performance_schema
          • plugin_dir
          • query_cache_size
          • query_cache_type
          • read_only
          • recyclebin
          • resource_manager_plan
          • secure_file_priv
          • sql_auto_is_null
          • sql_mode
          • sql_quote_show_create
          • sql_safe_updates
          • sql_select_limit
          • sql_throttle_current_priority
          • sql_throttle_network
          • sql_throttle_priority
          • sql_throttle_rt
          • sql_warnings
          • system_time_zone
          • time_zone
          • transaction_isolation
          • transaction_read_only
          • tx_isolation
          • tx_read_only
          • version
          • version_comment
          • wait_timeout
          • validate_password_check_user_name
          • validate_password_length
          • validate_password_mixed_case_count
          • validate_password_number_count
          • validate_password_policy
          • validate_password_special_char_count
          • server_uuid
          • default_storage_engine
          • ob_enable_rich_error_msg
          • cte_max_recursion_depth
          • regexp_stack_limit
          • event_scheduler
          • regexp_time_limit
          • log_row_value_options
          • ob_max_read_stale_time
          • parallel_degree_policy
          • parallel_degree_limit
          • parallel_min_scan_time_threshold
          • optimizer_dynamic_sampling
          • runtime_filter_type
          • runtime_filter_wait_time_ms
          • runtime_filter_max_in_num
          • runtime_bloom_filter_max_size
        • Session-level variables
          • is_result_accurate
          • last_insert_id
          • nls_language
          • ob_capability_flag
          • ob_enable_show_trace
          • ob_last_schema_version
          • ob_org_cluster_id
          • ob_proxy_partition_hit
          • ob_proxy_set_trx_executed
          • ob_trace_info
          • timestamp
          • tracefile_identifier
          • ob_max_read_stale_time
          • parallel_degree_policy
          • parallel_degree_limit
          • parallel_min_scan_time_threshold
          • optimizer_dynamic_sampling
          • runtime_filter_type
          • runtime_filter_wait_time_ms
          • runtime_filter_max_in_num
          • runtime_bloom_filter_max_size
    • Error codes
      • MySQL mode
        • Overview
        • 0001 - 3999
        • 4000 - 4499
        • 4500 - 4999
        • 5000 - 5999
        • 6000 - 6999
        • 7000 - 7999
        • 8000 - 8999
        • 9000 - 9499
        • 9500 - 9999
        • 22998, 30926, 38104, and 38105
      • Oracle mode
        • Overview
        • ORA-00000 to ORA-00999
        • ORA-01000 to ORA-01499
        • ORA-01500 to ORA-01999
        • ORA-02000 to ORA-04999
        • ORA-05000 to ORA-10000
        • ORA-10000 to ORA-19999
        • ORA-20000 to ORA-29999
        • ORA-30000 to ORA-49999
        • ORA-50000 to ORA-99999
        • PLS-00000 to PLS-00999
    • Performance tuning
      • Overview
      • Performance related tools
        • System tools
          • General tool Top
          • CPU tools
          • Memory tools
          • Disk I/O tools
          • Network tools
        • Internal tables
          • GV$SYSSTAT
          • GV$OB_SQL_AUDIT
          • GV$OB_TRANSACTION_PARTICIPANTS
        • Logs
          • slow trans
          • dump tenant info
          • trace log
        • OCP
      • System tuning
        • OS parameter tuning
        • Database parameter tuning
          • CPU parameters
          • I/O parameters
          • Memory-related parameters
          • Network transmission parameters
        • ODP parameter tuning
          • CPU parameters
          • Network transmission parameters
          • Route parameters on nodes
      • Business model tuning
        • Load Balancer
        • SQL Diagnostics
        • Distributed transactions
      • Performance diagnosis
        • Monitor and diagnose the cluster performance
        • Diagnose tenant performance
        • Monitor OBProxy performance
        • Monitor host performance
        • ASH report
          • ASH
          • Generate ASH reports
          • Analyze ASH reports
      • SQL tuning
        • SQL request execution process
        • SQL execution plans
          • Introduction to SQL execution plans
          • Execution plan operators
            • TABLE SCAN
            • JOIN
            • COUNT
            • GROUP BY
            • WINDOW FUNCTION
            • SUBPLAN FILTER
            • DISTINCT
            • SEQUENCE
            • MATERIAL
            • SORT
            • LIMIT
            • FOR UPDATE
            • SELECT INTO
            • SUBPLAN SCAN
            • UNION
            • INTERSECT
            • EXCEPT/MINUS
            • INSERT
            • DELETE
            • UPDATE
            • MERGE
            • EXCHANGE
            • GI
          • Plan cache
          • Fast parameterization
          • Display real-time execution plans
          • SQL optimization practice with EXPLAIN
        • Distributed execution plans
          • Perform distributed execution and parallel queries
          • Generate a distributed plan
          • Schedule distributed execution plans
          • Manage distributed execution plans
          • Enable parallel execution and set the degree of parallelism
          • Auto DOP
          • Execute parallel queries
          • Perform parameter tuning for a parallel query
          • Parallel DML
        • SQL tuning
          • Overview of SQL tuning
          • General procedure of SQL tuning
          • SQL execution performance monitoring
            • GV$OB_SQL_AUDIT
            • SQL Trace
            • Plan cache views
            • SQL performance analysis example
              • Use SQL Audit to analyze wait events in a query
              • Analyze SQL queries that cause an abrupt RT jitter
              • View and analyze the shape of an execution plan
              • Analyze slow SQL queries
              • Query the distribution of SQL traffic and QPS among OBServer nodes
              • Check whether SQL queries are balanced across servers in a cluster
              • Find the TOP N SQL queries
              • Analyze whether an unusually large number of remote execution requests exist in the system or the execution of an SQL statement
              • Find full table scan SQL statements in a tenant
              • Find the TOP N queries with the longest execution time within a specified period
              • Analyze queries related to distributed plans
              • Check whether the RPC execution count of a distributed subplan is balanced across servers in a cluster
          • Optimizer statistics
            • Overview of statistics
            • Statistics collection methods
              • Overview
              • Histograms
              • Manual statistics collection
              • Automatic statistics collection
              • Online statistics collection
              • Dynamic sampling
            • Statistics management
              • Overview
              • Deletion
              • Setting
              • Import and export
              • Locking and unlocking
              • History management
              • Statistics preference management
            • Monitoring and diagnostics for statistics collection
            • Examples
          • Query rewrite
            • Overview
            • Rule-based query rewriting
            • Cost-based query rewrite
          • Query optimization
            • Access path
              • Overview
              • Rule-based path selection
              • Cost-based path selection
            • Join algorithm
              • Overview
              • Join algorithms
              • Runtime filter
              • Join order
          • Manage execution plans
            • Optimizer hints
            • Plan binding
            • SQL plan management
        • Glossary
        • General issues in SQL tuning
    • Performance test
      • Run the TPC-H benchmark on OceanBase Database
      • TPC-H benchmark report of OceanBase Database
      • Run the Sysbench benchmark on OceanBase Database
      • Sysbench benchmark report of OceanBase Database
      • Achieve high performance with Sysbench on OceanBase Database: deployment and troubleshooting
      • Run the TPC-C benchmark on OceanBase Database
      • TPC-C benchmark report of OceanBase Database
    • Database proxy
      • OceanBase Database Proxy
      • Overview
      • ODP
        • Overview
        • Manage ODP clusters
          • Create an ODP cluster
          • Manage ODP cluster parameters
          • Delete an ODP cluster
          • Upgrade all ODPs in an ODP cluster
          • Restart all ODPs in an ODP cluster
          • Manage OceanBase clusters connected to an ODP cluster
          • Monitor ODP cluster performance
        • Manage ODP
          • Add an ODP
          • Start an ODP
          • Refresh ODP configurations
          • Stop an ODP
          • Restart an ODP
          • Delete an ODP
          • Upgrade one or more ODPs
        • ODP startup parameters
      • Physical connections
      • Logical connection
        • Query all sessions
        • Query the details of a session
        • Query the metrics of a session
        • Query session variables
        • Terminate a server session
      • Route management
        • Table-based routing of ODP
        • LDC-based routing
        • ODP routing policy
          • Read/Write splitting
          • Follower-first read
          • Blocklist mechanism
          • Transaction routing
      • View tenant sessions
      • Terminate a tenant session
      • Set the maximum number of connections for a tenant
    • Drivers
      • ECOB
      • OBCI
      • OceanBase Connector/J
      • OceanBase Connector/C
      • OceanBase Connector/ODBC
    • Platforms
      • OMA
      • OMS
      • OCP
      • ODC
      • OAT
    • Components & tools
      • O&M management
        • ob_admin
          • Overview
          • clog
            • log_tool
            • Format of clogs
            • Transaction logs
          • dumpsst
          • dump_backup
        • ob_error
        • OBD
        • ob-operator
          • Overview
          • Quick start
          • Deploy ob-operator
          • Upgrade ob-operator
          • User guide
            • Manage clusters
              • Create a cluster
              • Scale out clusters
                • Add zones to a cluster
                • Add OBServer nodes to zones
              • Scale in clusters
                • Delete zones from a cluster
                • Delete OBServer nodes from zones
              • Delete a cluster
              • Upgrade a cluster
            • Manage tenants
              • Create a tenant
              • Modify tenants
                • Manage resources
                • Manage replicas
                • Modify other parameters
              • Delete a tenant
            • Backup and restore
              • Back up a cluster
              • Back up a tenant
              • Restore data from a backup
      • Monitoring and diagnostics
        • obdiag
        • SQL diagnoser
          • Overview
          • Deploy and use SQL diagnoser
            • Install SQL Diagnoser
            • Use SQL Diagnoser
          • SQL diagnoser remarks
            • Built-in diagnostic items
            • Diagnostic rule expression
            • APIs
            • Diagnostic items of SQL review
        • DOOBA
      • Data integration
        • OBLOADER & OBDUMPER
        • Partition calculator
          • Overview
          • Use the ob-partition-calculator component
        • CDC
          • Overview
          • obcdc
            • Deploy and use obcdc
              • Install and deploy obcdc
              • obcdc development instructions
              • obcdc_tailf
            • obcdc parameters
              • General obcdc parameters
              • obcdc parameters
            • FAQ about obcdc
          • oblogproxy
            • Deploy oblogproxy
              • Install and deploy oblogproxy by using the installation package
              • Build oblogproxy by using the source code
            • Configuration files
          • oblogmsg
            • Install and deploy oblogmsg
            • Description of some oblogmsg APIs
      • Stress testing tools
        • mysqltest
          • Use obd.sh to run mysqltest
          • Use of cases
            • Add a test case
            • Test case writing conventions
            • General test case writing commands
  • FAQ
    • FAQs
    • SQL statements
    • Deployment
    • Cluster management
    • High availability
  • Release Notes
    • Version rules
    • OceanBase Database Enterprise Edition
      • V4.2
        • OceanBase Database Enterprise Edition V4.2.0
      • V4.1
        • OceanBase Database Enterprise Edition V4.1.0
      • V3.2
        • OceanBase Database Enterprise Edition V3.2.4
        • OceanBase Database Enterprise Edition V3.2.3
        • OceanBase Database Enterprise Edition V3.2.2
        • OceanBase Database Enterprise Edition V3.2.1
        • OceanBase Database Enterprise Edition V3.2.0
      • V3.1
        • OceanBase Database Enterprise Edition V3.1.2
        • OceanBase Database Enterprise Edition V3.1.1
      • V2.2
        • OceanBase Database Enterprise Edition V2.2.77
        • OceanBase Database Enterprise Edition V2.2.76
        • OceanBase Database Enterprise Edition V2.2.30
    • OceanBase Database Community Edition
      • V4.2
        • OceanBase Database Community Edition V4.2.0
      • V4.1
        • OceanBase Database Community Edition V4.1.0
      • V4.0
        • OceanBase Database Community Edition V4.0.0
      • V3.1
        • OceanBase Database Community Edition V3.1.5
        • OceanBase Database Community Edition V3.1.4
        • OceanBase Database Community Edition V3.1.3
        • OceanBase Database Community Edition V3.1.2
        • OceanBase Database Community Edition V3.1.1
  • Glossary

Download PDF

Overview Differences between the Enterprise Edition and the Community Edition System architecture Overview SQL data types Built-in functions System views Compatibility with MySQL Limitations Get started with OceanBase Database Before you begin Basic SQL operations (MySQL mode) Basic SQL operations (Oracle mode) Build a Python application Build a Java application Build a C application Build a Go application Build a Java application Build a C application Try out operational OLAP Try out parallel import and data compression Try out the multi-tenant feature Video tutorials Overview High availability deployment solutions for OceanBase clusters Deployment process Overview Deploy OceanBase Database in a Kubernetes cluster Clear out an old cluster Overview Use OMS to migrate data from a MySQL database to a MySQL tenant of OceanBase Database Use mydumper and myloader to migrate data from a MySQL database to OceanBase Database Use DBCAT to migrate schemas from a MySQL database to OceanBase Database Use DataX to migrate table data from a MySQL database to OceanBase Database Use CloudCanal to migrate data from a MySQL database to OceanBase Database Use Canal to synchronize data from a MySQL database to OceanBase Database Use Flink CDC to synchronize data from a MySQL database to OceanBase Database Use ChunJun to migrate data from a MySQL database to OceanBase Database Use OMS to migrate data from a MySQL tenant of OceanBase Database to a MySQL database Use OMS to migrate incremental data from an Oracle tenant of OceanBase Database to a MySQL database Use DBCAT to migrate schemas from OceanBase Database to a MySQL database Use DataX to migrate table data from OceanBase Database to a MySQL database Synchronize data from OceanBase Database to a MySQL database using Canal Migrate data from a MySQL OceanBase database to a MySQL database using CloudCanal Use Flink CDC to migrate data from OceanBase Database to a MySQL database Migrate data from a MySQL database in OceanBase Database to a MySQL database using ChunJun Use OMS to migrate data from an Oracle database to a MySQL tenant of OceanBase Database Use OMS to migrate data from an Oracle database to an Oracle tenant of OceanBase Database Use DBCAT to migrate schemas from an Oracle database to OceanBase Database Use DataX to migrate table data from an Oracle database to OceanBase Database Use OMS to migrate data from an Oracle tenant of OceanBase Database to an Oracle database Use DBCAT to migrate schemas from OceanBase Database to an Oracle database Use DataX to migrate table data from OceanBase Database to an Oracle database Use OMS to migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database Use OMS to migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database Use DBCAT to migrate table schemas from a DB2 LUW database to OceanBase Database Use OMS to migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database Use OMS to migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database Use OMS to migrate data from a TiDB database to a MySQL tenant of OceanBase Database Use OMS to migrate data from a PostgreSQL database to a MySQL tenant of OceanBase Database Use DataX to migrate CSV files to OceanBase Database Import data by using the LOAD DATA statement Import data from SQL files to OceanBase Database Use OMS to migrate data from an OceanBase Database tenant to another of the same type Use OMS to migrate data from an OceanBase Database tenant to another of the same type in active-active disaster recovery scenarios Use OBLOADER & OBDUMPER to migrate data between MySQL tenants in OceanBase Database Use OBLOADER & OBDUMPER to migrate data from a MySQL tenant to an Oracle tenant in OceanBase Database Use OBLOADER & OBDUMPER to migrate data between Oracle tenants in OceanBase Database Use OBLOADER & OBDUMPER to migrate data from an Oracle tenant to a MySQL tenant in OceanBase Database Migrate data between tables Migrate resource units Export data by using OUTFILE statements Overview of direct load Import data in bypass mode by using the LOAD DATA statement Import data in bypass mode by using the INSERT INTO SELECT statement Log on to an OceanBase Database tenant Overview Cluster parameters Tenants Tenant capacity Tenant types User tenants System variables of a tenant Overview Traffic distribution Data distribution Overview Flashback queries Overview Introduction to physical backup and restore Deploy NFS Overview Cases Overview Log levels Log stability Log control Log metrics Overview Check cluster parameters
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogLive DemosTraining & Certification
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Database
  3. SQL
  4. V4.2.0
iconOceanBase Database
SQL - V 4.2.0
SQL
KV
  • V 4.4.2
  • V 4.3.5
  • V 4.3.3
  • V 4.3.1
  • V 4.3.0
  • V 4.2.5
  • V 4.2.2
  • V 4.2.1
  • V 4.2.0
  • V 4.1.0
  • V 4.0.0
  • V 3.1.4 and earlier

4000 - 4499

Last Updated:2023-12-01 03:27:20  Updated
share
What is on this page
ERROR 4000 (HY000): Common error
ERROR 4001 (HY004): Object type error
ERROR 4003 (42000): Array index out of range
ERROR 4004 (08S01): Failed to listen to the port
ERROR 4005 (HY000): The object is initialized twice
ERROR 4006 (HY000): The object is not initialized
ERROR 4008 ( HY000 ): End of iteration
ERROR 4009 (58030 ): IO error
ERROR 4010 (HY000): Wrong RPC command version
ERROR 4012 (HY000): Timeout, query has reached the maximum query timeout: %ld(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again
ERROR 4012 (HY000): Task timeout and not executed
ERROR 4012 (HY000): RPC session not found
ERROR 4012 (HY000): RPC send error
ERROR 4012 (HY000): RPC post error
ERROR 4012 (HY000): Timeout
ERROR 4012 (HY000): Statement is timeout
ERROR 4012 (25000): Transaction timeout occurred, please rollback the transaction, set the variable ob_trx_timeout to a larger value and then restart the transaction
ERROR 4012 (25000): Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement
ERROR 4012 (25000): Transaction result isunknown
ERROR 4012 (25000): transaction rpc timeout
ERROR 4013 (HY001): No memory or reach tenant memory limit
ERROR 4014 (HY000): Inner state error
ERROR 4015 (HY000): System error
ERROR 4016 (HY000): Internal error
ERROR 4017 (HY000): Entry already exist
ERROR 4018 (HY000): Entry not exist
ERROR 4019 (HY000): Size overflow
ERROR 4020 (HY000): Reference count is not zero
ERROR 4021 (HY000): Conflict value
ERROR 4022 (HY000): Item not set
ERROR 4023 (HY000): Try again
ERROR 4024 (HY000): Buffer not enough
ERROR 4025 (HY000): Partial failed
ERROR 4026 (02000): Nothing to read
ERROR 4028 (HY000): Log entry not continuous
ERROR 4029 (HY000): Schema error
ERROR 4030 (HY000): Over tenant memory limits
ERROR 4031 (HY004): Unknown object
ERROR 4033 (HY000): Serialize error
ERROR 4034 (HY000): Deserialize error
ERROR 4035 (HY000): Asynchronous IO error
ERROR 4036 (HY000): Need retry
ERROR 4037 (HY000): Too many sstable
ERROR 4038 (HY000): The observer or zone is not the master
ERROR 4039 (HY000): Request has killed by sql throttle
ERROR 4041 (HY000): Decrypt error
ERROR 4045 (HY000): pushdown status changed
ERROR 4046 (HY000): Storage schema is not valid
ERROR 4047 (HY000): Medium compaction info is not valid
ERROR 4048 (HY000): Not registered
ERROR 4050 (HY000): Not the object
ERROR 4052 (HY000): Corrupted log entry
ERROR 4055 (HY000): Invalid entry
ERROR 4057 (HY000): Decimal overflow warning
ERROR 4058 (HY000): Decimal overflow error
ERROR 4060 (HY000): Divide error
ERROR 4061 (HY000): Not a decimal
ERROR 4062 (HY104): Decimal precision error
ERROR 4063 (HY000): Empty range
ERROR 4064 (HY000): Session killed
ERROR 4065 (HY000): Log not sync
ERROR 4068 (HY000): Invalid log
ERROR 4070 (HY000): Invalid data
ERROR 4071 (HY000): Already done
ERROR 4072 (HY000): Operation canceled
ERROR 4074 (HY000): Log not aligned
ERROR 4075 (HY000): Log entry missed
ERROR 4076 (HY000): Need wait
ERROR 4077 (0A000): Not implemented feature
ERROR 4080 (HY013): exceed memory limit
ERROR 4084 (02000): No result
ERROR 4085 (HY000): Queue overflow
ERROR 4090 (HY000): Table log_id range no continuous
ERROR 4098 (HY000): Term not match
ERROR 4103 (42000): Data checksum error
ERROR 4104 (HY000): Initialize error
ERROR 4105 (HY000): Rowkey order error
ERROR 4107 (HY000): block switched when fill commitlog
ERROR 4108 (HY000): Physic data checksum error
ERROR 4109 (HY000): Server state or role not the same as expected
ERROR 4111 (HY000): block need freeze
ERROR 4112 (HY000): block frozen
ERROR 4113 (HY000): In FATAL state
ERROR 4114 (08S01): In STOP state
ERROR 4119 (08000): RPC packet to send too long
ERROR 4120 (HY000): Log too large
ERROR 4123 (08000): Libeasy error
ERROR 4124 (HY000): Connect error
ERROR 4128 (HY000): RPC packet is invalid
ERROR 4138 (HY000): Request to read too old versioned data
ERROR 4143 (42000): Version not match
ERROR 4147 (HY000): Invalid config
ERROR 4150 (42000): Min value
ERROR 4151 (42000): Max value
ERROR 4152 (42000): Null value
ERROR 4154 (HY000): Internal SQL client error
ERROR 4161 (42000): Invalid argument num
ERROR 4162 (HY000): reserved lease not enough
ERROR 4165 (HY000): Empty result
ERROR 4168 (HY000): Invalid log module id
ERROR 4169 (HY000): Unknown module name. Invalid Setting:'%.*s'. Syntax:parMod.subMod:level, parMod.subMod:level
ERROR 4170 (HY000): Invalid level. Invalid setting:'%.*s'. Syntax:parMod.subMod:level, parMod.subMod:level
ERROR 4171 (HY000): Syntax to set log_level error. Invalid setting:'%.*s'. Syntax:parMod.subMod:level, parMod.subMod:level
ERROR 4172 (HY000): Index out of range
ERROR 4175 (42000): Out of range
ERROR 4177 (42000): Schema version too old
ERROR 4179 (HY000): %s not allowed
ERROR 4180 (HY000): No empty entry
ERROR 4181 (42S01): Already exist
ERROR 4182 (HY000): Value not found
ERROR 4183 (HY000): Key out of range
ERROR 4184 (53100): ChunkServer out of disk space
ERROR 4186 (HY000): ChunkServer failed to get compress library
ERROR 4187 (HY000): Item not match
ERROR 4189 (HY000): the macro block type does not exist
ERROR 4191 (HY000): partition group is removed
ERROR 4192 (42000): ddl task executes too much time
ERROR 4200 (HY000): hash map/set entry exist
ERROR 4201 (HY000): hash map/set entry not exist
ERROR 4204 (HY000): hash map/set get timeout
ERROR 4205 (HY000): hash map/set retry
ERROR 4206 (HY000): hash map/set full
ERROR 4208 (HY000): wait next packet timeout
ERROR 4209 (HY000): partition has not leader
ERROR 4210 (HY000): prepare major freeze failed
ERROR 4211 (HY000): commit major freeze failed
ERROR 4212 (HY000): abort major freeze failed
ERROR 4213 (HY000): last major freeze not finish", "%s
ERROR 4215 (HY000): wait major freeze response timeout
ERROR 4216 (HY000): curl error
ERROR 4217 (HY000): Major freeze not allowed now
ERROR 4218 (HY000): prepare freeze failed
ERROR 4220 (HY000): Inactive sql client, only read allowed
ERROR 4221 (HY000): Inactive rpc proxy, can not send RPC request
ERROR 4222 (42000): Interval with year or month can not be converted to microseconds
ERROR 4223 (42000): Interval has too many datetime parts
ERROR 4225 (HY000): Partition entry not exists
ERROR 4232 (HY000): The observer or zone is not a follower
ERROR 4233 (HY000): smaller than container lower bound
ERROR 4234 (HY000): bigger than container upper bound
ERROR 4236 (HY000): ObConfig return error code
ERROR 4237 (HY000): Appname mismatch with obconfig result
ERROR 4239 (HY000): Can not use merge join to join the tables without join conditions
ERROR 4240 (HY000): No join order generated
ERROR 4241 (HY000): No join path generated
ERROR 4242 (HY000): Schema error
ERROR 4243 (HY000): file not opened
ERROR 4244 (HY000): Timer task has been scheduled
ERROR 4245 (HY000): Timer task has not been scheduled
ERROR 4246 (HY000): parse debug sync string error
ERROR 4247 (HY000): unknown debug sync point
ERROR 4248 (HY000): task is interrupted while running
ERROR 4250 (HY000): module is not running
ERROR 4251 (HY000): partition not valid
ERROR 4253 (HY000): Comment for tenant is too long (max = %ld)
ERROR 4257 (HY000): compress data or decompress data failed
ERROR 4263 (HY000): Minor freeze not allowed now
ERROR 4264 (HY000): Log out of disk space
ERROR 4265 (HY000): Rpc connect error
ERROR 4266 (HY000): minor merge not allow
ERROR 4270 (HY000): Working partition entry does not exists
ERROR 4271 (HY000): LIBEASY reach memory limit
ERROR 4273 (HY000): free memblock in cache is not enough
ERROR 4274 (HY000): sync wash memblock timeout
ERROR 4278 (HY000): last log is not complete
ERROR 4279 (HY000): table is deleted
ERROR 4280 (HY000): version range not continues
ERROR 4281 (HY000): io buffer is invalid
ERROR 4282 (HY000): partition is removed
ERROR 4283 (HY000): gts is not ready
ERROR 4286 (HY000): major sstable may has been merged
ERROR 4287 (HY000): minor sstable version range cross
ERROR 4288 (HY000): memtable cannot minor merge
ERROR 4289 (HY000): task exist
ERROR 4290 (HY000): cannot allocate disk space
ERROR 4297 (HY000): name is already used by an existing object
ERROR 4298 (HY000): %s does not exist
ERROR 4300 (HY000): invalid sequence name
ERROR 4301 (HY000): duplicate MAXVALUE/NOMAXVALUE specifications
ERROR 4302 (HY000): duplicate MINVALUE/NOMINVALUE specifications
ERROR 4303 (HY000): duplicate CYCLE/NOCYCLE specifications
ERROR 4304 (HY000): duplicate CACHE/NOCACHE specifications
ERROR 4305 (HY000): duplicate ORDER/NOORDER specifications
ERROR 4306 (HY000): conflicting MAXVALUE/NOMAXVALUE specifications
ERROR 4307 (HY000): conflicting MINVALUE/NOMINVALUE specifications
ERROR 4308 (HY000): conflicting CYCLE/NOCYCLE specifications
ERROR 4309 (HY000): conflicting CACHE/NOCACHE specifications
ERROR 4310 (HY000): conflicting ORDER/NOORDER specifications
ERROR 4311 (HY000): cannot alter starting sequence number
ERROR 4312 (HY000): duplicate INCREMENT BY specifications
ERROR 4313 (HY000): duplicate START WITH specifications
ERROR 4314 (HY000): no options specified for ALTER SEQUENCE
ERROR 4315 (HY000): sequence number not allowed here
ERROR 4316 (HY000): sequence does not exist
ERROR 4317 (HY000): sequence parameter %s must be an integer
ERROR 4318 (HY000): INCREMENT must be a nonzero integer
ERROR 4319 (HY000): sequence parameter exceeds maximum size allowed
ERROR 4320 (HY000): MINVALUE must be less than MAXVALUE
ERROR 4321 (HY000): INCREMENT must be less than MAXVALUE minus MINVALUE
ERROR 4322 (HY000): START WITH cannot be less than MINVALUE
ERROR 4323 (HY000): MINVALUE cannot be made to exceed the current value
ERROR 4324 (HY000): START WITH cannot be more than MAXVALUE
ERROR 4325 (HY000): MAXVALUE cannot be made to be less than the current value
ERROR 4326 (HY000): the number of values to CACHE must be greater than 1
ERROR 4327 (HY000): sequence option value out of range
ERROR 4328 (HY000): number to CACHE must be less than one cycle
ERROR 4329 (HY000): descending sequences that CYCLE must specify MINVALUE
ERROR 4330 (HY000): ascending sequences that CYCLE must specify MAXVALUE
ERROR 4331 (HY000): sequence %s no longer exists
ERROR 4332 (HY000): sequence exceeds %s and cannot be instantiated
ERROR 4333 (HY000): divisor is equal to zero
ERROR 4334 (HY000): fail to decrypt data
ERROR 4335 (HY000): fail to encrypt data
ERROR 4337 (HY000): store directory structure error
ERROR 4338 (HY000): open twice
ERROR 4339 (HY000): raid super block not match
ERROR 4340 (HY000): not opened
ERROR 4341 (HY000): target module is not in service
ERROR 4342 (HY000): raid disk not in normal status
ERROR 4343 (HY000): tenant schema is not full
ERROR 4344 (HY000): invalid timestamp
ERROR 4345 (HY000): dir not empty
ERROR 4346 (HY000): schema is not up to date for read
ERROR 4347 (HY000): role (string) does not exist
ERROR 4348 (HY000): role '%.*s' does not exist
ERROR 4349 (HY000): duplicate privilege listed
ERROR 4350 (HY000): the keystore already exists and each tenant can only have at most one
ERROR 4351 (HY000): the keystore is not exist
ERROR 4352 (HY000): the password is wrong for keystore
ERROR 4353 (HY000): tablespace '%.*s' already exists
ERROR 4354 (HY000): tablespace '%.*s' does not exist
ERROR 4355 (HY000): cannot delete a tablespace which is not empty
ERROR 4356 (HY000): floating point precision is out of range(1 to 126)
ERROR 4357 (HY000): numeric precision specifier is out of range (1 to 38)
ERROR 4358 (HY000): numeric scale specifier is out of range (-84 to 127)
ERROR 4359 (HY000): the keystore is not open
ERROR 4360 (HY000): the keystore opened with dont have a master key
ERROR 4361 (HY000): slog active transaction entries reach maximum
ERROR 4362 (HY000): BY ACCESS | SESSION clause not allowed for NOAUDIT
ERROR 4363 (HY000): auditing the object is not supported
ERROR 4364 (HY000): DDL statement cannot be audited with BY SESSION specified
ERROR 4367 (HY000): The data more than 64M(rpc limit), split into smaller task and retry
ERROR 4368 (HY000): cluster %s not exist
ERROR 4369 (HY000): fail to get master key
ERROR 4370 (HY000): tde_method parameter is invalid
ERROR 4371 (HY000): kms server connect failed, may be kms server is down
ERROR 4372 (HY000): kms server is busy, try again
ERROR 4373 (HY000): kms server update key conflict at the same time, please try again
ERROR 4374 (HY000): value larger than specified precision allowed for this column
ERROR 4375 (HY000): observer has disk error
ERROR 4376 (HY000): unimplemented feature
ERROR 4377 (HY000): fatal internal error in [%.*s]
ERROR 4378 (HY000): cluster name conflict
ERROR 4379 (HY000): heap table has reached max row size, cannot insert anymore
ERROR 4381 (HY000): Not supported, deprecated MySQL feature
ERROR 4383 (HY000): transaction id is not ready
ERROR 4386 (HY000): Do not allow removing leader
ERROR 4387 (HY000): Failed to switch resource group
ERROR 4388 (HY000): Unexpected internal error happen, please checkout the internal errcode
ERROR 4389 (HY000): Processing time is too long
ERROR 4390 (HY000): Schema of remote server is not refreshed yet
ERROR 4391 (HY000): ddl sstable version range cross
ERROR 4392 (HY000): disk is hung
ERROR 4393 (HY000): observer start process failure
ERROR 4394 (HY000): observer stop process failure
ERROR 4395 (HY000): observice start process has failure
ERROR 4396 (HY000): Worker thread panic, thread may be terminated or hung
ERROR 4399 (HY000): Unit status is not expected
ERROR 4400 (HY000): Autoinc cache's autoinc version is not equal to request's autoinc version

folded

share

These error codes indicate common errors.

ERROR 4000 (HY000): Common error

  • OceanBase error code: 4000

  • Cause: A common error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4001 (HY004): Object type error

  • OceanBase error code: 4001

  • Cause: The specified object type is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4003 (42000): Array index out of range

  • OceanBase error code: 4003

  • Cause: The array index is out of range.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4004 (08S01): Failed to listen to the port

  • OceanBase error code: 4004

  • Cause: The listener failed to start due to network disconnection.

  • Solution: Switch to an idle port and then restart the observer process.

Note

This error code is introduced since OceanBase Database V4.1.0.

ERROR 4005 (HY000): The object is initialized twice

  • OceanBase error code: 4005

  • Cause: The object is repeatedly initialized.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4006 (HY000): The object is not initialized

  • OceanBase error code: 4006

  • Cause: The object is not initialized.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4008 ( HY000 ): End of iteration

  • OceanBase error code: 4008

  • Cause: The iteration has ended.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4009 (58030 ): IO error

  • OceanBase error code: 4009

  • Cause: An I/O-related system call, such as a read request or a write request, failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4010 (HY000): Wrong RPC command version

  • OceanBase error code: 4010

  • Cause: The version of the remote procedure call (RPC) command is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4012 (HY000): Timeout, query has reached the maximum query timeout: %ld(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again

  • OceanBase error code: 4012

  • Cause: The execution timed out.

  • Solution:

    • Reduce the amount of time required through performance tuning.

    • Extend the timeout period.

    • Contact OceanBase Technical Support for troubleshooting.

ERROR 4012 (HY000): Task timeout and not executed

  • OceanBase error code: 4049

  • MySQL error code: 4012

ERROR 4012 (HY000): RPC session not found

  • OceanBase error code: 4067

  • MySQL error code: 4012

ERROR 4012 (HY000): RPC send error

  • OceanBase error code: 4121

  • MySQL error code: 4012

ERROR 4012 (HY000): RPC post error

  • OceanBase error code: 4122

  • MySQL error code: 4012

ERROR 4012 (HY000): Timeout

  • OceanBase error code: 4664

  • MySQL error code: 4012

ERROR 4012 (HY000): Statement is timeout

  • OceanBase error code: 6004

  • MySQL error code: 4012

ERROR 4012 (25000): Transaction timeout occurred, please rollback the transaction, set the variable ob_trx_timeout to a larger value and then restart the transaction

  • OceanBase error code: 6210

  • MySQL error code: 4012

ERROR 4012 (25000): Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement

  • OceanBase error code: 6212

  • MySQL error code: 4012

ERROR 4012 (25000): Transaction result isunknown

  • OceanBase error code: 6225

  • MySQL error code: 4012

ERROR 4012 (25000): transaction rpc timeout

  • OceanBase error code: 6230

  • MySQL error code: 4012

ERROR 4013 (HY001): No memory or reach tenant memory limit

  • OceanBase error code: 4013

  • Cause: Memory allocation failed.

    • The physical memory is exhausted.
    • The memory allocated at a time is greater than 4 GB.
    • The memory usage of the CTX, tenant, and OBServer node reaches the upper limit.
  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.1.0.

ERROR 4014 (HY000): Inner state error

  • OceanBase error code: 4014

  • Cause: An internal status error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4015 (HY000): System error

  • OceanBase error code: 4015

  • Cause: An internal error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4016 (HY000): Internal error

  • OceanBase error code: 4016

  • Cause: An internal error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4017 (HY000): Entry already exist

  • OceanBase error code: 4017

  • Cause: The specified data already exists.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4018 (HY000): Entry not exist

  • OceanBase error code: 4018

  • Cause: The specified data does not exist.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4019 (HY000): Size overflow

  • OceanBase error code: 4019

  • Cause: A space overflow occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4020 (HY000): Reference count is not zero

  • OceanBase error code: 4020

  • Cause: The reference count is not 0.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4021 (HY000): Conflict value

  • OceanBase error code: 4021

  • Cause: The base library encountered a logic error, generally, a code error.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4022 (HY000): Item not set

  • OceanBase error code: 4022

  • Cause: No value is specified.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4023 (HY000): Try again

  • OceanBase error code: 4023

  • Cause: The operation needs to be retried.

  • Solution: Retry the operation, or contact OceanBase Technical Support for troubleshooting.

ERROR 4024 (HY000): Buffer not enough

  • OceanBase error code: 4024

  • Cause: The storage space is insufficient.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4025 (HY000): Partial failed

  • OceanBase error code: 4025

  • Cause: Partial tasks that were initiated at a time failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4026 (02000): Nothing to read

  • OceanBase error code: 4026

  • Cause: No available data can be read.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4028 (HY000): Log entry not continuous

  • OceanBase error code: 4028

  • Cause: File IDs are inconsecutive.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4029 (HY000): Schema error

  • OceanBase error code: 4029

  • Cause: The schema failed to be obtained.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4030 (HY000): Over tenant memory limits

  • OceanBase error code: 4030

  • Cause: The tenant has insufficient memory.

  • Solution: Increase the memory size of the tenant.

ERROR 4031 (HY004): Unknown object

  • OceanBase error code: 4031

  • Cause: The object is unknown.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4033 (HY000): Serialize error

  • OceanBase error code: 4033

  • Cause: Serialization failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V3.2.4.

ERROR 4034 (HY000): Deserialize error

  • OceanBase error code: 4034

  • Cause: Deserialization failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V3.2.4.

ERROR 4035 (HY000): Asynchronous IO error

  • OceanBase error code: 4035

  • Cause: Asynchronous I/O-related system calls failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4036 (HY000): Need retry

  • OceanBase error code: 4036

  • Cause: The operation needs to be retried.

  • Solution: Retry the operation, or contact OceanBase Technical Support for troubleshooting.

ERROR 4037 (HY000): Too many sstable

  • OceanBase error code: 4037

  • Cause: Excessive SSTables are generated, generally due to frequent minor compactions.

  • Solution: Scale out the cluster to reduce the load on a single server, or contact OceanBase Technical Support for troubleshooting.

ERROR 4038 (HY000): The observer or zone is not the master

  • OceanBase error code: 4038

  • Cause: The current partition does not serve as the leader to provide services.

  • Solution: Execute the current statement or transaction again.

ERROR 4039 (HY000): Request has killed by sql throttle

  • OceanBase error code: 4039

  • Cause: Throttling is enabled on SQL execution.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4041 (HY000): Decrypt error

  • OceanBase error code: 4041

  • Cause: Decryption failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4045 (HY000): pushdown status changed

  • OceanBase error code: 4045

  • Cause: An internal error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4046 (HY000): Storage schema is not valid

  • OceanBase error code: 4046

  • Cause: The schema of the storage layer is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 4047 (HY000): Medium compaction info is not valid

  • OceanBase error code: 4047

  • Cause: The Medium Info is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4048 (HY000): Not registered

  • OceanBase error code: 4048

  • Cause: An internal error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4050 (HY000): Not the object

  • OceanBase error code: 4050

  • Cause: An object mismatch occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4052 (HY000): Corrupted log entry

  • OceanBase error code: 4052

  • Cause: The log data retrieved by the read request is invalid due to a hardware or disk error.

  • Solution: Contact the database administrator for hardware troubleshooting, or contact OceanBase Technical Support for troubleshooting.

ERROR 4055 (HY000): Invalid entry

  • OceanBase error code: 4055

  • Cause: An internal status error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4057 (HY000): Decimal overflow warning

  • OceanBase error code: 4057

  • Cause: The precision of the input data is out of range.

  • Solution: Reduce the precision of the input data.

ERROR 4058 (HY000): Decimal overflow error

  • OceanBase error code: 4058

  • Cause: The precision of the input data is out of range.

  • Solution: Reduce the precision of the input data.

ERROR 4060 (HY000): Divide error

  • OceanBase error code: 4060

  • Cause: A division error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4061 (HY000): Not a decimal

  • OceanBase error code: 4061

  • Cause: The specified object type is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4062 (HY104): Decimal precision error

  • OceanBase error code: 4062

  • Cause: A numeric precision error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4063 (HY000): Empty range

  • OceanBase error code: 4063

  • Cause: The query range of the LIKE condition failed to be obtained.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4064 (HY000): Session killed

  • OceanBase error code: 4064

  • Cause: The current session is terminated.

  • Solution: Contact the system administrator or database administrator for troubleshooting.

ERROR 4065 (HY000): Log not sync

  • OceanBase error code: 4065

  • Cause: Replica logs are not synchronized.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4068 (HY000): Invalid log

  • OceanBase error code: 4068

  • Cause: Logs are invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4070 (HY000): Invalid data

  • OceanBase error code: 4070

  • Cause: Data is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4071 (HY000): Already done

  • OceanBase error code: 4071

  • Cause: The operation has been completed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4072 (HY000): Operation canceled

  • OceanBase error code: 4072

  • Cause: The operation has been canceled.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4074 (HY000): Log not aligned

  • OceanBase error code: 4074

  • Cause: Logs are not aligned.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4075 (HY000): Log entry missed

  • OceanBase error code: 4075

  • Cause: Logs are not found.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4076 (HY000): Need wait

  • OceanBase error code: 4076

  • Cause: Waiting is required.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4077 (0A000): Not implemented feature

  • OceanBase error code: 4077

  • Cause: The feature is not supported.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4080 (HY013): exceed memory limit

  • OceanBase error code: 4080

  • Cause: An internal error occurred. The size of used memory exceeds the upper limit.

  • Solution: Troubleshooting is not required.

ERROR 4084 (02000): No result

  • OceanBase error code: 4084

  • Cause: The value of the parameter is not found.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4085 (HY000): Queue overflow

  • OceanBase error code: 4085

  • Cause: A queue overflow occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4090 (HY000): Table log_id range no continuous

  • OceanBase error code: 4090

  • Cause: Log IDs of SSTables in a partition are inconsecutive.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4098 (HY000): Term not match

  • OceanBase error code: 4098

  • Cause: A replica proposal_id mismatch occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4103 (42000): Data checksum error

  • OceanBase error code: 4103

  • Cause: A data checksum error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4104 (HY000): Initialize error

  • OceanBase error code: 4104

  • Cause: Initialization failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4105 (HY000): Rowkey order error

  • OceanBase error code: 4105

  • Cause: The sequence of primary keys is not as expected.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4107 (HY000): block switched when fill commitlog

  • OceanBase error code: 4107

  • Cause: The buffer used for Group Commit operations must be switched.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4108 (HY000): Physic data checksum error

  • OceanBase error code: 4108

  • Cause: A physical data checksum error occurred due to a disk failure or a program bug.

  • Solution: Check the hardware, or contact OceanBase Technical Support for troubleshooting.

ERROR 4109 (HY000): Server state or role not the same as expected

  • OceanBase error code: 4109

  • Cause: A status mismatch occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4111 (HY000): block need freeze

  • OceanBase error code: 4111

  • Cause: The block needs to be frozen.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4112 (HY000): block frozen

  • OceanBase error code: 4112

  • Cause: The block has been frozen.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4113 (HY000): In FATAL state

  • OceanBase error code: 4113

  • Cause: The status is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4114 (08S01): In STOP state

  • OceanBase error code: 4114

  • Cause: The OBServer node is being stopped.

  • Solution: If the error persists, contact OceanBase Technical Support for troubleshooting.

ERROR 4119 (08000): RPC packet to send too long

  • OceanBase error code: 4119

  • Cause: The length of the remote procedure call (RPC) packet exceeds the upper limit.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4120 (HY000): Log too large

  • OceanBase error code: 4120

  • Cause: The log size exceeds the upper limit.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4123 (08000): Libeasy error

  • OceanBase error code: 4123

  • Cause: Network initialization failed.

  • Solution: Contact the system administrator or database administrator for troubleshooting.

ERROR 4124 (HY000): Connect error

  • OceanBase error code: 4124

  • Cause: A connection to the server failed to be established.

  • Solution: Contact the system administrator or database administrator for troubleshooting.

ERROR 4128 (HY000): RPC packet is invalid

  • OceanBase error code: 4128

  • Cause: The format of the RPC packet is invalid.

  • Solution: Contact the system administrator or database administrator for troubleshooting.

ERROR 4138 (HY000): Request to read too old versioned data

  • OceanBase error code: 4138

  • Cause: The version of the accessed data is outdated.

  • Solution: Execute the statement again, or increase the value of the undo_retention parameter.

ERROR 4143 (42000): Version not match

  • OceanBase error code: 4143

  • Cause: A version mismatch occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4147 (HY000): Invalid config

  • OceanBase error code: 4147

  • Cause: The current configuration is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4150 (42000): Min value

  • OceanBase error code: 4150

  • Cause: The operation attempted to access the invalid minimum special value in the internal table.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4151 (42000): Max value

  • OceanBase error code: 4151

  • Cause: The operation attempted to access the invalid maximum special value in the internal table.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4152 (42000): Null value

  • OceanBase error code: 4152

  • Cause: The operation attempted to access an invalid null value in the internal table.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4154 (HY000): Internal SQL client error

  • OceanBase error code: 4154

  • Cause: An internal SQL client error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4161 (42000): Invalid argument num

  • OceanBase error code: 4161

  • Cause: The number of specified parameters is invalid.

  • Solution: Check the parameter list, or contact OceanBase Technical Support for troubleshooting.

ERROR 4162 (HY000): reserved lease not enough

  • OceanBase error code: 4162

  • Cause: The validity period of the lease is insufficient.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4165 (HY000): Empty result

  • OceanBase error code: 4165

  • Cause: The result set is empty.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4168 (HY000): Invalid log module id

  • OceanBase error code: 4168

  • Cause: The log module ID is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4169 (HY000): Unknown module name. Invalid Setting:'%.*s'. Syntax:parMod.subMod:level, parMod.subMod:level

  • OceanBase error code: 4169

  • Cause: The log module name that you specified when you set the log generation level on the client is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4170 (HY000): Invalid level. Invalid setting:'%.*s'. Syntax:parMod.subMod:level, parMod.subMod:level

  • OceanBase error code: 4170

  • Cause: The log generation level that you set on the client is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4171 (HY000): Syntax to set log_level error. Invalid setting:'%.*s'. Syntax:parMod.subMod:level, parMod.subMod:level

  • OceanBase error code: 4171

  • Cause: The syntax that you used to set the log generation level on the client is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4172 (HY000): Index out of range

  • OceanBase error code: 4172

  • Cause: The index is out of range.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4175 (42000): Out of range

  • OceanBase error code: 4175

  • Cause: The value is out of range.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4177 (42000): Schema version too old

  • OceanBase error code: 4177

  • Cause: The local schema version is outdated.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4179 (HY000): %s not allowed

  • OceanBase error code: 4179

  • Cause: The feature is not supported.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4180 (HY000): No empty entry

  • OceanBase error code: 4180

  • Cause: The data entry is not empty.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4181 (42S01): Already exist

  • OceanBase error code: 4181

  • Cause: The entry already exists in the location cache.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4182 (HY000): Value not found

  • OceanBase error code: 4182

  • Cause: The value is not found.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4183 (HY000): Key out of range

  • OceanBase error code: 4183

  • Cause: The key is out of range.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4184 (53100): ChunkServer out of disk space

  • OceanBase error code: 4184

  • Cause: The disk space is fully occupied.

  • Solution: Add servers for scale-out, or contact OceanBase Technical Support for troubleshooting.

ERROR 4186 (HY000): ChunkServer failed to get compress library

  • OceanBase error code: 4186

  • Cause: No compression library is found.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4187 (HY000): Item not match

  • OceanBase error code: 4187

  • Cause: A value mismatch occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4189 (HY000): the macro block type does not exist

  • OceanBase error code: 4189

  • Cause: The specified macroblock type does not exist.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4191 (HY000): partition group is removed

  • OceanBase error code: 4191

  • Cause: The partition has been deleted.

  • Solution: Troubleshooting is not required.

ERROR 4192 (42000): ddl task executes too much time

  • OceanBase error code: 4192
  • Cause: The execution time of DDL tasks is too long.
  • Solution: Check whether the execution time of DDL tasks is as expected. If the execution time is too long, contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.1.0.

ERROR 4200 (HY000): hash map/set entry exist

  • OceanBase error code: 4200

  • Cause: The HASH value already exists.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4201 (HY000): hash map/set entry not exist

  • OceanBase error code: 4201

  • Cause: The HASH value does not exist.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4204 (HY000): hash map/set get timeout

  • OceanBase error code: 4204

  • Cause: The HASH operation timed out.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4205 (HY000): hash map/set retry

  • OceanBase error code: 4205

  • Cause: The HASH operation needs to be retried.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4206 (HY000): hash map/set full

  • OceanBase error code: 4206

  • Cause: The HashMap instance is full.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4208 (HY000): wait next packet timeout

  • OceanBase error code: 4208

  • Cause: No subsequent packets are received within the timeout period.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4209 (HY000): partition has not leader

  • OceanBase error code: 4209

  • Cause: The partition has no leader.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4210 (HY000): prepare major freeze failed

  • OceanBase error code: 4210

  • Cause: The preparation for a major compaction failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4211 (HY000): commit major freeze failed

  • OceanBase error code: 4211

  • Cause: The commit of a major freeze failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4212 (HY000): abort major freeze failed

  • OceanBase error code: 4212

  • Cause: The rollback of a major freeze failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4213 (HY000): last major freeze not finish", "%s

  • OceanBase error code: 4213

  • Cause: The last major compaction has not been completed.

  • Solution: Wait until the last major compaction is completed, and then initiate a new major compaction.

ERROR 4215 (HY000): wait major freeze response timeout

  • OceanBase error code: 4215

  • Cause: No major freeze response is returned within the timeout period.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4216 (HY000): curl error

  • OceanBase error code: 4216

  • Cause: A libcurl access error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4217 (HY000): Major freeze not allowed now

  • OceanBase error code: 4217

  • Cause: Major freezes are not allowed when the system is in the current state.

  • Solution: Check whether the system is being upgraded or in the process of another operation.

ERROR 4218 (HY000): prepare freeze failed

  • OceanBase error code: 4218

  • Cause: The preparation for a freeze failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4220 (HY000): Inactive sql client, only read allowed

  • OceanBase error code: 4220

  • Cause: The SQL client is inactive.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4221 (HY000): Inactive rpc proxy, can not send RPC request

  • OceanBase error code: 4221

  • Cause: The RPC client is not initialized.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4222 (42000): Interval with year or month can not be converted to microseconds

  • OceanBase error code: 4222

  • Cause: The system encountered an error when converting the time data type.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4223 (42000): Interval has too many datetime parts

  • OceanBase error code: 4223

  • Cause: The system encountered an error when converting the time data type.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4225 (HY000): Partition entry not exists

  • OceanBase error code: 4225

  • Cause: The specified partition does not exist.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4232 (HY000): The observer or zone is not a follower

  • OceanBase error code: 4232

  • Cause: The OBServer node or zone that is accessed is not a follower.

  • Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 4233 (HY000): smaller than container lower bound

  • OceanBase error code: 4233

  • Cause: The value is below the lower limit of the container.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4234 (HY000): bigger than container upper bound

  • OceanBase error code: 4234

  • Cause: The value is above the upper limit of the container.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4236 (HY000): ObConfig return error code

  • OceanBase error code: 4236

  • Cause: OceanBase Database encountered an error when accessing ConfigServer.

  • Solution: Check the obconfig_url parameter to determine whether ConfigServer is running properly, and contact OceanBase Technical Support for troubleshooting.

ERROR 4237 (HY000): Appname mismatch with obconfig result

  • OceanBase error code: 4237

  • Cause: The cluster name specified for ConfigServer is inconsistent with the actual cluster name.

  • Solution: Check the obconfig_url parameter and contact OceanBase Technical Support for troubleshooting.

ERROR 4239 (HY000): Can not use merge join to join the tables without join conditions

  • OceanBase error code: 4239

  • Cause: A kernel error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4240 (HY000): No join order generated

  • OceanBase error code: 4240

  • Cause: A kernel error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4241 (HY000): No join path generated

  • OceanBase error code: 4241

  • Cause: A kernel error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4242 (HY000): Schema error

  • OceanBase error code: 4242

  • Cause: The execution server failed to obtain the schema.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4243 (HY000): file not opened

  • OceanBase error code: 4243

  • Cause: The file is not opened.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4244 (HY000): Timer task has been scheduled

  • OceanBase error code: 4244

  • Cause: A timer task has been scheduled.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4245 (HY000): Timer task has not been scheduled

  • OceanBase error code: 4245

  • Cause: No timer task is scheduled.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4246 (HY000): parse debug sync string error

  • OceanBase error code: 4246

  • Cause: The string of debug_sync does not conform to the syntax.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4247 (HY000): unknown debug sync point

  • OceanBase error code: 4247

  • Cause: The debug sync point does not exist.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4248 (HY000): task is interrupted while running

  • OceanBase error code: 4248

  • Cause: The distributed task execution scheduler was interrupted and stopped in advance.

  • Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 4250 (HY000): module is not running

  • OceanBase error code: 4250

  • Cause: The module has not been started.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4251 (HY000): partition not valid

  • OceanBase error code: 4251

  • Cause: The partition is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4253 (HY000): Comment for tenant is too long (max = %ld)

  • OceanBase error code: 4253

  • Cause: The length of the COMMENT for a tenant in a DDL statement exceeds the upper limit.

  • Solution: Shorten the COMMENT in the DDL statement.

ERROR 4257 (HY000): compress data or decompress data failed

  • OceanBase error code: 4257

  • Cause: Data compression or decompression failed because the data was corrupted.

  • Solution: Contact the database administrator to check the hardware and replace the faulty server or recover the data.

ERROR 4263 (HY000): Minor freeze not allowed now

  • OceanBase error code: 4263

  • Cause: Minor freezes are not allowed when the system is in the current state.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4264 (HY000): Log out of disk space

  • OceanBase error code: 4264

  • Cause: The log disk is fully occupied.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4265 (HY000): Rpc connect error

  • OceanBase error code: 4265

  • Cause: A RPC connection failed to be established.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4266 (HY000): minor merge not allow

  • OceanBase error code: 4266

  • Cause: Minor compactions are not allowed when the system is in the current state.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4270 (HY000): Working partition entry does not exists

  • OceanBase error code: 4270

  • Cause: The partition status is abnormal.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4271 (HY000): LIBEASY reach memory limit

  • OceanBase error code: 4271

  • Cause: The memory size occupied by unsent libeasy packets has exceeded the upper limit.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4273 (HY000): free memblock in cache is not enough

  • OceanBase error code: 4273

  • Cause: Available memory blocks in the cache are insufficient.

  • Solution: Increase the memory size, reduce the load, or contact OceanBase Technical Support for troubleshooting.

ERROR 4274 (HY000): sync wash memblock timeout

  • OceanBase error code: 4274

  • Cause: Memory blocks were not released within the timeout period.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4278 (HY000): last log is not complete

  • OceanBase error code: 4278

  • Cause: The last log is incomplete due to a power failure or an emergency.

  • Solution: Restart the OBServer node or contact OceanBase Technical Support for troubleshooting.

ERROR 4279 (HY000): table is deleted

  • OceanBase error code: 4279

  • Cause: The table has been deleted.

  • Solution: Check whether the SQL statement attempts to access the deleted table.

ERROR 4280 (HY000): version range not continues

  • OceanBase error code: 4280

  • Cause: The version range is inconsecutive.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4281 (HY000): io buffer is invalid

  • OceanBase error code: 4281

  • Cause: The I/O buffer is invalid.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4282 (HY000): partition is removed

  • OceanBase error code: 4282

  • Cause: The partition has been deleted.

  • Solution: Check whether the operation is initiated on the deleted partition, or contact OceanBase Technical Support for troubleshooting.

ERROR 4283 (HY000): gts is not ready

  • OceanBase error code: 4283

  • Cause: Global Timestamp Service (GTS) is not available.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4286 (HY000): major sstable may has been merged

  • OceanBase error code: 4286

  • Cause: Baseline data has been compacted.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4287 (HY000): minor sstable version range cross

  • OceanBase error code: 4287

  • Cause: Version ranges of SSTables have an intersection.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4288 (HY000): memtable cannot minor merge

  • OceanBase error code: 4288

  • Cause: A minor compaction of the MemTable failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4289 (HY000): task exist

  • OceanBase error code: 4289

  • Cause: Duplicate tasks exist.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4290 (HY000): cannot allocate disk space

  • OceanBase error code: 4290

  • Cause: The available disk space is insufficient.

  • Solution: Increase the disk space, or contact OceanBase Technical Support for troubleshooting.

ERROR 4297 (HY000): name is already used by an existing object

  • OceanBase error code: 4297

  • Cause: The specified object name is already used in the same namespace.

  • Solution: Specify an object name that is not used in the namespace.

ERROR 4298 (HY000): %s does not exist

  • OceanBase error code: 4298

  • Cause: The specified sequence does not exist.

  • Solution: Make sure that the specified sequence name is valid and that you have the required privilege to perform the operation on the sequence.

ERROR 4300 (HY000): invalid sequence name

  • OceanBase error code: 4300

  • Cause: The specified sequence name is invalid.

  • Solution: Modify the sequence name.

ERROR 4301 (HY000): duplicate MAXVALUE/NOMAXVALUE specifications

  • OceanBase error code: 4301

  • Cause: Duplicate MAXVALUE or NOMAXVALUE settings exist.

  • Solution: Deduplicate MAXVALUE or NOMAXVALUE settings.

ERROR 4302 (HY000): duplicate MINVALUE/NOMINVALUE specifications

  • OceanBase error code: 4302

  • Cause: Duplicate MINVALUE or NOMINVALUE settings exist.

  • Solution: Deduplicate MINVALUE or NOMINVALUE settings.

ERROR 4303 (HY000): duplicate CYCLE/NOCYCLE specifications

  • OceanBase error code: 4303

  • Cause: Duplicate CYCLE or NOCYCLE settings exist.

  • Solution: Deduplicate CYCLE or NOCYCLE settings.

ERROR 4304 (HY000): duplicate CACHE/NOCACHE specifications

  • OceanBase error code: 4304

  • Cause: Duplicate CACHE or NOCACHE settings exist.

  • Solution: Deduplicate CACHE or NOCACHE settings.

ERROR 4305 (HY000): duplicate ORDER/NOORDER specifications

  • OceanBase error code: 4305

  • Cause: Duplicate ORDER or NOORDER settings exist.

  • Solution: Deduplicate ORDER or NOORDER settings.

ERROR 4306 (HY000): conflicting MAXVALUE/NOMAXVALUE specifications

  • OceanBase error code: 4306

  • Cause: Conflicting MAXVALUE or NOMAXVALUE settings exist.

  • Solution: Delete conflicting MAXVALUE or NOMAXVALUE settings.

ERROR 4307 (HY000): conflicting MINVALUE/NOMINVALUE specifications

  • OceanBase error code: 4307

  • Cause: Conflicting MINVALUE or NOMINVALUE settings exist.

  • Solution: Delete conflicting MINVALUE or NOMINVALUE settings.

ERROR 4308 (HY000): conflicting CYCLE/NOCYCLE specifications

  • OceanBase error code: 4308

  • Cause: Conflicting CYCLE or NOCYCLE settings exist.

  • Solution: Delete conflicting CYCLE or NOCYCLE settings.

ERROR 4309 (HY000): conflicting CACHE/NOCACHE specifications

  • OceanBase error code: 4309

  • Cause: Conflicting CACHE or NOCACHE settings exist.

  • Solution: Delete conflicting CACHE or NOCACHE settings.

ERROR 4310 (HY000): conflicting ORDER/NOORDER specifications

  • OceanBase error code: 4310

  • Cause: Conflicting ORDER or NOORDER settings exist.

  • Solution: Delete conflicting ORDER or NOORDER settings.

ERROR 4311 (HY000): cannot alter starting sequence number

  • OceanBase error code: 4311

  • Cause: The START WITH value of an auto-increment column cannot be modified.

  • Solution: Do not modify the START WITH value.

ERROR 4312 (HY000): duplicate INCREMENT BY specifications

  • OceanBase error code: 4312

  • Cause: Duplicate INCREMENT BY settings exist.

  • Solution: Deduplicate INCREMENT BY settings.

ERROR 4313 (HY000): duplicate START WITH specifications

  • OceanBase error code: 4313

  • Cause: Duplicate START WITH settings exist.

  • Solution: Deduplicate START WITH settings.

ERROR 4314 (HY000): no options specified for ALTER SEQUENCE

  • OceanBase error code: 4314

  • Cause: No option is specified in the ALTER SEQUENCE statement.

  • Solution: Options in statements are meaningful. Make sure that all the required options are specified in the statement.

ERROR 4315 (HY000): sequence number not allowed here

  • OceanBase error code: 4315

  • Cause: Auto-increment columns are not allowed for this operation.

  • Solution: Delete the specified auto-increment column.

ERROR 4316 (HY000): sequence does not exist

  • OceanBase error code: 4316

  • Cause: The specified auto-increment column does not exist, or you do not have the required privilege.

  • Solution: Make sure that the specified auto-increment column name is valid and that you have the required privilege on the column.

ERROR 4317 (HY000): sequence parameter %s must be an integer

  • OceanBase error code: 4317

  • Cause: A parameter value in the CREATE SEQUENCE or ALTER SEQUENCE statement is not an integer.

  • Solution: When you create or modify an auto-increment column, specify integer values for parameters in the statement.

ERROR 4318 (HY000): INCREMENT must be a nonzero integer

  • OceanBase error code: 4318

  • Cause: The value of INCREMENT is not a non-zero integer.

  • Solution: Set INCREMENT to a non-zero integer.

ERROR 4319 (HY000): sequence parameter exceeds maximum size allowed

  • OceanBase error code: 4319

  • Cause: A parameter value specified for the auto-increment column exceeds the maximum value allowed.

  • Solution: Specify parameter values within the range allowed.

ERROR 4320 (HY000): MINVALUE must be less than MAXVALUE

  • OceanBase error code: 4320

  • Cause: In the CREATE SEQUENCE or ALTER SEQUENCE statement, the value of MINVALUE is not less than that of MAXVALUE.

  • Solution: Make sure that the value of MINVALUE is less than that of MAXVALUE.

ERROR 4321 (HY000): INCREMENT must be less than MAXVALUE minus MINVALUE

  • OceanBase error code: 4321

  • Cause: In the CREATE SEQUENCE or ALTER SEQUENCE statement, the value of INCREMENT is not less than the difference between the values of MAXVALUE and MINVALUE.

  • Solution: Make sure that the value of INCREMENT is less than the difference between the values of MAXVALUE and MINVALUE.

ERROR 4322 (HY000): START WITH cannot be less than MINVALUE

  • OceanBase error code: 4322

  • Cause: In the CREATE SEQUENCE or ALTER SEQUENCE statement, the value of START WITH is less than that of MINVALUE.

  • Solution: Make sure that the value of START WITH is greater than or equal to that of MINVALUE.

ERROR 4323 (HY000): MINVALUE cannot be made to exceed the current value

  • OceanBase error code: 4323

  • Cause: The value of MINVALUE is greater than the current value.

  • Solution: Make sure that the value of MINVALUE is less than the current value.

ERROR 4324 (HY000): START WITH cannot be more than MAXVALUE

  • OceanBase error code: 4324

  • Cause: The value of START WITH is greater than that of MAXVALUE.

  • Solution: Make sure that the value of START WITH is less than that of MAXVALUE.

ERROR 4325 (HY000): MAXVALUE cannot be made to be less than the current value

  • OceanBase error code: 4325

  • Cause: The value of MAXVALUE is less than the current value.

  • Solution: Make sure that the value of MAXVALUE is greater than the current value.

ERROR 4326 (HY000): the number of values to CACHE must be greater than 1

  • OceanBase error code: 4326

  • Cause: A parameter value in the CACHE clause is not greater than 1.

  • Solution: Make sure that the parameter values in the CACHE clause are greater than 1.

ERROR 4327 (HY000): sequence option value out of range

  • OceanBase error code: 4327

  • Cause: A parameter value in the CREATE SEQUENCE or ALTER SEQUENCE statement is out of range.

  • Solution: Specify parameter values within the range allowed.

ERROR 4328 (HY000): number to CACHE must be less than one cycle

  • OceanBase error code: 4328

  • Cause: The parameter values to be cached are not within one cycle.

  • Solution: Lengthen the cycle, or cache fewer values.

ERROR 4329 (HY000): descending sequences that CYCLE must specify MINVALUE

  • OceanBase error code: 4329

  • Cause: MINVALUE is not specified for the descending auto-increment column.

  • Solution: Create a sequence and specify MINVALUE.

ERROR 4330 (HY000): ascending sequences that CYCLE must specify MAXVALUE

  • OceanBase error code: 4330

  • Cause: MAXVALUE is not specified for the ascending auto-increment column.

  • Solution: Create a sequence and specify MAXVALUE.

ERROR 4331 (HY000): sequence %s no longer exists

  • OceanBase error code: 4331

  • Cause: The specified auto-increment column does not exist.

  • Solution: Create an auto-increment column.

ERROR 4332 (HY000): sequence exceeds %s and cannot be instantiated

  • OceanBase error code: 4332

  • Cause: The number of values in the auto-increment column has reached the upper limit, and no more values can be generated.

  • Solution: Modify the auto-increment column to generate new values.

ERROR 4333 (HY000): divisor is equal to zero

  • OceanBase error code: 4333

  • Cause: The divisor is 0.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4334 (HY000): fail to decrypt data

  • OceanBase error code: 4334

  • Cause: Decryption failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4335 (HY000): fail to encrypt data

  • OceanBase error code: 4335

  • Cause: Encryption failed.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4337 (HY000): store directory structure error

  • OceanBase error code: 4337

  • Cause: A storage directory structure error occurred.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4338 (HY000): open twice

  • OceanBase error code: 4338

  • Cause: The file was repeatedly opened.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4339 (HY000): raid super block not match

  • OceanBase error code: 4339

  • Cause: The super block encountered an error.

  • Solution: Check the disk or contact OceanBase Technical Support for troubleshooting.

ERROR 4340 (HY000): not opened

  • OceanBase error code: 4340

  • Cause: The item is not opened.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4341 (HY000): target module is not in service

  • OceanBase error code: 4341

  • Cause: Weak consistency reads are not enabled.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4342 (HY000): raid disk not in normal status

  • OceanBase error code: 4342

  • Cause: The disk status is abnormal.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4343 (HY000): tenant schema is not full

  • OceanBase error code: 4343

  • Cause: The local tenant schema version is outdated.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4344 (HY000): invalid timestamp

  • OceanBase error code: 4344

  • Cause: The specified timestamp is invalid.

  • Solution: Specify a valid timestamp.

ERROR 4345 (HY000): dir not empty

  • OceanBase error code: 4345

  • Cause: The specified directory is not empty.

  • Solution: Check whether the installation directory of OceanBase Database is valid.

ERROR 4346 (HY000): schema is not up to date for read

  • OceanBase error code: 4346

  • Cause: The local schema version is outdated.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4347 (HY000): role (string) does not exist

  • OceanBase error code: 4347

  • Cause: The role identified by ROLE does not exist.

  • Solution: Specify a valid value for ROLE.

ERROR 4348 (HY000): role '%.*s' does not exist

  • OceanBase error code: 4348

  • Cause: A user or role with the specified name already exists.

  • Solution: Specify another name.

ERROR 4349 (HY000): duplicate privilege listed

  • OceanBase error code: 4349

  • Cause: Duplicate privileges or roles are specified in the GRANT or REVOKE statement.

  • Solution: Deduplicate the privileges or roles specified in the statement.

ERROR 4350 (HY000): the keystore already exists and each tenant can only have at most one

  • OceanBase error code: 4350

  • Cause: A Keystore already exists within the current tenant. You can create only one Keystore for a tenant.

  • Solution: Check whether a Keystore has been created for the tenant.

ERROR 4351 (HY000): the keystore is not exist

  • OceanBase error code: 4351

  • Cause: No Keystore exists within the current tenant.

  • Solution: Check whether a Keystore has been created for the tenant.

ERROR 4352 (HY000): the password is wrong for keystore

  • OceanBase error code: 4352

  • Cause: The specified Keystore password is invalid.

  • Solution: Specify the valid password.

ERROR 4353 (HY000): tablespace '%.*s' already exists

  • OceanBase error code: 4353

  • Cause: A tablespace with the specified name already exists.

  • Solution: Specify another name for the tablespace to be created.

ERROR 4354 (HY000): tablespace '%.*s' does not exist

  • OceanBase error code: 4354

  • Cause: The tablespace does not exist.

  • Solution: Check whether the tablespace to be accessed exists.

ERROR 4355 (HY000): cannot delete a tablespace which is not empty

  • OceanBase error code: 4355

  • Cause: The tablespace to be deleted is not empty.

  • Solution: Make sure that the tablespace is empty and then delete it.

ERROR 4356 (HY000): floating point precision is out of range(1 to 126)

  • OceanBase error code: 4356

  • Cause: The precision of BINARY_DOUBLE data is out of range.

  • Solution: Reduce the precision of the data.

ERROR 4357 (HY000): numeric precision specifier is out of range (1 to 38)

  • OceanBase error code: 4357

  • Cause: The precision of NUMBER data is out of range.

  • Solution: Reduce the precision of the data.

ERROR 4358 (HY000): numeric scale specifier is out of range (-84 to 127)

  • OceanBase error code: 4358

  • Cause: The precision of NUMBER data is out of range.

  • Solution: Reduce the precision of the data.

ERROR 4359 (HY000): the keystore is not open

  • OceanBase error code: 4359

  • Cause: The Keystore is not open.

  • Solution: Open the Keystore.

ERROR 4360 (HY000): the keystore opened with dont have a master key

  • OceanBase error code: 4360

  • Cause: No master key is available.

  • Solution: Create a master key.

ERROR 4361 (HY000): slog active transaction entries reach maximum

  • OceanBase error code: 4361

  • Cause: The number of concurrent slog transactions exceeds the upper limit.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4362 (HY000): BY ACCESS | SESSION clause not allowed for NOAUDIT

  • OceanBase error code: 4362

  • Cause: The BY ACCESS or BY SESSION clause is specified in the NOAUDIT statement.

  • Solution: Delete the BY ACCESS or BY SESSION clause.

ERROR 4363 (HY000): auditing the object is not supported

  • OceanBase error code: 4363

  • Cause: This type of object cannot be audited.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4364 (HY000): DDL statement cannot be audited with BY SESSION specified

  • OceanBase error code: 4364

  • Cause: The BY SESSION clause is used to audit the DDL statement.

  • Solution: Delete the BY SESSION clause.

ERROR 4367 (HY000): The data more than 64M(rpc limit), split into smaller task and retry

  • OceanBase error code: 4367

  • Cause: When the data volume exceeds 64 MB, the execution task must be split into smaller tasks. This error code is used to instruct the execution scheduler to split the task and try again.

  • Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 4368 (HY000): cluster %s not exist

  • OceanBase error code: 4368

  • Cause: When you access ConfigServer to obtain cluster information, ConfigServer returns this error code to indicate that the cluster does not exist.

  • Solution: This is an internal error code. Contact OceanBase Technical Support for troubleshooting.

ERROR 4369 (HY000): fail to get master key

  • OceanBase error code: 4369

  • Cause: The master key failed to be obtained.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4370 (HY000): tde_method parameter is invalid

  • OceanBase error code: 4370

  • Cause: The value of tde_method for the tenant is invalid.

  • Solution: Adjust the value of tde_method.

ERROR 4371 (HY000): kms server connect failed, may be kms server is down

  • OceanBase error code: 4371

  • Cause: A connection to Key Management Service (KMS) failed to be established.

  • Solution: Check whether KMS is available.

ERROR 4372 (HY000): kms server is busy, try again

  • OceanBase error code: 4372

  • Cause: The KMS server is busy.

  • Solution: Try again.

ERROR 4373 (HY000): kms server update key conflict at the same time, please try again

  • OceanBase error code: 4373

  • Cause: A conflict occurred when multiple master keys were updated at a time.

  • Solution: Try again.

ERROR 4374 (HY000): value larger than specified precision allowed for this column

  • OceanBase error code: 4374

  • Cause: The precision of the current value is greater than the precision defined for the field.

  • Solution: Adjust the value or the field definition.

ERROR 4375 (HY000): observer has disk error

  • OceanBase error code: 4375

  • Cause: The storage disk is faulty.

  • Solution: Check whether the disk is faulty and replace the corresponding server.

ERROR 4376 (HY000): unimplemented feature

  • OceanBase error code: 4376

  • Cause: OceanBase Database does not support this feature.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4377 (HY000): fatal internal error in [%.*s]

  • OceanBase error code: 4377

  • Cause: OceanBase Database encountered an unexpected internal error, such as a program execution failure.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

ERROR 4378 (HY000): cluster name conflict

  • OceanBase error code: 4378

  • Cause: The specified cluster name already exists.

  • Solution: Specify another cluster name.

ERROR 4379 (HY000): heap table has reached max row size, cannot insert anymore

  • OceanBase error code: 4379

  • Cause: No more data can be inserted into the table without a primary key.

  • Solution: Create a table and import the data of the original table to the new table.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 4381 (HY000): Not supported, deprecated MySQL feature

  • OceanBase error code: 4381

  • Cause: Float(m,d) or double(m,d) was used to define the floating-point type with precision when data types were specified.

  • Solution: Use decimal(m,d) rather than float(m,d) or double(m,d) to specify exact decimal numerals.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 4383 (HY000): transaction id is not ready

  • OceanBase error code: 4383

  • Cause: No ID range is available for the Transaction ID allocator to use.

  • Solution: Retry the acquisition process until it times out.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 4386 (HY000): Do not allow removing leader

  • OceanBase error code: 4386

  • Cause: An internal error occurred. Migration is not supported because the migration source is a leader log-only replica.

  • Solution: Troubleshooting is not required.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 4387 (HY000): Failed to switch resource group

  • OceanBase error code: 4387
  • MySQL error code: 13937

ERROR 4388 (HY000): Unexpected internal error happen, please checkout the internal errcode

  • OceanBase error code: 4388

  • Cause: An unexpected internal error occurs.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V3.2.4.

ERROR 4389 (HY000): Processing time is too long

  • OceanBase error code: 4389

  • Cause: The task processing time is too long.

  • Solution: This is an internal error code. If this error is returned, contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V3.2.4.

ERROR 4390 (HY000): Schema of remote server is not refreshed yet

  • OceanBase error code: 4389

  • Cause: The local or remote schema is not refreshed. Some of the OBServer nodes may not be restarted or may be abnormal.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 4391 (HY000): ddl sstable version range cross

  • OceanBase error code: 4391

  • Cause: DDL statements for automatic and manual SSTable compactions conflict.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.0.0.

ERROR 4392 (HY000): disk is hung

  • OceanBase error code: 4392
  • Cause: The disk is faulty.
  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.1.0.

ERROR 4393 (HY000): observer start process failure

  • OceanBase error code: 4393

  • Cause: The observer process fails to start because an internal component or service is initialized.

  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.1.0.

ERROR 4394 (HY000): observer stop process failure

  • OceanBase error code: 4394
  • Cause: An internal component or service error occurs when the observer process exits.
  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.1.0.

ERROR 4395 (HY000): observice start process has failure

  • OceanBase error code: 4395
  • Cause: The observer process fails to start because an internal component or service is initialized.
  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.1.0.

ERROR 4396 (HY000): Worker thread panic, thread may be terminated or hung

  • OceanBase error code: 4396
  • Cause: A worker thread aborts execution due to an exception.
  • Solution: Contact OceanBase Technical Support for troubleshooting.

Note

This error code is introduced since OceanBase Database V4.1.0.

ERROR 4399 (HY000): Unit status is not expected

  • OceanBase error code: 4399
  • Cause: The tenant is migrated when you import data in bypass mode.
  • Solution: Re-execute the failed SQL statement for bypass import.

Note

This error code is introduced since OceanBase Database V4.2.0.

ERROR 4400 (HY000): Autoinc cache's autoinc version is not equal to request's autoinc version

  • OceanBase error code: 4400
  • Cause: The version of the cached auto-increment column values is inconsistent with the requested version.
  • Solution:
    1. Make sure that the version of the auto-increment column values is the same as the requested version.
    2. Clear the cached auto-increment column values to regenerate new values.

Note

This error code is introduced since OceanBase Database V4.2.0.

Previous topic

0001 - 3999
Last

Next topic

4500 - 4999
Next
What is on this page
ERROR 4000 (HY000): Common error
ERROR 4001 (HY004): Object type error
ERROR 4003 (42000): Array index out of range
ERROR 4004 (08S01): Failed to listen to the port
ERROR 4005 (HY000): The object is initialized twice
ERROR 4006 (HY000): The object is not initialized
ERROR 4008 ( HY000 ): End of iteration
ERROR 4009 (58030 ): IO error
ERROR 4010 (HY000): Wrong RPC command version
ERROR 4012 (HY000): Timeout, query has reached the maximum query timeout: %ld(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again
ERROR 4012 (HY000): Task timeout and not executed
ERROR 4012 (HY000): RPC session not found
ERROR 4012 (HY000): RPC send error
ERROR 4012 (HY000): RPC post error
ERROR 4012 (HY000): Timeout
ERROR 4012 (HY000): Statement is timeout
ERROR 4012 (25000): Transaction timeout occurred, please rollback the transaction, set the variable ob_trx_timeout to a larger value and then restart the transaction
ERROR 4012 (25000): Statement timeout occurred, please set the variable ob_query_timeout to a larger value an then restart the statement
ERROR 4012 (25000): Transaction result isunknown
ERROR 4012 (25000): transaction rpc timeout
ERROR 4013 (HY001): No memory or reach tenant memory limit
ERROR 4014 (HY000): Inner state error
ERROR 4015 (HY000): System error
ERROR 4016 (HY000): Internal error
ERROR 4017 (HY000): Entry already exist
ERROR 4018 (HY000): Entry not exist
ERROR 4019 (HY000): Size overflow
ERROR 4020 (HY000): Reference count is not zero
ERROR 4021 (HY000): Conflict value
ERROR 4022 (HY000): Item not set
ERROR 4023 (HY000): Try again
ERROR 4024 (HY000): Buffer not enough
ERROR 4025 (HY000): Partial failed
ERROR 4026 (02000): Nothing to read
ERROR 4028 (HY000): Log entry not continuous
ERROR 4029 (HY000): Schema error
ERROR 4030 (HY000): Over tenant memory limits
ERROR 4031 (HY004): Unknown object
ERROR 4033 (HY000): Serialize error
ERROR 4034 (HY000): Deserialize error
ERROR 4035 (HY000): Asynchronous IO error
ERROR 4036 (HY000): Need retry
ERROR 4037 (HY000): Too many sstable
ERROR 4038 (HY000): The observer or zone is not the master
ERROR 4039 (HY000): Request has killed by sql throttle
ERROR 4041 (HY000): Decrypt error
ERROR 4045 (HY000): pushdown status changed
ERROR 4046 (HY000): Storage schema is not valid
ERROR 4047 (HY000): Medium compaction info is not valid
ERROR 4048 (HY000): Not registered
ERROR 4050 (HY000): Not the object
ERROR 4052 (HY000): Corrupted log entry
ERROR 4055 (HY000): Invalid entry
ERROR 4057 (HY000): Decimal overflow warning
ERROR 4058 (HY000): Decimal overflow error
ERROR 4060 (HY000): Divide error
ERROR 4061 (HY000): Not a decimal
ERROR 4062 (HY104): Decimal precision error
ERROR 4063 (HY000): Empty range
ERROR 4064 (HY000): Session killed
ERROR 4065 (HY000): Log not sync
ERROR 4068 (HY000): Invalid log
ERROR 4070 (HY000): Invalid data
ERROR 4071 (HY000): Already done
ERROR 4072 (HY000): Operation canceled
ERROR 4074 (HY000): Log not aligned
ERROR 4075 (HY000): Log entry missed
ERROR 4076 (HY000): Need wait
ERROR 4077 (0A000): Not implemented feature
ERROR 4080 (HY013): exceed memory limit
ERROR 4084 (02000): No result
ERROR 4085 (HY000): Queue overflow
ERROR 4090 (HY000): Table log_id range no continuous
ERROR 4098 (HY000): Term not match
ERROR 4103 (42000): Data checksum error
ERROR 4104 (HY000): Initialize error
ERROR 4105 (HY000): Rowkey order error
ERROR 4107 (HY000): block switched when fill commitlog
ERROR 4108 (HY000): Physic data checksum error
ERROR 4109 (HY000): Server state or role not the same as expected
ERROR 4111 (HY000): block need freeze
ERROR 4112 (HY000): block frozen
ERROR 4113 (HY000): In FATAL state
ERROR 4114 (08S01): In STOP state
ERROR 4119 (08000): RPC packet to send too long
ERROR 4120 (HY000): Log too large
ERROR 4123 (08000): Libeasy error
ERROR 4124 (HY000): Connect error
ERROR 4128 (HY000): RPC packet is invalid
ERROR 4138 (HY000): Request to read too old versioned data
ERROR 4143 (42000): Version not match
ERROR 4147 (HY000): Invalid config
ERROR 4150 (42000): Min value
ERROR 4151 (42000): Max value
ERROR 4152 (42000): Null value
ERROR 4154 (HY000): Internal SQL client error
ERROR 4161 (42000): Invalid argument num
ERROR 4162 (HY000): reserved lease not enough
ERROR 4165 (HY000): Empty result
ERROR 4168 (HY000): Invalid log module id
ERROR 4169 (HY000): Unknown module name. Invalid Setting:'%.*s'. Syntax:parMod.subMod:level, parMod.subMod:level
ERROR 4170 (HY000): Invalid level. Invalid setting:'%.*s'. Syntax:parMod.subMod:level, parMod.subMod:level
ERROR 4171 (HY000): Syntax to set log_level error. Invalid setting:'%.*s'. Syntax:parMod.subMod:level, parMod.subMod:level
ERROR 4172 (HY000): Index out of range
ERROR 4175 (42000): Out of range
ERROR 4177 (42000): Schema version too old
ERROR 4179 (HY000): %s not allowed
ERROR 4180 (HY000): No empty entry
ERROR 4181 (42S01): Already exist
ERROR 4182 (HY000): Value not found
ERROR 4183 (HY000): Key out of range
ERROR 4184 (53100): ChunkServer out of disk space
ERROR 4186 (HY000): ChunkServer failed to get compress library
ERROR 4187 (HY000): Item not match
ERROR 4189 (HY000): the macro block type does not exist
ERROR 4191 (HY000): partition group is removed
ERROR 4192 (42000): ddl task executes too much time
ERROR 4200 (HY000): hash map/set entry exist
ERROR 4201 (HY000): hash map/set entry not exist
ERROR 4204 (HY000): hash map/set get timeout
ERROR 4205 (HY000): hash map/set retry
ERROR 4206 (HY000): hash map/set full
ERROR 4208 (HY000): wait next packet timeout
ERROR 4209 (HY000): partition has not leader
ERROR 4210 (HY000): prepare major freeze failed
ERROR 4211 (HY000): commit major freeze failed
ERROR 4212 (HY000): abort major freeze failed
ERROR 4213 (HY000): last major freeze not finish", "%s
ERROR 4215 (HY000): wait major freeze response timeout
ERROR 4216 (HY000): curl error
ERROR 4217 (HY000): Major freeze not allowed now
ERROR 4218 (HY000): prepare freeze failed
ERROR 4220 (HY000): Inactive sql client, only read allowed
ERROR 4221 (HY000): Inactive rpc proxy, can not send RPC request
ERROR 4222 (42000): Interval with year or month can not be converted to microseconds
ERROR 4223 (42000): Interval has too many datetime parts
ERROR 4225 (HY000): Partition entry not exists
ERROR 4232 (HY000): The observer or zone is not a follower
ERROR 4233 (HY000): smaller than container lower bound
ERROR 4234 (HY000): bigger than container upper bound
ERROR 4236 (HY000): ObConfig return error code
ERROR 4237 (HY000): Appname mismatch with obconfig result
ERROR 4239 (HY000): Can not use merge join to join the tables without join conditions
ERROR 4240 (HY000): No join order generated
ERROR 4241 (HY000): No join path generated
ERROR 4242 (HY000): Schema error
ERROR 4243 (HY000): file not opened
ERROR 4244 (HY000): Timer task has been scheduled
ERROR 4245 (HY000): Timer task has not been scheduled
ERROR 4246 (HY000): parse debug sync string error
ERROR 4247 (HY000): unknown debug sync point
ERROR 4248 (HY000): task is interrupted while running
ERROR 4250 (HY000): module is not running
ERROR 4251 (HY000): partition not valid
ERROR 4253 (HY000): Comment for tenant is too long (max = %ld)
ERROR 4257 (HY000): compress data or decompress data failed
ERROR 4263 (HY000): Minor freeze not allowed now
ERROR 4264 (HY000): Log out of disk space
ERROR 4265 (HY000): Rpc connect error
ERROR 4266 (HY000): minor merge not allow
ERROR 4270 (HY000): Working partition entry does not exists
ERROR 4271 (HY000): LIBEASY reach memory limit
ERROR 4273 (HY000): free memblock in cache is not enough
ERROR 4274 (HY000): sync wash memblock timeout
ERROR 4278 (HY000): last log is not complete
ERROR 4279 (HY000): table is deleted
ERROR 4280 (HY000): version range not continues
ERROR 4281 (HY000): io buffer is invalid
ERROR 4282 (HY000): partition is removed
ERROR 4283 (HY000): gts is not ready
ERROR 4286 (HY000): major sstable may has been merged
ERROR 4287 (HY000): minor sstable version range cross
ERROR 4288 (HY000): memtable cannot minor merge
ERROR 4289 (HY000): task exist
ERROR 4290 (HY000): cannot allocate disk space
ERROR 4297 (HY000): name is already used by an existing object
ERROR 4298 (HY000): %s does not exist
ERROR 4300 (HY000): invalid sequence name
ERROR 4301 (HY000): duplicate MAXVALUE/NOMAXVALUE specifications
ERROR 4302 (HY000): duplicate MINVALUE/NOMINVALUE specifications
ERROR 4303 (HY000): duplicate CYCLE/NOCYCLE specifications
ERROR 4304 (HY000): duplicate CACHE/NOCACHE specifications
ERROR 4305 (HY000): duplicate ORDER/NOORDER specifications
ERROR 4306 (HY000): conflicting MAXVALUE/NOMAXVALUE specifications
ERROR 4307 (HY000): conflicting MINVALUE/NOMINVALUE specifications
ERROR 4308 (HY000): conflicting CYCLE/NOCYCLE specifications
ERROR 4309 (HY000): conflicting CACHE/NOCACHE specifications
ERROR 4310 (HY000): conflicting ORDER/NOORDER specifications
ERROR 4311 (HY000): cannot alter starting sequence number
ERROR 4312 (HY000): duplicate INCREMENT BY specifications
ERROR 4313 (HY000): duplicate START WITH specifications
ERROR 4314 (HY000): no options specified for ALTER SEQUENCE
ERROR 4315 (HY000): sequence number not allowed here
ERROR 4316 (HY000): sequence does not exist
ERROR 4317 (HY000): sequence parameter %s must be an integer
ERROR 4318 (HY000): INCREMENT must be a nonzero integer
ERROR 4319 (HY000): sequence parameter exceeds maximum size allowed
ERROR 4320 (HY000): MINVALUE must be less than MAXVALUE
ERROR 4321 (HY000): INCREMENT must be less than MAXVALUE minus MINVALUE
ERROR 4322 (HY000): START WITH cannot be less than MINVALUE
ERROR 4323 (HY000): MINVALUE cannot be made to exceed the current value
ERROR 4324 (HY000): START WITH cannot be more than MAXVALUE
ERROR 4325 (HY000): MAXVALUE cannot be made to be less than the current value
ERROR 4326 (HY000): the number of values to CACHE must be greater than 1
ERROR 4327 (HY000): sequence option value out of range
ERROR 4328 (HY000): number to CACHE must be less than one cycle
ERROR 4329 (HY000): descending sequences that CYCLE must specify MINVALUE
ERROR 4330 (HY000): ascending sequences that CYCLE must specify MAXVALUE
ERROR 4331 (HY000): sequence %s no longer exists
ERROR 4332 (HY000): sequence exceeds %s and cannot be instantiated
ERROR 4333 (HY000): divisor is equal to zero
ERROR 4334 (HY000): fail to decrypt data
ERROR 4335 (HY000): fail to encrypt data
ERROR 4337 (HY000): store directory structure error
ERROR 4338 (HY000): open twice
ERROR 4339 (HY000): raid super block not match
ERROR 4340 (HY000): not opened
ERROR 4341 (HY000): target module is not in service
ERROR 4342 (HY000): raid disk not in normal status
ERROR 4343 (HY000): tenant schema is not full
ERROR 4344 (HY000): invalid timestamp
ERROR 4345 (HY000): dir not empty
ERROR 4346 (HY000): schema is not up to date for read
ERROR 4347 (HY000): role (string) does not exist
ERROR 4348 (HY000): role '%.*s' does not exist
ERROR 4349 (HY000): duplicate privilege listed
ERROR 4350 (HY000): the keystore already exists and each tenant can only have at most one
ERROR 4351 (HY000): the keystore is not exist
ERROR 4352 (HY000): the password is wrong for keystore
ERROR 4353 (HY000): tablespace '%.*s' already exists
ERROR 4354 (HY000): tablespace '%.*s' does not exist
ERROR 4355 (HY000): cannot delete a tablespace which is not empty
ERROR 4356 (HY000): floating point precision is out of range(1 to 126)
ERROR 4357 (HY000): numeric precision specifier is out of range (1 to 38)
ERROR 4358 (HY000): numeric scale specifier is out of range (-84 to 127)
ERROR 4359 (HY000): the keystore is not open
ERROR 4360 (HY000): the keystore opened with dont have a master key
ERROR 4361 (HY000): slog active transaction entries reach maximum
ERROR 4362 (HY000): BY ACCESS | SESSION clause not allowed for NOAUDIT
ERROR 4363 (HY000): auditing the object is not supported
ERROR 4364 (HY000): DDL statement cannot be audited with BY SESSION specified
ERROR 4367 (HY000): The data more than 64M(rpc limit), split into smaller task and retry
ERROR 4368 (HY000): cluster %s not exist
ERROR 4369 (HY000): fail to get master key
ERROR 4370 (HY000): tde_method parameter is invalid
ERROR 4371 (HY000): kms server connect failed, may be kms server is down
ERROR 4372 (HY000): kms server is busy, try again
ERROR 4373 (HY000): kms server update key conflict at the same time, please try again
ERROR 4374 (HY000): value larger than specified precision allowed for this column
ERROR 4375 (HY000): observer has disk error
ERROR 4376 (HY000): unimplemented feature
ERROR 4377 (HY000): fatal internal error in [%.*s]
ERROR 4378 (HY000): cluster name conflict
ERROR 4379 (HY000): heap table has reached max row size, cannot insert anymore
ERROR 4381 (HY000): Not supported, deprecated MySQL feature
ERROR 4383 (HY000): transaction id is not ready
ERROR 4386 (HY000): Do not allow removing leader
ERROR 4387 (HY000): Failed to switch resource group
ERROR 4388 (HY000): Unexpected internal error happen, please checkout the internal errcode
ERROR 4389 (HY000): Processing time is too long
ERROR 4390 (HY000): Schema of remote server is not refreshed yet
ERROR 4391 (HY000): ddl sstable version range cross
ERROR 4392 (HY000): disk is hung
ERROR 4393 (HY000): observer start process failure
ERROR 4394 (HY000): observer stop process failure
ERROR 4395 (HY000): observice start process has failure
ERROR 4396 (HY000): Worker thread panic, thread may be terminated or hung
ERROR 4399 (HY000): Unit status is not expected
ERROR 4400 (HY000): Autoinc cache's autoinc version is not equal to request's autoinc version