OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase AI Database

V4.6.3
  • Introduction
    • Overview
    • Core features
    • System architecture
  • Get Started
    • Get started with OceanBase AI Database
  • Deploy
    • Choose an appropriate deployment plan
    • Deployment process
    • Before deployment
      • Prepare servers
      • Configure Servers
      • Prepare object storage
      • Prepare installation packages
      • Deploy OAT
    • Add a server
    • Deploy OCP
      • OCP deployment overview
      • Upload installation packages
      • Create MetaDB
      • Deploy OCP
    • Deploy OceanBase AI Database
      • Create an object storage configuration
      • Deploy a LogService cluster by using OCP
      • Deploy an OceanBase AI Database cluster using OCP
    • (Optional) Deploy OBProxy
    • Deploy Java SDK
    • Recommended configurations
  • Connect
    • Overview of connection methods
    • Clients
      • MySQL client
      • OBClient
      • ODC
    • GUI tools
      • DBeaver
      • Navicat
    • Drivers and ORMs
      • Connect via driver or ORM framework
      • Examples
        • C#
          • MySQL Connector/C
        • Go
          • Go-SQL-Driver/MySQL
          • GORM
        • Java
          • Connector/J
          • Spring JDBC
          • SpringBoot
          • SpringBatch
          • SpringDataJPA
          • Hibernate
          • MyBatis
          • TestContainers
        • PHP
          • EXT
          • MySQLi
          • PDO
        • Python
          • PyMySQL
          • mysqlclient
          • MySQL-connector-python
          • SQLAlchemy
          • Django
          • peewee
    • Connection pool
      • Database connection pool configuration
      • Tomcat
      • C3P0
      • Proxool
      • HikariCP
      • DBCP
      • Commons Pool
      • Druid
      • JDBC
    • Connect to OceanBase AI Database by using SDK
  • Design Database Schema
    • Overview of database schema design
    • Table design
    • Data distribution
    • Indexes
    • Data types
    • Logical table
      • Logical table overview
      • Agent hybrid search scenario
        • Overview
        • Quick start
        • Collection and namespace management
        • Write data
        • Search data
        • Indexes and embedding functions
        • Monitoring and maintenance
        • API reference
      • Flash application scenario
        • Overview
        • Limitations and constraints
        • Connect
        • Quick start
        • Collection and app management
        • Data operations
  • Data Pipeline
    • Data ingestion
      • Data migration
        • Data migration overview
        • Use mydumper and myloader to migrate data from a MySQL database
        • Use DBCAT to migrate table structures from a MySQL database
        • Use DataX to migrate table data from a MySQL database
        • Use DBCAT to migrate table structures from an Oracle database
        • Use DataX to migrate table data from an Oracle database
        • Use DBCAT to migrate table structures from a DB2 LUW database
        • Migrate from CSV files
          • Use DataX
          • Use LOAD DATA
        • Migrate by using SQL statements
          • Migrate data between tables
          • Migrate resource units
          • Export data using the OUTFILE statement
      • Data import
        • Data import overview
        • Import data by using the LOAD DATA statement
        • INSERT INTO SELECT
          • Use the INSERT INTO SELECT FROM FILES statement for direct load
          • Import data from external tables using INSERT INTO SELECT
        • Import data via direct load using the CREATE TABLE AS SELECT statement
        • Import data by using obloader
    • Data delivery
      • Export data
      • Data lake
        • Data lake overview
        • Data lake integration
          • Access Hive tables through HMS Catalog
          • Load an Iceberg table through Catalog
          • Read Paimon tables by using plugins
          • ODPS Catalog and external tables
          • Catalogs and external tables
          • File external tables
        • External tables via URL
    • Data sharing
      • Automatic catalog data synchronization
      • Manual catalog data synchronization
  • Data Processing
    • Structured data processing
      • In-database processing
      • Materialized views
      • Data processing tools
    • Unstructured data processing
      • Vector embedding
        • Overview of Vector Embedding Technology
        • Use the AI_EMBED function
        • Use external embedding models
  • Data Branching
    • Overview of Fork
    • Fork Table
    • Fork Database
  • AI Search
    • Vector search
      • Vector search overview
      • Perform vector search using SQL
      • Vector data types overview
      • Store vector data
      • Vector index
        • Overview of vector indexes
        • Vector index memory management
        • Dense index
          • Overview of dense indexes
          • Index type selection
          • HNSW series indexes
          • IVF series indexes
        • Sparse index
          • In-memory sparse vector index
        • Monitor and maintain indexes
        • Index performance optimization
      • Search index
      • Use SQL functions
      • Vector nearest neighbor search
      • FAQ on AI scenarios
    • Semantic search
    • Full-text search
    • Hybrid search
    • Rerank search
  • Query Acceleration
    • Statistics
    • Choose the query parallelism
    • Accelerate queries with materialized views
  • Manage
    • Log in to an user tenant
    • Manage clusters
      • Cluster overview
      • Compute service management
        • 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
          • Reset cluster parameters
          • Update object storage access credentials
        • Data load balancing
          • Data load balancing overview
          • Transfer a partition
          • Cancel a partition transfer task
          • Cancel a balance job
          • Stop and resume a balance job
          • Table group weight management
            • Aggregation of user tables under a database
            • Set table group weights
            • Clear a table group's weight
            • Application scenarios of table group weight balancing
          • Partition weight management
            • Set partition weights
            • Clear partition weights
          • Partition balance management
            • Configure a scheduled partition balancing task
            • Manually trigger partition balancing
            • View the configurations of a scheduled partition balancing task
            • View the trigger history of scheduled partition balancing tasks
            • View background partition balancing tasks
            • View the history of background partition balancing tasks
          • GTS exclusive application case
      • Object storage management
        • Object storage overview
        • Update object storage information
        • Object storage-related views and parameters
        • FAQ on object storage
      • LogService management
        • LogService parameters
        • LogService operations
          • View a LogService node
          • Add a LogService node
          • Delete a LogService node
          • Replace a LogService node
          • Rotate LogService access credentials
          • View LogService parameters
          • Modify LogService parameters
        • LogService load balancing
          • LogService load balancing overview
          • View the load balancing status
          • Configure the load balancing strategy
    • Manage tenants
      • Tenant introduction
      • Tenant capacity
      • Tenant types
      • User tenant introduction
      • Tenant system variables
      • Common tenant operations
        • Create a tenant
        • Resource isolation
          • Resource isolation overview
          • Configure cgroup
          • Configure global CPU resource isolation for foreground and background tasks
          • Calibrate disk performance
          • Configure resource isolation within a tenant
          • Update a plan directive
          • Delete a plan directive
          • Delete a resource management plan
          • Delete a resource group
          • Clear cgroup configurations
          • Resource isolation configuration examples for background tasks
        • View tenant and resource information
        • View and set the tenant allowlist
        • View tenant system variables
        • Modify tenant system variables
        • Scale in/out
          • Introduction to tenant scaling
          • Resource planning for tenant scaling
          • Tenant pre-scaling
          • Scale tenants by adjusting resource specifications
          • Scale tenants by adjusting the unit number
          • Scale tenants by adjusting the primary zone
          • Smooth scaling application scenarios
        • Modify attributes of a resource pool
        • Modify tenant attributes
        • 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 resource pools from a tenant
          • Merge and split a resource pool
          • Drop a resource pool
        • Manage resource specifications
          • View resource specifications
          • Modify a unit config
          • Drop a unit config
    • Manage log streams
      • Create a log stream
      • Modify a log stream
    • Manage replicas
      • Replicas
      • Replica distribution
        • Locality
        • Common locality operations
          • View locality
          • Modify locality
          • Add a replica
          • Reduce replicas
          • Adjust the distribution of replicas
          • View the locality change history
          • Replica migration
          • Modify the quorum size of a log stream
          • Cancel a replica task
      • Traffic distribution
      • Data distribution
    • High availability
      • High availability overview
      • Multi-replica disaster recovery
        • Data link introduction
        • High availability at the proxy layer
        • High availability at the database layer
        • Disaster recovery deployment solutions
      • Manage recycle bin
        • Overview of the recycle bin
        • Enable or disable the recycle bin
        • View recycle bin objects
        • Restore objects from the recycle bin
        • Clean up the recycle bin
      • Flashback query
    • Security and permissions
      • Overview of security permissions
      • Identification and authentication
        • Identity authentication
          • Identity authentication
          • Password complexity
          • Handle login failures
      • Access control
        • Overview of access control
        • Users and permissions
          • User and permission overview
          • Permissions
            • Permission classification
            • Create a user
            • Grant privileges directly
            • Privilege delegation
            • Role management
              • Role management overview
              • Create a role
              • Add privileges to a role
              • Grant roles to users or other roles
              • Activate a role
              • View roles
              • Revoke privileges from a role
              • Revoke roles from a user or role
              • Drop a role
            • Indirect authorization
            • View user privileges
            • Revoke privileges
            • Lock or unlock a user
            • Drop a user
        • Row-level security
          • Row-level security
        • Network security access control
        • RPC connection authentication
      • Data encryption
        • Data encryption overview
        • Data transmission encryption
          • Overview of data transmission encryption
          • Transport encryption for OBServer
          • ODP transmission encryption
        • Tenant master key management
          • Overview of tenant master keys
          • Generate tenant master key
        • Data storage encryption
          • Overview of database transparent encryption
          • Set up transparent data encryption for a newly created table
          • Enable transparent data encryption for an existing table
          • Decrypt a table
        • Column encryption
          • Column encryption overview
          • Create a column encryption rule
          • Column encryption privilege management
          • FAQ on column encryption
      • Security audit
        • Security audit overview
        • Security audit
          • Enable security auditing
          • Set an auditing rule
          • View auditing records
          • Disable security auditing
    • Backup and restore
      • Overview of physical backup and restore
      • Physical backup and restore with a minimal experience
      • Log archive
        • Overview of log archiving
        • Prepare for log archiving
        • Enable archiving mode
        • Suspend archiving
        • Disable archiving mode
        • View piece information
        • View archiving progress
        • View the archiving history
        • View archive parameters
        • Change the archive destination
        • Clear the archive path configuration
        • Introduction to log archiving views
      • Data backup
        • Data backup overview
        • Prepare for backup
        • Initiate a full data backup
        • Back up parameters
        • Stop a backup
        • View the data backup progress
        • View data backup results
        • View data backup parameters
        • Change the backup destination
        • Introduction to data backup-related views
      • Update object storage key information
      • Clear backup data
        • Automatic backup cleanup
          • Automatically clean up expired backups
          • Delete a cleanup policy
        • Manual backup cleanup
          • Manually trigger expired backup cleanup
          • Manually clean up specified backup or archive data
          • Manually clear a backup or archive path
        • Cancel a cleanup task
        • View backup cleanup progress
        • View backup cleanup results
        • Introduction to backup cleanup parameters
        • Introduction to cleanup-related views
      • Restore data
        • Preparations before restore
        • Perform physical restore
        • Restore from a specified path
        • Cancel physical restore
        • View the physical restore progress
        • View the result of physical restore
        • Segment-based log replay for a standby tenant
        • Convert a standby tenant into a primary tenant
        • Upgrade a tenant after restore is complete
        • Introduction to physical restore parameters
        • Introduction to views related to physical restore
      • Backup and restore performance tuning
      • Appendix: S3 path format
    • Monitor
      • Monitoring overview
      • Metrics
        • System monitoring
          • Overview of system monitoring metrics
          • SYSSTAT metrics
          • Wait events
          • Lock events
        • SQL monitoring
          • Overview of SQL monitoring
          • SQL audit
          • Execution plans
      • Root service events
      • Cases
    • Logs
      • Log overview
      • Log levels
      • Log interpretation
      • Log stability
      • Log control methods
      • Log compression and decompression
      • Log monitoring metrics
      • Alert logs
      • 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
  • Performance Test
    • TPC-DS
      • OceanBase AI Database TPC-DS test
      • OceanBase AI Database TPC-DS test report
    • TPC-H
      • OceanBase AI Database TPC-H test
      • OceanBase AI Database TPC-H test report
  • Reference
    • System management
      • Configuration management
        • Introduction to Configuration Management
        • Set parameters
        • Set variables
      • Storage management
        • Minor compaction management
          • Overview of minor compaction
          • Automatic minor compaction
          • Manually trigger a minor compaction
          • View minor compaction information
          • Modify minor compaction settings
        • Major compaction management
          • Overview of major compaction management
          • Automatically trigger a major compaction
          • Schedule daily tenant major compactions
          • Window compaction
          • Adaptive compaction
          • Manually trigger a major compaction
          • View major compaction information
          • Manually control a major compaction
          • Modify major compaction configuration
        • Data compression
          • Data compression overview
          • Use data encoding and compression
        • Use the TTL feature
        • Custom hot and cold data storage policies
          • Overview of custom hot/cold storage policies
          • Create a table-level hot/cold storage policy
          • Create a partition-level hot/cold storage policy
          • Modify a table-level hot/cold storage policy
          • Modify a partition-level hot/cold storage policy
          • O&M guide for custom hot/cold storage policies
      • Memory management
        • Memory management overview
        • Memory structure
        • Set the maximum memory for a database
        • Internal system memory management
        • Memory management within a tenant
        • Plan cache memory management
        • Memleak-based regular memory leak diagnostics mechanism
        • View memory usage information
        • Common memory issues
      • Process management
        • Overview of OceanBase AI Database threads
        • Multi-tenant threads
        • View thread status
        • Background threads of OceanBase AI Database
        • FAQ about multi-tenant threads
      • Disk management
        • Configure dynamic expansion of disk data files
        • View disk space usage of a tenant or table
    • Database object management
      • Overview of database object management
      • Create and manage databases
        • Create a database
        • View databases
        • Modify a database
        • Drop a database
      • Create and manage tables
        • About tables
        • Create a table
        • Column Skip Index attribute
        • Define an auto-increment column
        • Define column constraints
        • View tables
        • Modify a table
        • Change the attribute of a replicated table
        • Truncate a table
        • Drop a table
        • Lock a table
        • Create and manage external tables
          • External tables and external files
          • Create and query external tables
          • Create a partitioned external table
          • Manage external files
          • Data type mappings
      • Create and manage partitions
        • Partitioning overview
        • Create a partitioned table
        • Partition splitting
          • Overview of partition splitting
          • Manually split a partition
          • Automatic partition splitting
          • Recommended configurations for automatic partitioning
        • Dynamic partitioning
          • Overview of dynamic partitioning
          • Create a dynamic partitioned table
          • View a dynamic partitioned table
          • Modify a dynamic partitioned table
          • Dynamic partition management tasks
        • Modify partitioning rules
        • Add a partition
        • Drop a partition
        • Truncate partitions
        • Partition pruning
        • Query data from a specified partition
        • Create indexes on partitioned tables
          • Index overview
          • Local index
          • Global index
        • Partition exchange
      • Create and manage table groups
        • About table groups
        • Create a table group
        • View table group information
        • Add tables to a table group
        • Modify the SHARDING attribute of a table group
        • Manage tables within a table group
        • Delete a table group
      • Create and manage indexes
        • About indexes
        • Create an index
        • View indexes
        • Monitor indexes
        • Drop an index
        • List of system functions supported for function-based indexes
        • List of system functions not supported for function-based indexes
      • Manage views
        • Manage regular views
        • Manage materialized views
          • Overview of materialized views
          • Materialized view logs
          • Create a materialized view
          • Refresh a materialized view
          • Query rewrite using materialized views
          • Query materialized views
          • Modify materialized view attributes
          • Drop a materialized view
          • Materialized view resource isolation
      • Create and manage sequences
        • Create a sequence
        • View sequences
        • Reference a sequence
        • Modify a sequence
        • Drop a sequence
      • Create and manage triggers
        • Overview
        • Create a DML trigger
        • View trigger information
        • Drop a trigger
      • Create and manage DBLinks
        • Create a DBLink
        • View created DBLinks
        • Manage DBLinks
        • Access data in a remote database through DBLink
        • Drop a DBLink
      • Create and manage catalogs
        • Overview of Catalog
        • Create a catalog
        • View catalogs
        • Drop a catalog
    • Write and read data
      • Write data
        • Insert data
        • Update data
        • Delete data
        • Replace data
        • Generate test data in batches
      • Read data
        • Single-table query
        • Join tables
          • INNER JOIN
          • FULL JOIN
          • LEFT JOIN
          • RIGHT JOIN
          • Subqueries
          • Lateral derived table
        • Use operators and functions in queries
          • Use arithmetic operators in queries
          • Use numeric functions in queries
          • Use string concatenation operators in queries
          • Use string functions in queries
          • Use time 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
          • Lock query results with SELECT FOR UPDATE
          • Lock in share mode
          • Use regular expressions in queries
        • Query using DBLink
        • Set operations
    • Transaction management
      • Transaction management 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
    • AI Function service
      • Overview of AI Function Service
      • Get started with AI Function Service
      • AI Function Service Permissions
      • Register an AI model
      • Interaction with AI models (Batch File)
      • Syntax and examples of AI functions
      • View AI model information
    • SQL reference
      • SQL syntax
        • System tenants
          • Overview of management commands
          • ALTER SYSTEM
            • ACTIVATE STANDBY
            • ADD REPLICA
            • ADD RESTORE SOURCE
            • ARCHIVELOG
            • BOOTSTRAP
            • BACKUP KEY
            • BACKUP
            • BACKUP CLUSTER PARAMETERS
            • BALANCE TASK
            • BALANCE JOB
            • CANCEL BACKUP
            • CANCEL DELETE BACKUP
            • CANCEL MIGRATE UNIT
            • CANCEL REPLICA TASK
            • CANCEL RESTORE
            • CANCEL RECOVER TABLE
            • CANCEL TRANSFER PARTITION
            • CREATE LS
            • CLEAR RESTORE SOURCE
            • DELETE BACKUP POLICY
            • DELETE BACKUP ALL
            • DELETE BACKUPSET/ARCHIVELOG_PIECE
            • DELETE OBSOLETE BACKUP
            • LOAD MODULE DATA
            • MAJOR AND MINOR
            • MIGRATE REPLICA
            • MIGRATE UNIT
            • MODIFY LS
            • MODIFY PAXOS_REPLICA_NUM
            • MODIFY REPLICA
            • NOARCHIVELOG
            • FLUSH PLAN CACHE
            • FLUSH SEQUENCE CACHE
            • FLUSH LOCAL_CACHE
            • FLASHBACK STANDBY LOG
            • JOB
            • SET LOG_RESTORE_SOURCE
            • PARAMETER
            • RECOVER STANDBY
            • RECOVER STANDBY CANCEL
            • REMOVE REPLICA
            • REFRESH
            • RESTORE
            • RESTORE PREVIEW
            • SET DATA_BACKUP_DEST
            • SERVER
            • SERVICE_NAME
            • SWITCHOVER
            • SET LOG_ARCHIVE_DEST
            • SET LOG_ARCHIVE_DEST_STATE
            • THROTTLE
            • TRANSFER PARTITION
            • TTL
            • WASH MEMORY FRAGMENTATION
            • 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
          • SHOW RESTORE PREVIEW
        • User tenants
          • Basic elements
            • ROWID Pseudo-Column
            • Data types
              • Overview of data types
              • Numeric types
                • Overview of numeric types
                • Integer types
                • Fixed-point types
                • Floating-point types
                • BIT-Value type
              • Datetime types
                • Overview of date and time types
                • DATE, DATETIME and TIMESTAMP types
                • TIME type
                • YEAR type
              • String types
                • Character type overview
                • CHAR and VARCHAR
                • BINARY and VARBINARY
              • Large objects and text types
                • Overview of LOB and text types
                • BLOB type
                • TEXT type
                • STRING type
                • LOB types
                • LOB_WRITEAPPEND
              • Enumeration types
              • Collection types
              • JSON data types
                • Overview of the JSON data type
                • Create a JSON value
                • Query and modify JSON values
                • JSON data type conversion
                • Update partial data in a JSON document
                • Semi-structured encoding
              • Spatial data types
                • Overview of spatial data types
                • Spatial Reference System (SRS)
                • Create a spatial column
                • Create a spatial index
                • Spatial data formats
              • Roaring bitmap types
                • Overview of Efficient Compression for Bitmap Data Types
                • Create an efficient compressed bitmap column
              • Array data types
                • Overview of Array Element Types
                • Create an array column
              • Map data types
                • Overview of mapped data types
                • Create a mapped column
            • Expressions
              • Overview of Expressions
              • Syntax of Expressions
              • Simple Expressions
              • Compound Expressions
              • Conditional Expressions
              • Column Expressions
              • Date and time expressions
              • Function Expressions
              • Interval Expressions
              • Scalar subquery expressions
              • List of Expressions
              • Data type conversion rules
            • Character set and collation
              • Overview
              • Character sets
              • Collation
              • Database-level character set and collation
              • Table-level character set and collation
              • Column-level character set and collation
              • Character expression character sets and collations
              • Character set and collation of client connections
            • Literals
              • Overview of Literals
              • String text
              • Numbers
              • Date and time values
              • Bit value
              • Boolean values
              • NULL values
            • Schema object name
            • User-defined variables
            • Annotations
              • Hints
                • Overview of hints
                • Control query optimization using the Query Block Name and QB_NAME hint
                • Hint list
                  • Global hints
                    • Optimizer Stats Hint under Global Hint Types
                    • Transform hint under global hints
                    • Other hints under global hints
                  • Optimizer hints
                    • Access path hints under the Optimized hint type
                    • Join Order Hint under Optimized Hint Type
                    • Join Operation Hint under Optimized Hint Type
                    • Subquery hint under Optimized hint type
                    • Group by hint under optimized hint type
                    • DISTINCT hint under Optimized hint type
                    • Set hint under Optimized hint type
                    • Distributed DML Hints under Optimized Hint Type
                    • Vector Index Hint under Optimized Hint Type
                  • Transform hints
                    • Stmt Transform Hint under the Transform Hint Type
                    • Cost Based Transform Hint under the Transform Hint Type
                    • Transform Hints of the Heuristics Type
                    • Other hints under the Transform hint type
                  • Outline-related hint
            • Comments
          • Operators
            • Operator overview
            • Operator precedence
            • Arithmetic operators
            • Bitwise operators
            • Comparison operators
            • Logical operators
            • Assignment operators
            • Date and time operators
            • Character concatenation operators
            • BINARY conversion operator
            • CASE Conditional Operator
          • Functions
            • Function overview
            • Single-row functions
              • Datetime 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
                • DATE_TRUNC
                • MONTHS_ADD
                • FORMATDATETIME
                • TOUNIXTIMESTAMP
                • parseDateTime
              • 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
                • KEYVALUE
                • LCASE
                • LEFT
                • LENGTH
                • LOCATE
                • LOWER
                • LPAD
                • LTRIM
                • MAKE_SET
                • MAX_PT
                • MD5_CONCAT_WS
                • MID
                • OCT
                • OCTET_LENGTH
                • ORD
                • POSITION
                • QUOTE
                • REGEXP
                • REGEXP_INSTR
                • REGEXP_LIKE
                • REGEXP_REPLACE
                • REGEXP_SUBSTR
                • REPEAT
                • REPLACE
                • REVERSE
                • RIGHT
                • RLIKE
                • RPAD
                • RTRIM
                • SPACE
                • SPLIT_PART
                • STRCMP
                • SUBSTR
                • SUBSTRING
                • SUBSTRING_INDEX
                • TRIM
                • UCASE
                • UNHEX
                • UPPER
                • URL_DECODE
                • URL_ENCODE
                • WEIGHT_STRING
                • TO_BASE64
                • FROM_BASE64
                • SOUNDEX
                • EDITDISTANCE
              • Conversion functions
                • CAST
                • CONVERT
                • DECODE_TRACE_ID
                • SCN_TO_TIMESTAMP
                • TIMESTAMP_TO_SCN
                • TO_CHAR(character)
                • TO_CHAR(number)
                • TO_CHAR(datetime)
                • TO_DATE
              • 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
                • PI
                • NORMAL
                • 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
              • ARG_MAX
              • ARG_MIN
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • GROUP_CONCAT
              • GROUPING
              • MAX
              • MIN
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • STRING_AGG
              • AVG_WEIGHTED
              • ARBITRARY
              • ANY
              • GROUPCONCAT
              • STDDEVSAMP
              • UNIQ
              • VARSAMP
            • 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
              • PERCENTILE_CONT
              • RANK
              • ROW_NUMBER
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • LAGINFRAME
              • LEADINFRAME
            • Encryption functions
              • AES_DECRYPT
              • AES_ENCRYPT
              • COMPRESS
              • DECODE
              • DES_DECRYPT
              • DES_ENCRYPT
              • ENCODE
              • ENCRYPT
              • ENHANCED_AES_ENCRYPT
              • ENHANCED_AES_DECRYPT
              • MD5
              • PASSWORD
              • UNCOMPRESS
              • UNCOMPRESSED_LENGTH
              • RANDOM_BYTES
              • SHA
              • SHA1
              • SHA2
              • VALIDATE_PASSWORD_STRENGTH
              • SM3
              • SM4_ENCRYPT
              • SM4_DECRYPT
            • Information functions
              • BENCHMARK
              • CATALOG
              • CHARSET
              • COERCIBILITY
              • COLLATION
              • CONNECTION_ID
              • CURRENT_ROLE
              • CURRENT_USER
              • DATABASE
              • FOUND_ROWS
              • LAST_INSERT_ID
              • LAST_INSERT_ID Behavior Description
              • ICU_VERSION
              • OB_TRANSACTION_ID
              • ROW_COUNT
              • SCHEMA
              • SESSION_USER
              • SYSTEM_USER
              • USER
              • VERSION
              • OB_VERSION
            • JSON functions
              • Overview of JSON functions
              • Functions for creating JSON text
                • JSON_ARRAY
                • JSON_OBJECT
                • JSON_QUOTE
              • Functions for searching JSON text
                • JSON_CONTAINS
                • JSON_CONTAINS_PATH
                • JSON_EXTRACT
                • JSON_KEYS
                • JSON_OVERLAPS
                • JSON_SEARCH
                • JSON_VALUE
                • MEMBER OF
              • Functions for modifying JSON text
                • JSON_ARRAY_APPEND
                • JSON_APPEND
                • JSON_ARRAY_INSERT
                • JSON_INSERT
                • JSON_MERGE
                • JSON_MERGE_PATCH
                • JSON_MERGE_PRESERVE
                • JSON_REMOVE
                • JSON_REPLACE
                • JSON_SET
                • JSON_UNQUOTE
              • Functions for returning JSON text properties
                • JSON_DEPTH
                • JSON_LENGTH
                • JSON_TYPE
                • JSON_VALID
              • JSON_TABLE function
              • JSON utility functions
                • JSON_PRETTY
                • JSON_STORAGE_SIZE
              • JSON aggregate functions
                • JSON_ARRAYAGG
                • JSON_OBJECTAGG
              • JSON schema validation functions
                • JSON_SCHEMA_VALID
                • JSON_SCHEMA_VALIDATION_REPORT
            • XML functions
              • Overview of XML functions
              • Functions for querying XML data
                • EXTRACTVALUE
              • Functions for modifying XML data
                • UPDATEXML
            • Table functions
              • Overview of TABLE FUNCTIONS
              • FILES table function
            • Spatial functions
              • Overview of Spatial Functions
              • Create a geometric value function
              • Spatial operators
              • Spatial relationship functions
              • Geometric property functions
              • Geometric format conversion functions
              • Spatial analysis functions
              • Spatial Constructors
              • Spatial accessor functions
              • Spatial format conversion functions
              • Geometric Processing Functions
              • _ST_GeoHash
            • Performance schema functions
              • FORMAT_BYTES
              • FORMAT_PICO_TIME
            • Lock functions
              • Overview of Lock Functions
              • GET_LOCK
              • IS_FREE_LOCK
              • IS_USED_LOCK
              • RELEASE_ALL_LOCKS()
              • RELEASE_LOCK
            • Bitmap functions
              • Overview of bitmap functions
              • Bitmap Constructor
              • Bitmap cardinality functions
              • Bitmap arithmetic functions
              • Bitmap predicate functions
              • Bitmap output functions
              • Bitmap aggregate functions
            • Array functions
              • Overview of array functions
              • Array constructor
              • Array comparison functions
              • Array output functions
              • Array functions
            • Text processing functions
              • TOKENIZE
            • Audit functions
              • Overview of audit functions
              • AUDIT_LOG_FILTER_REMOVE_FILTER
              • AUDIT_LOG_FILTER_REMOVE_USER
              • AUDIT_LOG_FILTER_SET_FILTER
              • AUDIT_LOG_FILTER_SET_USER
            • Map functions
              • Overview of mapping functions
              • Constructor of Map
              • Mapping judgment function
              • Mapping functions
            • 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
              • MATCH AGAINST
              • NVL
              • UUID_TO_BIN
              • SLEEP
              • UUID
              • UUID_SHORT
              • VALUES
              • ISNAN
          • Queries and subqueries
            • Overview
            • Subquery
            • Connections
            • Full-text query
          • SQL statements
            • General syntax
            • Generalized Table Expressions
            • ALTER COMPILE
            • ALTER DATABASE
            • ALTER LOCATION
            • ALTER MATERIALIZED VIEW
            • ALTER MATERIALIZED VIEW LOG
            • ALTER OUTLINE
            • ALTER EXTERNAL TABLE
            • ALTER SENSITIVE RULE
            • ALTER POLICY
            • ALTER SEQUENCE
            • ALTER/CHANGE/MODIFY EXTERNAL_STORAGE_DEST
            • ALTER SYSTEM FLUSH SEQUENCE CACHE
            • MAJOR AND MINOR
            • STORAGE_CACHE_POLICY_EXECUTOR
            • ALTER TABLE
            • ALTER TABLEGROUP
            • ALTER TABLESPACE
            • ALTER USER
            • ALTER VIEW
            • ALTER INSTANCE ROTATE INNODB MASTER KEY
            • ALTER EVENT
            • ANALYZE
            • CACHE INDEX
            • CREATE CONCURRENT_LIMITING_RULE
            • CREATE DATABASE
            • CREATE DATABASE LINK
            • CREATE EXTERNAL CATALOG
            • CREATE EXTERNAL TABLE
            • CREATE INDEX
            • CREATE LOCATION
            • CREATE MATERIALIZED VIEW
            • CREATE MATERIALIZED VIEW LOG
            • CREATE OUTLINE
            • CREATE POLICY
            • CREATE FORMAT OUTLINE
            • CREATE ROLE
            • CREATE SENSITIVE RULE
            • CREATE SEQUENCE
            • CREATE TABLE
            • CREATE TABLEGROUP
            • CREATE TABLESPACE
            • CREATE USER
            • CREATE VIEW
            • CHECKSUM TABLE
            • CREATE EVENT
            • DEALLOCATE PREPARE
            • DROP DATABASE LINK
            • DELETE
            • DESCRIBE
            • DROP CATALOG
            • DROP CONCURRENT_LIMITING_RULE
            • DROP DATABASE
            • DROP EVENT
            • DROP INDEX
            • DROP LOCATION
            • DROP MATERIALIZED VIEW
            • DROP MATERIALIZED VIEW LOG
            • DROP OUTLINE
            • DROP ROLE
            • DROP SENSITIVE RULE
            • DROP POLICY
            • DROP TABLE
            • DROP TABLEGROUP
            • DROP TABLESPACE
            • DROP SEQUENCE
            • DROP USER
            • DROP VIEW
            • EXECUTE
            • EXPLAIN
            • FLASHBACK
            • FLUSH TABLE
            • GRANT
            • HELP
            • INSERT
            • KILL
            • LOAD DATA
            • LOAD_FILE
            • LOAD INDEX INTO CACHE
            • LOCK TABLES
            • OPTIMIZE
            • PREPARE
            • PURGE
            • PURGE RECYCLEBIN
            • RENAME USER
            • RENAME TABLE
            • REPLACE
            • REPAIR TABLE
            • REMOVE
            • REVOKE
            • SAVEPOINT
            • SCHEMA
            • SELECT INTO
            • SET DEFAULT ROLE
            • SELECT
              • SELECT
              • JOIN clause
              • WINDOW clause
              • UNION clause
              • HYBRID_SEARCH
              • PARTITION TIER
            • SET
            • SET CATALOG
            • SET CHARSET
            • SET NAMES
            • SET PASSWORD
            • SET ROLE
            • SET TRANSACTION
            • SHOW
            • SUBMIT JOB
            • SHOW JOB STATUS
            • CANCEL JOB
            • TRANSACTION
            • TRUNCATE TABLE
            • UNLOCK TABLES
            • UPDATE
            • USE
            • VALUES
            • XA TRANSACTION
          • DDL feature
            • Overview of DDL features
            • Online DDL and Offline DDL Operations
            • Index operations
            • Primary key operations
            • Column operations
            • Generate columns
            • Foreign key operations
            • Table operations
            • Partition operations
            • Column type change rules
            • Number type conversion rules
          • Pseudo columns
            • Overview of PseudoColumns
            • PARTITIONID Pseudo Column
            • Sequence Pseudocolumns
          • Conditions
            • Overview of SQL Conditions
            • Condition priorities
            • Comparison conditions
            • Logical conditions
            • Pattern matching conditions
            • Null value conditions
            • BETWEEN condition
            • EXISTS condition
            • IN Condition
            • JSON Member Conditions
            • Boolean test conditions
      • SQL specifications and practices
        • SQL Writing Restrictions
        • SQL writing specifications
          • SELECT statement writing specifications
          • DML statement writing guidelines
          • DDL statement writing guidelines
          • Multi-table association guidelines
          • Table scan method specifications
          • Transaction specifications
          • Usage guidelines for cache
          • Guidelines for Using HINTS
          • Other related specifications
        • SQL statement examples
          • Implicit type conversion related
          • Suggestions on using JOIN tables
          • Weak-consistency read
          • Paginated query
      • Reserved keywords
      • Data type conversion behavior in strict mode
    • PL reference
      • What is PL
        • PL Overview
        • Key features of PL
        • Architecture of PL
      • PL syntax structure
      • PL stored procedures
        • Overview of stored programs
        • Variables of stored programs
        • Stored procedure
        • Stored Procedures and Privilege Management
        • Stored functions
        • External storage functions
        • Trigger
        • EVENT
        • Limitations on stored programs
        • SQL Transpiler
        • PL asynchronous commit optimization
      • PL cursors
        • Cursor overview
        • Cursor execution process
        • Limitations on server-side 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 of exception handling
        • DECLARE ... CONDITION
        • DECLARE ... HANDLER
        • GET DIAGNOSTICS
        • RESIGNAL
        • SIGNAL
        • Scope of handlers
        • Diagnostic section
        • Exception Handling and OUT/INOUT Parameters
        • Limitations on exception handling
      • PL system packages
        • Overview of system packages
        • DBMS_AI_SERVICE
          • Overview of DBMS_AI_SERVICE
          • CREATE_AI_MODEL
          • DROP_AI_MODEL
          • CREATE_AI_MODEL_ENDPOINT
          • ALTER_AI_MODEL_ENDPOINT
          • DROP_AI_MODEL_ENDPOINT
          • REGISTER_PROVIDER
          • ALTER_PROVIDER
          • UNREGISTER_PROVIDER
          • ALTER_MODEL_PROFILE
          • DROP_MODEL_PROFILE
          • CREATE_AI_GATEWAY
          • ALTER_AI_GATEWAY
          • DROP_AI_GATEWAY
        • DBMS_ASYNC_INDEX
          • Overview of DBMS_ASYNC_INDEX
          • FORCEMERGE
        • DBMS_DAILY_MAINTENANCE
          • Overview of DBMS_DAILY_MAINTENANCE
          • TRIGGER_WINDOW_COMPACTION_PROC
          • SET_THREAD_COUNT
        • DBMS_HYBRID_SEARCH
          • Overview of DBMS_HYBRID_SEARCH
          • SEARCH
          • GET_SQL
        • DBMS_MVIEW
          • Overview of DBMS_MVIEW
          • PURGE_LOG
          • REFRESH
          • KILL_REFRESH
          • REFRESH_REPORT
        • DBMS_MVIEW_STATS
          • Overview of DBMS_MVIEW_STATS
          • PURGE_REFRESH_STATS
          • SET_MVREF_STATS_PARAMS
          • SET_SYSTEM_DEFAULT
        • DBMS_PARTITION
          • Overview of DBMS_PARTITION
          • MANAGE_DYNAMIC_PARTITION
        • DBMS_RESOURCE_MANAGER
          • Overview of DBMS_RESOURCE_MANAGER
          • CREATE_CONSUMER_GROUP
          • CREATE_PLAN
          • CREATE_PLAN_DIRECTIVE
          • COPY_PLAN
          • DELETE_CONSUMER_GROUP
          • DELETE_PLAN
          • DELETE_PLAN_DIRECTIVE
          • System Packages
          • UPDATE_PLAN_DIRECTIVE
        • DBMS_STATS
          • Overview of DBMS_STATS
          • ALTER_STATS_HISTORY_RETENTION
          • CREATE_STAT_TABLE
          • DELETE_CATALOG_GLOBAL_PREFS
          • DELETE_CATALOG_TABLE_PREFS
          • DELETE_COLUMN_STATS
          • DELETE_INDEX_STATS
          • DELETE_TABLE_STATS
          • DELETE_SCHEMA_STATS
          • DELETE_SCHEMA_PREFS
          • DELETE_SYSTEM_STATS
          • DELETE_TABLE_PREFS
          • DROP_STAT_TABLE
          • EXPORT_COLUMN_STATS
          • EXPORT_INDEX_STATS
          • EXPORT_TABLE_STATS
          • EXPORT_SCHEMA_STATS
          • FLUSH_DATABASE_MONITORING_INFO
          • GATHER_CATALOG_TABLE_STATS
          • GATHER_INDEX_STATS
          • GATHER_TABLE_STATS
          • GATHER_SCHEMA_STATS
          • GATHER_SYSTEM_STATS
          • GET_CATALOG_GLOBAL_PREFS
          • GET_CATALOG_PREFS
          • 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_CATALOG_PARTITION_STAT
          • LOCK_CATALOG_TABLE_STAT
          • 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_CATALOG_GLOBAL_PREFS
          • SET_CATALOG_TABLE_PREFS
          • SET_COLUMN_STATS
          • SET_INDEX_STATS
          • SET_TABLE_STATS
          • SET_GLOBAL_PREFS
          • SET_PARAM
          • SET_SCHEMA_PREFS
          • SET_SYSTEM_STATS
          • SET_TABLE_PREFS
          • UNLOCK_CATALOG_PARTITION_STAT
          • UNLOCK_CATALOG_TABLE_STAT
          • UNLOCK_PARTITION_STATS
          • UNLOCK_SCHEMA_STATS
          • UNLOCK_TABLE_STATS
          • CANCEL_GATHER_STATS
          • COPY_TABLE_STATS
        • DBMS_TRUSTED_CERTIFICATE_MANAGER
          • Overview of DBMS_TRUSTED_CERTIFICATE_MANAGER
          • ADD_TRUSTED_CERTIFICATE
          • DELETE_TRUSTED_CERTIFICATE
          • UPDATE_TRUSTED_CERTIFICATE
        • DBMS_UDR
          • Overview of DBMS_UDR
          • CREATE_RULE
          • DISABLE_RULE
          • ENABLE_RULE
          • REMOVE_RULE
        • DBMS_VECTOR
          • Overview of DBMS_VECTOR
          • REBUILD_INDEX
          • INDEX_VECTOR_MEMORY_ESTIMATE
          • INDEX_VECTOR_MEMORY_ADVISOR
          • FLUSH_INDEX
          • COMPACT_INDEX
          • TRIGGER_ASYNC_TASK
          • ALTER_INDEX_PARAMS
        • DBMS_WORKLOAD_REPOSITORY
          • Overview of DBMS_WORKLOAD_REPOSITORY
          • ASH_REPORT
          • CREATE_SNAPSHOT
          • DROP_SNAPSHOT_RANGE
          • MODIFY_SNAPSHOT_SETTINGS
        • DBMS_SESSION
          • Overview of DBMS_SESSION
          • SET_IDENTIFIER
          • CLEAR_IDENTIFIER
        • DBMS_APPLICATION_INFO
          • Overview of DBMS_APPLICATION_INFO
          • READ_CLIENT_INFO
          • READ_MODULE
          • SET_ACTION
          • SET_CLIENT_INFO
          • SET_MODULE
        • DBMS_XPLAN
          • Overview of DBMS_XPLAN
          • DISPLAY_ACTIVE_SESSION_PLAN
          • DISPLAY_CURSOR
          • DISPLAY
          • DISABLE_OPT_TRACE
          • DISPLAY_SQL_PLAN_BASELINE
          • ENABLE_OPT_TRACE
          • SET_OPT_TRACE_PARAMETER
        • DBMS_XPROFILE
          • Overview of DBMS_XPROFILE
          • DISPLAY_PROFILE
        • DBMS_BALANCE
          • Overview of DBMS_BALANCE
          • SET_BALANCE_WEIGHT
          • CLEAR_BALANCE_WEIGHT
          • TRIGGER_PARTITION_BALANCE
          • SET_TABLEGROUP_BALANCE_WEIGHT
          • CLEAR_TABLEGROUP_BALANCE_WEIGHT
        • DBMS_OB_LIMIT_CALCULATOR
          • Overview of DBMS_OB_LIMIT_CALCULATOR
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_UNIT
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_LOGIC_RES
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT
        • DBMS_EXTERNAL_TABLE
          • Overview of DBMS_EXTERNAL_TABLE
          • AUTO_REFRESH_EXTERNAL_TABLE
        • DBMS_JAVA
          • Overview of DBMS_JAVA
          • LOADJAVA
          • DROPJAVA
          • GRANT_PERMISSION
          • RESTRICT_PERMISSION
          • REVOKE_PERMISSION
          • DISABLE_PERMISSION
          • ENABLE_PERMISSION
          • DELETE_PERMISSION
        • DBMS_PYTHON
          • Overview of DBMS_PYTHON
          • DROPPYTHON
          • LOADPYTHON
        • DBMS_DATA_DICT
          • DBMS_DATA_DICT
      • Reserved and Non-Reserved PL Keywords
    • System views
      • Overview of system views
      • Overview of system views
      • SYS tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.TRIGGERS
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_DATABASE_PRIVILEGE
          • oceanbase.CDB_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.CDB_IND_COLUMNS
          • oceanbase.CDB_IND_PARTITIONS
          • oceanbase.CDB_IND_SUBPARTITIONS
          • CDB_INDEX_USAGE
          • oceanbase.CDB_INDEXES
          • CDB_MVIEW_LOGS
          • oceanbase.CDB_MVIEW_RUNNING_JOBS
          • CDB_MVIEWS
          • CDB_MVREF_CHANGE_STATS
          • CDB_MVREF_RUN_STATS
          • CDB_MVREF_STATS
          • CDB_MVREF_STATS_PARAMS
          • CDB_MVREF_STATS_SYS_DEFAULTS
          • CDB_MVREF_STMT_STATS
          • oceanbase.CDB_OB_ACCESS_POINT
          • oceanbase.CDB_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.CDB_OB_AI_BATCH_TASKS
          • oceanbase.CDB_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.CDB_OB_AI_GATEWAYS
          • oceanbase.CDB_OB_AI_MODEL_ENDPOINTS
          • oceanbase.CDB_OB_AI_MODEL_PROFILES
          • oceanbase.CDB_OB_AI_MODEL_PROVIDERS
          • oceanbase.CDB_OB_AI_MODELS
          • oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.CDB_OB_ARCHIVE_DEST
          • oceanbase.CDB_OB_ARCHIVELOG
          • oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
          • oceanbase.CDB_OB_AUTO_INCREMENT
          • CDB_OB_AUX_STATISTICS
          • oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_JOBS
          • oceanbase.CDB_OB_BACKUP_DELETE_POLICY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASKS
          • oceanbase.CDB_OB_BACKUP_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_JOBS
          • oceanbase.CDB_OB_BACKUP_PARAMETER
          • oceanbase.CDB_OB_BACKUP_SET_FILES
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASKS
          • oceanbase.CDB_OB_BALANCE_JOB_HISTORY
          • oceanbase.CDB_OB_BALANCE_JOBS
          • oceanbase.CDB_OB_BALANCE_TASK_HISTORY
          • oceanbase.CDB_OB_BALANCE_TASKS
          • oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_CCL_RULES
          • oceanbase.CDB_OB_CS_REPLICA_STATS
          • oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.CDB_OB_DATABASES
          • oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.CDB_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_FREEZE_INFO
          • oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_JOBS
          • oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_TASKS
          • oceanbase.CDB_OB_KV_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_KV_TTL_TASKS
          • oceanbase.CDB_OB_LOG_RESTORE_SOURCE
          • oceanbase.CDB_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.CDB_OB_LOB_CHECK_TASKS
          • oceanbase.CDB_OB_LS
          • oceanbase.CDB_OB_LS_HISTORY
          • oceanbase.CDB_OB_LS_LOCATIONS
          • oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.CDB_OB_LS_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.CDB_OB_MAJOR_COMPACTION
          • oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_RECOVER_TABLE_JOBS
          • oceanbase.CDB_OB_SERVICES
          • oceanbase.CDB_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_RESTORE_PROGRESS
          • oceanbase.CDB_OB_RSRC_DIRECTIVES
          • oceanbase.CDB_OB_SENSITIVE_COLUMNS
          • oceanbase.CDB_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.CDB_OB_SENSITIVE_RULES
          • oceanbase.CDB_OB_SERVER_SPACE_USAGE
          • oceanbase.CDB_OB_SPACE_USAGE
          • oceanbase.CDB_OB_STORAGE_SPACE_USAGE
          • oceanbase.CDB_OB_SYS_VARIABLES
          • oceanbase.CDB_OB_STORAGE_IO_USAGE
          • oceanbase.CDB_OB_SPM_EVO_RESULT
          • oceanbase.CDB_OB_TABLE_LOCATIONS
          • oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_TABLES
          • oceanbase.CDB_OB_TABLEGROUPS
          • oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_TABLET_REPLICAS
          • oceanbase.CDB_OB_TABLET_TO_LS
          • oceanbase.CDB_OB_TABLE_SPACE_USAGE
          • oceanbase.CDB_OB_TEMP_FILES
          • oceanbase.CDB_OB_TENANT_EVENT_HISTORY
          • oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASKS
          • oceanbase.CDB_OB_TTL_TASKS
          • oceanbase.CDB_OB_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_USERS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASKS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.CDB_OBJECTS
          • oceanbase.CDB_PART_INDEXES
          • oceanbase.CDB_PART_KEY_COLUMNS
          • oceanbase.CDB_PART_TABLES
          • oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS
          • 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_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.CDB_WR_CONTROL
          • oceanbase.CDB_WR_EVENT_NAME
          • oceanbase.CDB_WR_RES_MGR_SYSSTAT
          • oceanbase.CDB_WR_SNAPSHOT
          • oceanbase.CDB_WR_SQL_PLAN
          • oceanbase.CDB_WR_SQLSTAT
          • oceanbase.CDB_WR_SQLTEXT
          • oceanbase.CDB_WR_STATNAME
          • oceanbase.CDB_WR_SYS_TIME_MODEL
          • oceanbase.CDB_WR_SYSSTAT
          • oceanbase.CDB_WR_SYSTEM_EVENT
          • oceanbase.CDB_OB_EXTERNAL_RESOURCES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • oceanbase.DBA_MVREF_CHANGE_STATS
          • oceanbase.DBA_MVREF_RUN_STATS
          • oceanbase.DBA_MVREF_STATS
          • oceanbase.DBA_MVREF_STATS_PARAMS
          • oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS
          • oceanbase.DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.DBA_OB_AI_BATCH_TASKS
          • oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.DBA_OB_AI_GATEWAYS
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODEL_PROFILES
          • oceanbase.DBA_OB_AI_MODEL_PROVIDERS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.DBA_OB_LOB_CHECK_TASKS
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_RESOURCE_POOLS
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SERVER_EVENT_HISTORY
          • oceanbase.DBA_OB_SERVER_JOBS
          • oceanbase.DBA_OB_SERVERS
          • oceanbase.DBA_OB_STORAGE_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_SPM_EVO_RESULT
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • 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_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TENANT_JOBS
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • DBA_OB_TRUSTED_ROOT_CERTIFICATE
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_UNIT_CONFIGS
          • oceanbase.DBA_OB_UNIT_JOBS
          • oceanbase.DBA_OB_UNITS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OB_ZONES
          • oceanbase.DBA_OB_ZONE_STORAGE
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_RES_MGR_SYSSTAT
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQL_PLAN
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
        • Performance views
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$LATCH
          • GV$OB_ACTIVE_SESSION_HISTORY
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_CGROUP_CONFIG
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_HNSW_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_IO_BENCHMARK
          • GV$OB_IO_CALIBRATION_STATUS
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_KV_CONNECTIONS
          • GV$OB_LOG_STAT
          • GV$OB_LOG_TRANSPORT_DEST_STAT
          • GV$OB_LS_SNAPSHOTS
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_MEMSTORE_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_NIC_INFO
          • GV$OB_RPC_INCOMING
          • GV$OB_RPC_OUTGOING
          • GV$OB_PARAMETERS
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PLUGINS
          • GV$OB_PROCESSLIST
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$OB_PX_P2P_DATAHUB
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_PX_WORKER_STAT
          • GV$OB_RES_MGR_SYSSTAT
          • GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SERVERS
          • GV$OB_SERVER_STORAGE
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SESSION_PS_INFO
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$SQL_PLAN_MONITOR
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_LOCAL_CACHE
          • GV$OB_LOCAL_CACHE_DIAGNOSE
          • GV$OB_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TABLET_REPLICA_INFO
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • GV$OB_TENANT_RUNTIME_INFO
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_TRANSACTION_SCHEDULERS
          • GV$OB_UNITS
          • GV$OB_VECTOR_MEMORY
          • GV$SESSION_EVENT
          • GV$SESSION_LONGOPS
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$OB_KV_CLIENT_INFO
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • V$OB_PL_CACHE_OBJECT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • V$ENCRYPTED_TABLESPACES
          • V$EVENT_NAME
          • V$LATCH
          • V$OB_ACTIVE_SESSION_HISTORY
          • V$OB_ARCHIVE_DEST_STATUS
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_COMPATIBILITY_CONTROL
          • V$OB_CGROUP_CONFIG
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DYNAMIC_PARTITION_TABLES
          • V$OB_ENCRYPTED_TABLES
          • V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_IO_BENCHMARK
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_HNSW_INDEX_INFO
          • V$OB_IO_CALIBRATION_STATUS
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_KV_CONNECTIONS
          • V$OB_LOG_STAT
          • V$OB_LOG_TRANSPORT_DEST_STAT
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_LS_SNAPSHOTS
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_MEMSTORE_INFO
          • V$OB_MERGE_INFO
          • V$OB_NIC_INFO
          • V$OB_RPC_INCOMING
          • V$OB_RPC_OUTGOING
          • V$OB_PARAMETERS
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PLUGINS
          • V$OB_PROCESSLIST
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$OB_PX_P2P_DATAHUB
          • V$OB_PX_TARGET_MONITOR
          • V$OB_PX_WORKER_STAT
          • V$OB_RES_MGR_SYSSTAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SERVERS
          • V$OB_SERVER_STORAGE
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SESSION_PS_INFO
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • V$OB_SQL_AUDIT
          • V$OB_SQL_CCL_STATUS
          • V$SQL_JOIN_FILTER
          • V$OB_SQL_PLAN
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SQLSTAT
          • V$OB_SHARED_SSTABLES
          • V$OB_SSTABLES
          • V$OB_LOCAL_CACHE
          • V$OB_LOCAL_CACHE_DIAGNOSE
          • V$OB_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TABLET_REPLICA_INFO
          • V$OB_TENANT_MEMORY
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TENANT_RUNTIME_INFO
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$RSRC_PLAN
          • V$SESSION_LONGOPS
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SQL_MONITOR_STATNAME
          • V$SQL_PLAN_MONITOR
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$STATNAME
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$OB_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
          • V$OB_VECTOR_MEMORY
      • User tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.ST_GEOMETRY_COLUMNS
          • information_schema.ST_SPATIAL_REFERENCE_SYSTEMS
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.TRIGGERS
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.audit_log_filter
          • mysql.audit_log_user
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_JAVA_POLICY
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • oceanbase.DBA_MVREF_CHANGE_STATS
          • oceanbase.DBA_MVREF_RUN_STATS
          • oceanbase.DBA_MVREF_STATS
          • oceanbase.DBA_MVREF_STATS_PARAMS
          • oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS
          • oceanbase.DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.DBA_OB_AI_BATCH_TASKS
          • oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.DBA_OB_AI_GATEWAYS
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODEL_PROFILES
          • oceanbase.DBA_OB_AI_MODEL_PROVIDERS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.DBA_OB_LOB_CHECK_TASKS
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SENSITIVE_COLUMNS
          • oceanbase.DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.DBA_OB_SENSITIVE_RULES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.DBA_OB_STORAGE_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_SPM_EVO_RESULT
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • 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_TABLE_SPACE_USAGE
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RLS_POLICIES
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_RES_MGR_SYSSTAT
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQL_PLAN
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
          • oceanbase.USER_JAVA_POLICY
        • Performance views
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$LATCH
          • GV$OB_ACTIVE_SESSION_HISTORY
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_CGROUP_CONFIG
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HNSW_INDEX_INFO
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_CLIENT_INFO
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_KV_CONNECTIONS
          • GV$OB_LOG_STAT
          • GV$OB_LOG_TRANSPORT_DEST_STAT
          • GV$OB_LS_SNAPSHOTS
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_MEMSTORE_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_NIC_INFO
          • GV$OB_RPC_INCOMING
          • GV$OB_RPC_OUTGOING
          • GV$OB_PARAMETERS
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PROCESSLIST
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$OB_PX_P2P_DATAHUB
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_PX_WORKER_STAT
          • GV$OB_RES_MGR_SYSSTAT
          • GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SESSION_PS_INFO
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_LOCAL_CACHE
          • GV$OB_LOCAL_CACHE_DIAGNOSE
          • GV$OB_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TABLET_MACRO_CACHE_STAT
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_TRANSACTION_SCHEDULERS
          • GV$OB_UNITS
          • GV$OB_VECTOR_MEMORY
          • GV$SESSION_EVENT
          • GV$SESSION_LONGOPS
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_PLAN_MONITOR
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • V$OB_PL_CACHE_OBJECT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • V$EVENT_NAME
          • V$LATCH
          • V$OB_ACTIVE_SESSION_HISTORY
          • V$OB_ARCHIVE_DEST_STATUS
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_COMPATIBILITY_CONTROL
          • V$OB_CGROUP_CONFIG
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DYNAMIC_PARTITION_TABLES
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_HNSW_INDEX_INFO
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_KV_CONNECTIONS
          • V$OB_LOG_STAT
          • V$OB_LOG_TRANSPORT_DEST_STAT
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_LS_SNAPSHOTS
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_MEMSTORE_INFO
          • V$OB_MERGE_INFO
          • V$OB_NIC_INFO
          • V$OB_RPC_INCOMING
          • V$OB_RPC_OUTGOING
          • V$OB_PARAMETERS
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PROCESSLIST
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$OB_PX_P2P_DATAHUB
          • V$OB_PX_TARGET_MONITOR
          • V$OB_PX_WORKER_STAT
          • V$OB_RES_MGR_SYSSTAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$RSRC_PLAN
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SESSION_PS_INFO
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • V$OB_SQL_AUDIT
          • V$OB_SQL_CCL_STATUS
          • V$SQL_JOIN_FILTER
          • V$OB_SQL_PLAN
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SQLSTAT
          • V$OB_SHARED_SSTABLES
          • V$OB_SSTABLES
          • V$OB_LOCAL_CACHE
          • V$OB_LOCAL_CACHE_DIAGNOSE
          • V$OB_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TABLET_MACRO_CACHE_STAT
          • V$OB_TENANT_MEMORY
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$OB_VECTOR_MEMORY
          • V$RESTORE_POINT
          • V$SESSION_LONGOPS
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SQL_MONITOR_STATNAME
          • V$SQL_PLAN_MONITOR
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$STATNAME
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$OB_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
      • Overview of Metrics
      • Common wait events
    • Parameters and system variables
      • Overview of parameters and system variables
      • Parameters
        • Parameter overview
        • Cluster-level parameters
          • alert_log_level
          • all_cluster_list
          • all_server_list
          • autoinc_cache_refresh_interval
          • async_ps_cursor_max_count
          • balancer_log_interval
          • balancer_task_timeout
          • system_protected_sys_variables
          • system-protected-tenant-parameters
          • balancer_tolerance_percentage
          • bf_cache_miss_count_threshold
          • bf_cache_priority
          • builtin_db_data_verify_cycle
          • cache_wash_threshold
          • clog_io_isolation_mode
          • clog_sync_time_warn_threshold
          • cluster
          • cluster_id
          • config_additional_dir
          • cpu_count
          • data_dir
          • data_disk_usage_limit_percentage
          • data_disk_write_limit_percentage
          • data_storage_error_tolerance_time
          • data_storage_warning_tolerance_time
          • datafile_disk_percentage
          • datafile_maxsize
          • datafile_next
          • datafile_size
          • dead_socket_detection_timeout
          • debug_sync_timeout
          • default_compress_func
          • default_row_format
          • devname
          • diag_syslog_per_error_limit
          • disk_io_thread_count
          • dtl_buffer_size
          • enable_asan_for_memory_context
          • enable_async_syslog
          • enable_cgroup
          • enable_dblink
          • enable_ddl
          • enable_global_background_resource_isolation
          • enable_logservice
          • enable_major_freeze
          • enable_ob_error_msg_style
          • enable_ob_ratelimit
          • enable_perf_event
          • enable_record_trace_id
          • enable_record_trace_log
          • enable_rereplication
          • enable_rich_error_msg
          • enable_rpc_authentication_bypass
          • enable_sql_audit
          • enable_sql_operator_dump
          • enable_sys_table_ddl
          • enable_sys_unit_standalone
          • enable_syslog_recycle
          • enable_syslog_wf
          • enable_tcp_keepalive
          • enable_upgrade_mode
          • ext_plugin_config
          • fuse_row_cache_priority
          • global_background_cpu_quota
          • high_priority_net_thread_count
          • ignore_replay_checksum_error
          • index_block_cache_priority
          • internal_sql_execute_timeout
          • io_scheduler_thread_count
          • large_query_threshold
          • large_query_worker_percentage
          • leak_mod_to_check
          • lease_time
          • local_ip
          • location_cache_cpu_quota
          • 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_disk_percentage
          • log_disk_size
          • logservice_access_point
          • log_storage_warning_trigger_percentage
          • log_storage_warning_tolerance_time
          • ls_meta_table_check_interval
          • max_string_print_length
          • max_syslog_file_count
          • memory_chunk_cache_size
          • memory_limit
          • memory_limit_percentage
          • memory_reserved
          • memstore_limit_percentage
          • micro_block_merge_verify_level
          • migration_disable_time
          • min_observer_version
          • mysql_port
          • net_thread_count
          • ob_event_history_recycle_interval
          • ob_ratelimit_stat_period
          • ob_startup_mode
          • ob_python_home
          • obconfig_url
          • observer_id
          • ob_storage_s3_url_encode_type
          • ob_enable_java_env
          • ob_java_home
          • ob_java_connector_path
          • ob_java_opts
          • ob_enable_java_udf_sandbox
          • ob_enable_utl_http
          • opt_tab_stat_cache_priority
          • plan_cache_evict_interval
          • px_task_size
          • plugins_load
          • recyclebin_object_expire_time
          • resource_hard_limit
          • rest_oauth2_credential_refresh_interval
          • rest_oauth2_credential_evict_time
          • rootservice_async_task_queue_size
          • rootservice_async_task_thread_count
          • rootservice_list
          • rootservice_ready_check_interval
          • row_compaction_update_limit
          • rpc_client_authentication_method
          • rpc_port
          • rpc_server_authentication_method
          • 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
          • sql_login_thread_count
          • sql_net_thread_count
          • sql_protocol_min_tls_version
          • ssl_client_authentication
          • ssl_external_kms_info
          • stack_size
          • standby_fetch_log_bandwidth_limit
          • storage_meta_cache_priority
          • strict_check_os_params
          • sync_io_thread_count
          • sys_bkgd_migration_change_member_list_timeout
          • sys_bkgd_migration_retry_num
          • sys_bkgd_net_percentage
          • sys_ckpt_thread_score
          • syslog_compress_func
          • syslog_disk_size
          • syslog_file_uncompressed_count
          • syslog_io_bandwidth_limit
          • syslog_level
          • system_memory
          • tablet_ls_cache_priority
          • tablet_meta_table_check_interval
          • tablet_meta_table_scan_batch_count
          • tablet_size
          • tcp_keepcnt
          • tcp_keepidle
          • tcp_keepintvl
          • tenant_task_queue_size
          • trace_log_slow_query_watermark
          • trx_2pc_retry_interval
          • unit_gc_wait_time
          • use_large_pages
          • user_block_cache_priority
          • user_row_cache_priority
          • virtual_table_location_cache_expire_time
          • weak_read_version_refresh_interval
          • workers_per_cpu_quota
          • zone
        • Tenant-level parameters
          • agent_db_background_delete_thread_score
          • agent_db_hot_namespace_ttl
          • arbitration_timeout
          • archive_lag_target
          • approx_count_distinct_precision
          • audit_log_buffer_size
          • audit_log_compression
          • attach_shared_sstable_thread_score
          • audit_log_enable
          • audit_log_format
          • audit_log_max_size
          • audit_log_path
          • audit_log_prune_seconds
          • audit_log_query_sql
          • audit_log_rotate_on_size
          • audit_log_strategy
          • audit_sys_operations
          • audit_trail
          • auto_split_tablet_size
          • backup_data_file_size
          • balancer_idle_time
          • catalog_sync_target
          • choose_migration_source_policy
          • compaction_dag_cnt_limit
          • compaction_high_thread_score
          • compaction_low_thread_score
          • compaction_mid_thread_score
          • compaction_schedule_tablet_batch_cnt
          • compatible
          • connection_control_failed_connections_threshold
          • connection_control_max_connection_delay
          • connection_control_min_connection_delay
          • cpu_quota_concurrency
          • ddl_thread_score
          • default_auto_increment_mode
          • default_delta_format
          • default_enable_extended_rowid
          • default_load_mode
          • default_micro_block_format_version
          • default_progressive_merge_num
          • default_skip_index_level
          • default_storage_cache_policy
          • default_table_merge_engine
          • default_table_organization
          • default_table_store_format
          • direct_load_allow_fallback
          • ddl_high_thread_score
          • document_ai_file_max_size
          • dtl_compress_func
          • dump_data_dictionary_to_log_interval
          • enable_agent_db_background_task
          • enable_adaptive_plan_cache
          • enable_auto_split
          • enable_database_sharding_none
          • enable_early_lock_release
          • enable_hbase_rowkey_ttl
          • enable_pl_rich_error_msg
          • enable_gts_standalone
          • enable_kv_group_commit
          • enable_kv_ttl
          • enable_lake_table_parallel_resolving
          • enable_lock_priority
          • enable_manual_storage_cache_policy
          • enable_mlog_auto_maintenance
          • enable_monotonic_weak_read
          • enable_mv_binlog_minimal_mode
          • enable_ls_leader_balance
          • enable_rebalance
          • enable_sql_extension
          • enable_transfer
          • enable_ttl
          • enable_user_defined_rewrite_rules
          • enable_window_compaction
          • enable_ps_parameterize
          • external_kms_info
          • external_table_io_hole_size
          • external_table_io_range_size
          • external_table_csv_max_buffer_size
          • ob_vector_search_strategy
          • freeze_trigger_percentage
          • global_index_auto_split_policy
          • ha_high_thread_score
          • ha_low_thread_score
          • ha_mid_thread_score
          • inc_sstable_upload_thread_score
          • shared_gc_executor_thread_score
          • shared_gc_generator_thread_score
          • json_document_max_depth
          • kv_ttl_duty_duration
          • kv_group_commit_batch_size
          • kv_group_commit_rw_mode
          • kv_hbase_client_scanner_timeout_period
          • kv_ttl_delete_max_ops
          • kv_ttl_history_recycle_interval
          • kv_transport_compress_threshold
          • lake_table_pruning_thread_count
          • load_data_diagnosis_log_compression
          • load_data_diagnosis_log_max_size
          • load_vector_index_on_follower
          • lob_enable_block_cache_threshold
          • log_archive_concurrency
          • log_disk_throttling_maximum_duration
          • log_disk_throttling_percentage
          • log_disk_utilization_limit_threshold
          • log_disk_utilization_threshold
          • log_restore_concurrency
          • log_storage_compress_all
          • log_storage_compress_func
          • log_transport_compress_all
          • log_transport_compress_func
          • ls_gc_delay_time
          • ls_scale_out_factor
          • major_compact_trigger
          • major_freeze_duty_time
          • max_partition_num
          • max_stale_time_for_weak_consistency
          • mds_compaction_high_thread_score
          • mds_compaction_mid_thread_score
          • mds_minor_compact_trigger
          • merger_check_interval
          • minor_compact_trigger
          • mlog_trim_interval
          • model_max_retries
          • model_request_timeout
          • mv_refresh_concurrency
          • ob_compaction_schedule_interval
          • ob_enable_batched_multi_statement
          • ob_encoding_granularity
          • ob_enable_java_udf
          • ob_enable_python_udf
          • ob_proxy_readonly_transaction_routing_policy
          • ob_query_switch_leader_retry_timeout
          • ob_ssl_invited_common_names
          • ob_vector_index_active_segment_max_size
          • ob_vector_index_merge_trigger_percentage
          • ob_vector_memory_limit_percentage
          • open_cursors
          • optimizer_index_cost_adj
          • partition_balance_schedule_interval
          • plsql_code_type
          • plsql_debug
          • px_node_policy
          • package_state_sync_max_size
          • px_target_high_watermark
          • px_target_low_watermark
          • px_target_workers_per_cpu
          • px_workers_per_cpu_quota
          • query_memory_limit_percentage
          • query_response_time_flush
          • query_response_time_range_base
          • query_response_time_stats
          • range_optimizer_max_mem_size
          • recover_table_concurrency
          • recover_table_dop
          • replica_parallel_migration_mode
          • result_cache_max_size
          • result_cache_max_result
          • ob_result_cache_evict_percentage
          • ob_deterministic_udf_cache_max_size
          • rpc_memory_limit_percentage
          • shared_log_retention
          • shared_storage_data_check_thread_score
          • spill_compression_codec
          • sql_func_extension_mode
          • sql_work_area
          • standby_db_fetch_log_rpc_timeout
          • standby_db_preferred_upstream_log_region
          • storage_rowsets_size
          • sts_credential
          • suspend_storage_cache_task
          • kv_transport_compress_func
          • tde_method
          • tenant_sql_login_thread_count
          • tenant_sql_net_thread_count
          • temporary_file_max_disk_size
          • ttl_duty_time
          • ttl_thread_score
          • undo_retention
          • vector_index_memory_saving_mode
          • vector_index_optimization_concurrency
          • vector_index_optimize_duty_time
          • vector_task_thread_limit_percent
          • workarea_size_policy
          • writing_throttling_maximum_duration
          • writing_throttling_trigger_percentage
          • zone_deploy_mode
      • System variables
        • Overview of system variables
        • Global variables
          • ap_query_cost_threshold
          • ap_query_route_policy
          • ap_query_replica_fallback
          • activate_all_roles_on_login
          • auto_increment_cache_size
          • auto_increment_increment
          • auto_increment_offset
          • autocommit
          • automatic_sp_privileges
          • binlog_row_image
          • block_encryption_mode
          • character_set_client
          • character_set_connection
          • cardinality_estimation_model
          • character_set_database
          • character_set_filesystem
          • character_set_results
          • character_set_server
          • character_set_system
          • collation_connection
          • collation_database
          • collation_server
          • connect_timeout
          • cte_max_recursion_depth
          • cursor_sharing
          • datadir
          • default_authentication_plugin
          • default_password_lifetime
          • default_storage_engine
          • div_precision_increment
          • error_on_overlap_time
          • event_scheduler
          • explicit_defaults_for_timestamp
          • enable_optimizer_rowgoal
          • foreign_key_checks
          • group_concat_max_len
          • init_connect
          • innodb_stats_persistent
          • innodb_strict_mode
          • interactive_timeout
          • license
          • lc_time_names
          • log_row_value_options
          • long_query_time
          • lower_case_table_names
          • max_allowed_packet
          • max_connections
          • max_sp_recursion_depth
          • max_user_connections
          • mview_refresh_dop
          • net_buffer_length
          • net_read_timeout
          • net_write_timeout
          • ob_bnl_join_cache_size
          • ob_compatibility_mode
          • ob_compatibility_control
          • ob_compatibility_version
          • ob_default_lob_inrow_threshold
          • ob_early_lock_release
          • ob_enable_ps_parameter_anonymous_block
          • ob_enable_pl_async_commit
          • ob_enable_aggregation_pushdown
          • ob_enable_index_direct_select
          • ob_enable_jit
          • ob_enable_pl_cache
          • ob_enable_plan_cache
          • ob_enable_rich_error_msg
          • ob_enable_sql_audit
          • ob_enable_transformation
          • ob_enable_transmission_checksum
          • ob_enable_truncate_flashback
          • ob_log_level
          • ob_max_read_stale_time
          • ob_pl_block_timeout
          • ob_plan_cache_evict_high_percentage
          • ob_plan_cache_evict_low_percentage
          • ob_plan_cache_percentage
          • ob_query_timeout
          • ob_read_consistency
          • ob_reserved_meta_memory_percentage
          • ob_route_policy
          • ob_sql_audit_percentage
          • ob_sql_work_area_percentage
          • ob_table_access_policy
          • ob_tcp_invited_nodes
          • ob_temp_tablespace_size_percentage
          • ob_trx_idle_timeout
          • ob_trx_lock_timeout
          • ob_trx_timeout
          • optimizer_capture_sql_plan_baselines
          • ob_security_version
          • optimizer_dynamic_sampling
          • optimizer_features_enable
          • optimizer_use_sql_plan_baselines
          • parallel_degree_limit
          • parallel_degree_policy
          • parallel_min_scan_time_threshold
          • parallel_servers_target
          • partition_index_dive_limit
          • performance_schema
          • plugin_dir
          • pid_file
          • query_cache_size
          • plsql_optimize_level
          • plsql_can_transform_sql_to_assign
          • port
          • query_cache_type
          • query_rewrite_enabled
          • query_rewrite_integrity
          • read_only
          • recyclebin
          • regexp_stack_limit
          • regexp_time_limit
          • resource_manager_plan
          • socket
          • range_index_dive_limit
          • runtime_bloom_filter_max_size
          • runtime_filter_max_in_num
          • runtime_filter_type
          • runtime_filter_wait_time_ms
          • secure_file_priv
          • server_uuid
          • 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_transpiler
          • sql_warnings
          • system_time_zone
          • time_zone
          • transaction_isolation
          • transaction_read_only
          • tx_isolation
          • tx_read_only
          • 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
          • version
          • version_comment
          • wait_timeout
        • Session variables
          • enable_sql_plan_monitor
          • is_result_accurate
          • identity
          • last_insert_id
          • ob_capability_flag
          • ob_enable_show_trace
          • ob_global_debug_sync
          • ob_hnsw_ef_search
          • ob_ivf_nprobes
          • ob_last_schema_version
          • ob_org_cluster_id
          • ob_proxy_global_variables_version
          • ob_sparse_drop_ratio_search
          • ob_proxy_partition_hit
          • ob_proxy_set_trx_executed
          • ob_trace_info
          • partition_index_dive_limit
          • range_index_dive_limit
          • timestamp
          • tracefile_identifier
    • Error codes
      • Overview of error messages
      • 0001 ~ 3999
      • 4000 ~ 4499
      • 4500 ~ 4999
      • 5000 ~ 5999
      • 6000 ~ 6999
      • 7000 ~ 7999
      • 8000 ~ 8999
      • 9000 ~ 9499
      • 9500 ~ 9999
      • 10000 ~ 12000
      • 22998, 30926, 38104, 38105
    • LogService reference
      • LogService commands
        • Overview of LS-CTRL
        • LS-CTRL commands
          • bootstrap
          • show az
          • show ln
          • show meta
          • show ap
          • show parameter
          • show v-table
          • add ln
          • delete ln
          • set param
          • check
          • upgrade
          • fetch
          • migrate replica
          • rotate-ak
          • param-version-status
      • LogService parameters
        • Overview of Log Service parameters
        • Cluster parameters
          • min_oblogservice_version
          • node_permanent_offline_time_sec
          • stream_replica_task_history_retention_sec
          • object_store_url
          • log_local_target_retention_sec
          • retained_remote_log_blocks
          • log_local_disk_utilization_threshold
          • max_syslog_file_count
          • enable_rebalance
          • load_balance_policy
          • rebalance_interval_sec
          • metric_sample_save_interval_sec
          • max_utilization_threshold
          • min_utilization_threshold
          • log_disk_throttling_percentage
          • log_disk_throttling_maximum_duration
          • rebuild_log_lag_threshold
        • Server parameters
          • cluster_id
          • region
          • az
          • local_ip
          • rpc_port
          • log_disk_size
          • io_worker_count
          • http_port
          • status_thread_pool_size
          • stack_size
          • net_thread_count
          • enable_heap_profile
          • log_disk_percentage
          • memory_limit
          • log_level
          • max_syslog_file_size
          • disk_max_iops
          • disk_max_bandwidth
          • upload_block_concurrency
          • log_cache_memory_percentage
          • log_cache_evict_scan_budget
          • log_cache_enable_write
          • log_cache_enable_read
          • log_cache_metrics_dump_interval_sec
          • ln_id
          • local_storage_dir
      • LogService views
        • Overview of LogService views
        • List of LogService views
        • Virtual views
          • node_load
          • az_load
          • stream_replica_io
        • Internal tables
          • t_stream_upload_mapping
          • t_resource_event
    • OBKV
      • OBKV overview
      • OBKV architecture
      • OBKV-Table
        • OBKV-Table overview
          • OBKV-Table overview
          • Core features of OBKV-Table
          • OBKV-Table deployment overview
        • Quick start with simple key-value storage (Java)
        • Use the OBKV-Table client
          • Java development guide for OBKV-Table
          • Prepare for development with OBKV-Table
          • Connect to a cluster by using the OBKV-Table Java client
          • OBKV-Table examples
            • Write data to OBKV-Table
            • Query data in OBKV-Table
            • Update data in OBKV-Table
            • Delete data from OBKV-Table
          • Set parameters for the OBKV-Table Java client
        • OBKV-Table management
          • OBKV-Table management overview
          • High availability of OBKV-Table
          • Security permissions of OBKV-Table
          • OBKV-Table monitoring metrics
        • OBKV-Table reference
          • Data model of OBKV-Table
          • OBKV-Table operations
          • Data types supported by OBKV-Table
          • Full-text indexes in OBKV-Table
          • Scope of use and examples of global indexes in OBKV-Table
          • Delete expired data from OBKV-Table
          • Group commit in OBKV-Table
          • Weak-consistency reads and near reads in OBKV-Table
          • OBKV-Table related views
        • OBKV-Table FAQ
      • OBKV-HBase
        • Overview of OBKV-HBase
        • Core features of OBKV-HBase
        • OBKV-HBase deployment
        • OBKV-HBase development
          • Overview of OBKV-HBase application development
          • Connect to a cluster by using the OBKV-HBase Java client
          • Migrate HBase business code to OBKV-HBase
          • Data operation examples
        • OBKV-HBase migration guide
        • OBKV-HBase management
          • Overview of OBKV-HBase management
          • High availability of OBKV-HBase
          • Security and permissions in OBKV-HBase
          • OBKV-HBase monitoring metrics
        • Query optimization in OBKV-HBase
        • Performance testing of OBKV-HBase
        • OBKV-HBase reference
          • OBKV-HBase data model
          • OBKV-HBase data model
          • HBase-compatible interfaces
          • HBase-compatible filters
          • Automatic partition splitting in OBKV-HBase
          • Delete expired data in OBKV-HBase
          • OBKV-HBase weak-consistency reads and near reads
          • OBKV-HBase views
        • OBKV-HBase integrations
          • Flink integration
            • Synchronize data to OBKV-HBase by using the Flink connector
            • Access OBKV-HBase by using native Flink
          • Access OBKV-HBase by using Hive
          • Access OBKV-HBase by using Spark
    • Performance tuning
      • Overview
      • Performance related tools
        • System tools
          • Top general purpose tool
          • 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
          • tenant dump info
          • trace log
        • OCP
      • System tuning
        • Operating system parameter tuning
        • Database parameter tuning
          • CPU parameters
          • I/O parameters
          • Memory-related parameters
          • Network transmission parameters
        • ODP parameter tuning
          • CPU-related parameters
          • Network transmission parameters
          • Node routing parameters
      • Performance diagnosis
        • Monitor and diagnose cluster performance
        • Diagnose tenant performance
        • Monitor OBProxy performance
        • Monitor host performance
        • WR management
          • Overview of WR
          • Manage WR
          • Monitor historical session performance
          • Clean up WR data
        • Diagnostic practice: Use TRACE_ID to diagnose materialized view refresh performance issues
        • ASH report
          • Introduction to ASH
          • Generate an ASH report
          • Analyze an ASH report
          • ASH best practices
      • Business model tuning
        • Load balancing
        • SQL diagnostics
        • Distributed transactions
      • SQL tuning
        • SQL request execution process
        • SQL execution plans
          • Introduction to SQL execution plans
          • Execution plan operators
            • TABLE SCAN
            • JOIN
            • GROUP BY
            • WINDOW FUNCTION
            • SUBPLAN FILTER
            • DISTINCT
            • SEQUENCE
            • MATERIAL
            • SORT
            • LIMIT
            • FOR UPDATE
            • SELECT INTO
            • SUBPLAN SCAN
            • UNION
            • INTERSECT
            • EXCEPT/MINUS
            • INSERT
            • DELETE
            • UPDATE
            • EXCHANGE
            • GI
          • Plan cache
          • Fast parameterization
          • Real-time execution plan display
          • SQL optimization practice with EXPLAIN
        • Distributed execution plans
          • Distributed execution and parallel query
          • Distributed plan generation
          • Distributed execution plan scheduling
          • Distributed execution plan management
          • Parallel execution enabling methods and their priority
          • Auto DOP
          • Execution of parallel queries
          • Perform parameter tuning for a parallel query
          • Parallel DML
          • Parallel DDL
        • Parallel execution plans
          • Introduction to parallel execution
          • Classification and optimization of parallel execution
          • Set concurrent execution
            • Concurrency control and queuing
            • Set the degree of parallelism for parallel execution
            • Set parallel execution parameters
          • Diagnose parallel execution issues
          • Tips for parallel execution tuning
          • Quick start of parallel execution
        • SQL tuning
          • Overview of SQL tuning
          • Basic SQL tuning process
          • SQL execution performance monitoring
            • GV$OB_SQL_AUDIT
            • SQL Trace
            • Plan cache views
            • SQL performance analysis example
              • Analyze wait events in queries by using SQL Audit
              • Analyze SQL queries that cause an abrupt RT jitter
              • View and analyze the shape of an execution plan
              • Analyze slow SQL queries
              • Query SQL traffic distribution and QPS
              • 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 certain 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 of statistics collection methods
              • Introduction to histograms
              • Collect statistics manually
              • Automatic statistics collection
              • Online statistics collection
              • Dynamic sampling by the optimizer
            • Statistics management
              • Overview of statistics management
              • Delete statistics
              • Set statistics
              • Import and export statistics
              • Lock and unlock statistics
              • Manage statistics history
              • Manage statistics collection strategies (Prefs)
            • Partitioned table statistics collection and update strategy
            • Monitoring and diagnostics for statistics collection
            • Comprehensive example
          • Query rewrite
            • Overview
            • Rule-based query rewriting
            • Cost-based query rewriting
          • 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 hint
            • Plan binding
            • Execution plan management
        • Related terms
        • FAQ on SQL tuning
    • Database proxy
      • Database connection and routing overview
      • OceanBase Database Proxy (ODP)
      • ODP
        • ODP management overview
        • Manage ODP clusters
          • Create an OBProxy cluster
          • Manage parameters of an OBProxy cluster
          • Delete an OBProxy cluster
          • Upgrade all OBProxies in an OBProxy cluster
          • Restart all OBProxies in an OBProxy cluster
          • Manage OceanBase AI Database clusters connected to OBProxy
          • Monitor the performance of an OBProxy cluster
        • Manage ODP
          • Add an OBProxy
          • Start OBProxy
          • Refresh OBProxy configuration
          • Stop OBProxy
          • Restart OBProxy
          • Delete an OBProxy
          • Upgrade OBProxy
        • OBProxy parameters
      • Physical connections
      • Logical connection
        • Query all sessions
        • Query the details of a session
        • Query the statistics 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
      • OceanBase Call Interface (OBCI)
      • OceanBase Connector/J
      • OceanBase Connector/C
      • OceanBase Connector/ODBC
    • Platforms
      • OceanBase Migration Assessment (OMA)
      • OceanBase Migration Service (OMS)
      • OceanBase Cloud Platform (OCP)
      • OceanBase Developer Center (ODC)
      • OceanBase Admin Toolkit (OAT)
    • Components & tools
      • ob_error
      • Data integration
        • obloader/obdumper
        • OceanBase Binlog Service
        • obcdc
          • Overview of obcdc
          • obcdc parameters
            • Sample configuration file
            • Common obcdc parameters
            • obcdc parameters
          • obcdc development instructions
          • obcdc_tailf
          • Throttling
          • obcdc allowlist and blocklist
          • obcdc supports incremental direct load
          • obcdc supports synchronizing from a standby database
          • Data dictionary support in obcdc
          • FAQ
    • OceanBase AI Database plugins
      • Overview of OceanBase AI Database plugins
      • Tokenizer plugin
      • MySQL external table plugin
  • Release Notes
    • Version number guidelines
    • OceanBase AI Database V4.6.3
    • OceanBase AI Database V4.6.2

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase AI Database
  3. V4.6.3

5000 ~ 5999

Last Updated:2026-11-17 07:33:01

ERROR 5002 (HY000) : Resolve error
ERROR 5010 (21000) : Unknown operator
ERROR 5011 (42000) : Duplicated star
ERROR 5012 (HY000) : Illegal ID
ERROR 5014 (HY000) : Illegal value
ERROR 5016 (HY000) : Generate logical plan error
ERROR 5017 (HY000) : Schema not set
ERROR 5023 (S1004) : unsupport MySQL type (number). Maybe you should use java.sql.Timestamp instead of java.util.Date
ERROR 5031 (HY000) : Column not found
ERROR 5034 (01007) : No user
ERROR 5050 (42710) : User exists
ERROR 5053 (HY093) : Incorrect arguments number to EXECUTE, need %ld arguments but give %ld
ERROR 5058 (42000) : Duplicated parameters
ERROR 5063 (42000) : Unknown hint
ERROR 5066 (HY000) : Session interrupted
ERROR 5071 (42000) : Cannot alter index column
ERROR 5074 (23000) : NOP cannot be used here
ERROR 5081 (25000) : The server is read only now
ERROR 5083 (22000) : invalid obj type for type promotion: left_type=%s right_type=%s
ERROR 5084 (22000) : Can not cast varchar value to bool type
ERROR 5085 (22000) : Not a number Can not cast varchar value to number type
ERROR 5086 (22000) : Not timestamp Can not cast varchar value to timestamp type
ERROR 5087 (22000) : Result value was out of range when cast to number
ERROR 5090 (22000) : Precision was out of range
ERROR 5091 (22000) : Scale value was out of range
ERROR 5092 (42000) : Unknown index
ERROR 5098 (22001) : Data too long(%d>%ld) for column '%s'
ERROR 5099 (42000) : System config unknown
ERROR 5106 (42000) : EXTRACT() expected timestamp or a string as date argument
ERROR 5107 (42000) : Invalid operand type for IS operator, lval=%s
ERROR 5108 (42000) : function LENGTH() expected a varchar argument
ERROR 5110 (42000) : TIME_TO_USEC() expected timestamp or a string as date argument
ERROR 5111 (42000) : USEC_TO_TIME expected a interger number as usec argument
ERROR 5112 (42P01) : Variable %.*s does not exists
ERROR 5114 (42000) : Invalid numeric char '%c'
ERROR 5116 (HY000) : Logical operator child index overflow
ERROR 5117 (HY000) : fail to explain plan
ERROR 5118 (HY000) : fail to copy logical operator
ERROR 5119 (HY000) : fail to generate plan
ERROR 5120 (HY000) : fail to create raw expr
ERROR 5121 (HY000) : fail to generate join order
ERROR 5122 (HY000) : optimizer general error
ERROR 5130 (HY000) : sql resolver no memory
ERROR 5131 (HY000) : plan cache support dml only
ERROR 5133 (42000) : No such grant defined
ERROR 5136 (HY000) : plan exists in plan cache already
ERROR 5137 (HY000) : plan is expired
ERROR 5138 (HY000) : no plan exist
ERROR 5144 (HY000) : COLLATION '%.*s' is notvalid for CHARACTER SET '%.*s'
ERROR 5150 (HY000) : Tenant not in this server
ERROR 5151 (42P01) : tablegroup not exist
ERROR 5156 (HY000) : tenant \'%s\' already exist
ERROR 5157 (HY000) : Unknown tenant '%.*s'
ERROR 5159 (HY000) : tablegroup already exist
ERROR 5160 (HY000) : invalid tenant name specified in connection string
ERROR 5212 (42000) : auto-increment column '%.*s' should not be part of partition key
ERROR 5223 (42000) : wrong ident name
ERROR 5226 (42000) : plan cache memory used reach the high water mark
ERROR 5234 (HY000) : The database \'%.*s\' is read only so it cannot execute this statement
ERROR 5235 (HY000) : The table \'%.*s.%.*s\' is read only so it cannot execute this statement
ERROR 5243 (HY000) : system variables' version maybe different
ERROR 5245 (HY000) : some tasks are skipped, skipped server addr is '%s', the orginal error code is %d
ERROR 5248 (HY000) : Alter table add auto_increment column is dangerous, table_name=\'%.*s\', column_name=\'%s\'
ERROR 5252 (HY000) : Column \'%.*s\' definition is ambiguous. Column has both NULL and NOT NULL attributes
ERROR 5258 (HY000) : Invalid block size, block size should between 1024 and 1048576
ERROR 5260 (HY000) : Tenant \'%.*s\' is locked
ERROR 5264 (HY000) : Outline '%.*s' already exists
ERROR 5265 (HY000) : Outline \'%.*s.%.*s\' doesn\'t exist
ERROR 5267 (HY000) : invalid outline ,error info:%s
ERROR 5268 (HY000) : SQL reach max concurrent num %ld
ERROR 5269 (HY000) : can not perform DDL/DML over objects in Recycle Bin
ERROR 5270 (HY000) : object not in RECYCLE BIN
ERROR 5272 (HY000) : Outline content '%.*s' of outline '%.*s' already exists when added
ERROR 5273 (HY000) : Max concurrent in outline '%.*s' already exists when added
ERROR 5278 (HY000) : This partition value with incorrect charset type
ERROR 5291 (HY000) : The CTXCAT column must be contiguous in the index column list
ERROR 5296 (42000) : there has no readable replica
ERROR 5297 (HY000) : unexpected time zone info transition
ERROR 5298 (HY000) : synonym '%.*s' already exists
ERROR 5299 (HY000) : synonym \'%.*s.%.*s\' doesn\'t exist
ERROR 5300 (HY000) : missing ORDER BY expression in the window specification
ERROR 5301 (HY000) : The argument of the window function should be a constant for a partition
ERROR 5307 (HY000) : Not enough thread resource to execute the query. Require setting parallel_servers_target to a value no less than %ld for this query
ERROR 5309 (HY000) : Ignore sql in restore process
ERROR 5311 (HY000) : Invalid column id for %.*s
ERROR 5312 (HY000) : Duplicated ddl id '%.*s'
ERROR 5319 (HY000) : Child column \'%.*s\' data length cannot be less than parent column \'%.*s\' data length
ERROR 5320 (HY000) : \'%.*s\': used in a foreign key constraint
ERROR 5325 (HY000) : ORDER SIBLINGS BY clause not allowed here
ERROR 5326 (HY000) : when using SYS_CONNECT_BY_PATH function, cannot have separator as part of column value
ERROR 5327 (HY000) : Database can not be specified in public synonym
ERROR 5328 (HY000) : Looping chain of synonyms
ERROR 5329 (HY000) : Cannot create a synonym with same name as object
ERROR 5330 (HY000) : Synonym %s translation is no longer valid
ERROR 5331 (HY000) : name is already used by an existing object
ERROR 5337 (HY000) : rowid is wrong
ERROR 5338 (HY000) : Window Function not allowed here
ERROR 5339 (HY000) : Fail to parse list partition
ERROR 5341 (HY000) : timezone region ID is invalid
ERROR 5342 (HY000) : invalid hex number
ERROR 5343 (42000) : wrong number or types of arguments in call to '%.*s'
ERROR 5345 (HY000) : insufficient parallel query worker available
ERROR 5346 (HY000) : FOR UPDATE of this query expression is not allowed
ERROR 5347 (HY000) : argument should be a function of expressions in PARTITION BY
ERROR 5348 (HY000) : result of string concatenation is too long
ERROR 5350 (HY000) : updating partition key column would cause a partition change
ERROR 5351 (HY000) : invalid type given for an argument
ERROR 5352 (HY000) : specified field not found in datetime or interval
ERROR 5360 (HY000) : insufficient privileges
ERROR 5361 (HY000) : user %.*s lacks CREATE SESSION privilege; logon denied
ERROR 5363 (HY000) : system privileges not granted to '%.*s'
ERROR 5364 (HY000) : only SELECT and ALTER privileges are valid for sequences
ERROR 5365 (HY000) : EXECUTE privilege not allowed for tables
ERROR 5366 (HY000) : only EXECUTE and DEBUG privileges are valid for procedures
ERROR 5367 (HY000) : only EXECUTE, DEBUG, and UNDER privileges are valid for types
ERROR 5368 (HY000) : ADMIN option not granted for role '%.*s'
ERROR 5369 (HY000) : user or role '%.*s' does not exist
ERROR 5370 (HY000) : missing ON keyword
ERROR 5371 (HY000) : grant option does not exist for '%.*s.%.*s'
ERROR 5372 (HY000) : ALTER, INDEX and EXECUTE not allowed for views
ERROR 5373 (HY000) : circular role grant detected
ERROR 5374 (HY000) : invalid privilege on directories
ERROR 5375 (HY000) : directory access denied
ERROR 5376 (HY000) : missing or invalid role name
ERROR 5377 (HY000) : role '%.*s' not granted or does not exist
ERROR 5378 (HY000) : DEFAULT ROLE '%.*s' not granted to user
ERROR 5379 (HY000) : ROLE '%.*s' not granted to '%.*s'
ERROR 5380 (HY000) : cannot GRANT to a role WITH GRANT OPTION
ERROR 5381 (HY000) : duplicate username in list
ERROR 5382 (HY000) : cannot grant %.*s to a role
ERROR 5383 (HY000) : CASCADE CONSTRAINTS must be specified to perform this revoke
ERROR 5384 (HY000) : you may not GRANT/REVOKE privileges to/from yourself
ERROR 5386 (HY000) : Unable to read data -* Table definition has changed
ERROR 5401 (HY000) : resultant data type of virtual column is not supported
ERROR 5403 (HY000) : ddl schema version not match
ERROR 5409 (HY000) : Duplicate object name exists, schema refreshing may be hung
ERROR 5410 (HY000) : Refresh schema failed continuously, ddl may be hung
ERROR 5434 (HY000) : retry sql due to spm
ERROR 5435 (HY000) : outline not reproducible
ERROR 5436 (42000) : TIMESTAMP_TO_SCN expected timestamp argument
ERROR 5437 (42000) : SCN_TO_TIMESTAMP expected a integer number as nsec argument
ERROR 5500 (HY000) : Legitimacy check failed for generated columns
ERROR 5540 (HY000) : System variable '%.*s' is different from the old value solidified for '%.*s'(old value:%.*s)
ERROR 5558 (42000) : %s \'%.*s.%.*s\' already exists
ERROR 5559 (42000) : %s \'%.*s.%.*s\' does not exist
ERROR 5561 (HY000) : Invalid use of window function
ERROR 5562 (HY000) : Duplicate constraint name '%.*s'
ERROR 5563 (HY000) : Constraint not found
ERROR 5564 (HY000) : Duplicate alter index operations on column \'%.*s\'
ERROR 5572 (HY000) : a partition may be split into exactly two new partitions
ERROR 5573 (HY000) : this physical attribute may not be specified for a table partition
ERROR 5574 (HY000) : missing VALUES keyword
ERROR 5575 (HY000) : missing AT or VALUES keyword
ERROR 5578 (HY000) : Plan cache lock conflict
ERROR 5597 (HY000) : last resulting partition cannot contain bounds
ERROR 5598 (HY000) : cannot add partition when DEFAULT partition exists
ERROR 5599 (HY000) : cannot split partition into one partition, use rename instead
ERROR 5600 (HY000) : can not create user %s in sys tenant, name %.*s
ERROR 5601 (HY000) : Percentage should between 1 and 99
ERROR 5603 (0A000) : Attempt to create, alter or drop an index on temporary table already in use
ERROR 5604 (HY000) : invalid NLS parameter string used in SQL function
ERROR 5605 (HY000) : datetime/interval precision is out of range
ERROR 5606 (42000) : Invalid number format model
ERROR 5607 (HY000) : SQL command not properly ended
ERROR 5608 (42000) : invalid number format model
ERROR 5613 (HY000) : too many values
ERROR 5614 (HY000) : not enough values
ERROR 5615 (HY000) : single-row subquery returns more than one row
ERROR 5616 (HY000) : UPDATE ... SET expression must be a subquery
ERROR 5617 (HY000) : inappropriate INTO
ERROR 5619 (HY000) : Column part of using clause can not have qualifier
ERROR 5623 (HY000) : outer join operator (+) not allowed in operand of OR or IN
ERROR 5624 (HY000) : a column may not be outer-joined to a subquery
ERROR 5625 (HY000) : old style outer join (+) cannot be used with ANSI joins
ERROR 5626 (HY000) : outer join operator (+) is not allowed here
ERROR 5627 (HY000) : Schema try again
ERROR 5628 (HY000) : zero-length columns are not allowed
ERROR 5629 (HY000) : year conflicts with Julian date
ERROR 5630 (HY000) : day of year conflicts with Julian date
ERROR 5631 (HY000) : month conflicts with Julian date
ERROR 5632 (HY000) : day of month conflicts with Julian date
ERROR 5633 (HY000) : day of week conflicts with Julian date
ERROR 5634 (HY000) : hour conflicts with seconds in day
ERROR 5635 (HY000) : minutes of hour conflicts with seconds in day
ERROR 5636 (HY000) : seconds of minute conflicts with seconds in day
ERROR 5637 (HY000) : date not valid for month specified
ERROR 5638 (HY000) : input value not long enough for date format
ERROR 5639 (HY000) : (full) year must be between -4713 and +9999, and not be 0
ERROR 5640 (HY000) : quarter must be between 1 and 4
ERROR 5641 (HY000) : not a valid month
ERROR 5642 (HY000) : not a valid day of the week
ERROR 5643 (HY000) : day of year must be between 1 and 365 (366 for leap year)
ERROR 5644 (HY000) : hour must be between 1 and 12
ERROR 5645 (HY000) : hour must be between 0 and 23
ERROR 5646 (HY000) : minutes must be between 0 and 59
ERROR 5647 (HY000) : seconds must be between 0 and 59
ERROR 5648 (HY000) : seconds in day must be between 0 and 86399
ERROR 5649 (HY000) : julian date must be between 1 and 5373484
ERROR 5650 (HY000) : AM/A.M. or PM/P.M. required
ERROR 5651 (HY000) : BC/B.C. or AD/A.D. required
ERROR 5652 (HY000) : format code appears twice
ERROR 5653 (HY000) : day of week may only be specified once
ERROR 5654 (HY000) : signed year precludes use of BC/AD
ERROR 5655 (HY000) : Julian date precludes use of day of year
ERROR 5656 (HY000) : year may only be specified once
ERROR 5657 (HY000) : hour may only be specified once
ERROR 5658 (HY000) : AM/PM conflicts with use of A.M./P.M
ERROR 5659 (HY000) : BC/AD conflicts with use of B.C./A.D
ERROR 5660 (HY000) : month may only be specified once
ERROR 5661 (HY000) : day of week may only be specified once
ERROR 5662 (HY000) : format code cannot appear in date input format
ERROR 5663 (HY000) : a non-numeric character was found where a numeric was expected
ERROR 5664 (HY000) : 'HH24' precludes use of meridian indicator
ERROR 5665 (HY000) : missing or illegal character following the escape character
ERROR 5666 (HY000) : escape character must be character string of length 1
ERROR 5667 (HY000) : day of month must be between 1 and last day of month
ERROR 5668 (HY000) : not a SELECTed expression
ERROR 5670 (HY000) : (full) year must be between -4713 and +9999, and not be 0
ERROR 5671 (HY000) : such unique or primary key already exists in the table
ERROR 5672 (HY000) : such column list already indexed
ERROR 5674 (HY000) : argument '%ld' is out of range
ERROR 5675 (HY000) : ORDER BY item must be the number of a SELECT-list expression
ERROR 5676 (HY000) : the interval is invalid
ERROR 5677 (HY000) : PL/SQL: numeric or value error: %.*s
ERROR 5678 (HY000) : name already used by an existing constraint
ERROR 5679 (HY000) : table must have at least one column that is not invisible
ERROR 5681 (HY000) : Column visibility modifications cannot be combined with any other modified column DDL option
ERROR 5682 (HY000) : The visibility of a column from a table owned by a SYS user cannot be changed
ERROR 5683 (HY000) : too many arguments for function
ERROR 5684 (HY000) : PX sql need retry
ERROR 5685 (HY000) : Tenant '(string)' has been dropped
ERROR 5686 (HY000) : invalid extract field for extract source
ERROR 5687 (42000) : %s \'%.*s.%.*s\' compile error
ERROR 5690 (HY000) : subquery not allowed here
ERROR 5691 (HY000) : date or system variable wrongly specified in CHECK constraint
ERROR 5692 (HY000) : Cannot drop constraint - nonexistent constraint
ERROR 5693 (HY000) : check constraint violated
ERROR 5694 (HY000) : group function is not allowed here
ERROR 5695 (HY000) : policy string not found
ERROR 5696 (HY000) : invalid label string
ERROR 5697 (HY000) : undefined compartment string for policy string
ERROR 5698 (HY000) : undefined level string for policy string
ERROR 5699 (HY000) : undefined group string for policy string
ERROR 5700 (HY000) : LBAC error: %s
ERROR 5701 (HY000) : policy role already exists for policy string
ERROR 5702 (HY000) : NULL or invalid user label: %s
ERROR 5703 (HY000) : Add index failed
ERROR 5704 (HY000) : profile %.*s does not exist
ERROR 5705 (HY000) : invalid resource limit %s
ERROR 5706 (HY000) : profile %.*s already exists
ERROR 5707 (HY000) : profile %.*s has users assigned, cannot drop without CASCADE
ERROR 5708 (HY000) : the leading precision of the interval is too small
ERROR 5709 (HY000) : time zone hour must be between -12 and 14
ERROR 5710 (HY000) : time zone minute must be between -59 and 59
ERROR 5711 (HY000) : not a valid time zone
ERROR 5712 (HY000) : date format is too long for internal buffer
ERROR 5713 (HY000) : cannot validate (%.*s.%.*s) - check constraint violated
ERROR 5714 (HY000) : data manipulation operation not legal on this view
ERROR 5715 (HY000) : virtual column not allowed here
ERROR 5716 (HY000) : cannot modify more than one base table through a join view
ERROR 5721 (HY000) : cannot delete from view without exactly one key-preserved table
ERROR 5722 (HY000) : cannot modify a column which maps to a non key-preserved table
ERROR 5723 (HY000) : cannot perform a DML operation on a read-only view
ERROR 5724 (HY000) : invalid INITRANS option value
ERROR 5725 (HY000) : invalid MAXTRANS option value
ERROR 5726 (HY000) : invalid value for PCTFREE or PCTUSED
ERROR 5727 (HY000) : SQL request should be rerouted
ERROR 5728 (HY000) : illegal argument for function
ERROR 5729 (HY000) : this operator cannot be used with lists
ERROR 5730 (HY000) : SAMPLE percentage must be in the range [0.000001,100)
ERROR 5731 (HY000) : specifying owner's name of the table is not allowed
ERROR 5732 (HY000) : stmt trigger with when clause
ERROR 5732 (HY000) : not enough arguments for function
ERROR 5733 (HY000) : trigger '%.*s' does not exist
ERROR 5734 (HY000) : trigger '%.*s' already exist
ERROR 5735 (HY000) : trigger '%.*s' already exists on another table, cannot replace it
ERROR 5736 (HY000) : error signaled in parallel query server
ERROR 5763 (HY000) : Specified pseudo column or operator not allowed here
ERROR 5764 (HY000) : CONNECT BY loop in user data
ERROR 5765 (HY000) : cannot have join with CONNECT BY
ERROR 5766 (HY000) : CONNECT BY clause required in this query block
ERROR 5768 (HY000) : SYS_CONNECT_BY_PATH function is not allowed here
ERROR 5769 (HY000) : illegal parameter in SYS_CONNECT_BY_PATH function
ERROR 5770 (HY000) : A column value contained the string that the SYS_CONNECT_BY_PATH function was to use to separate column values
ERROR 5771 (HY000) : CONNECT BY ROOT operator is not supported in the START WITH or in the CONNECT BY condition
ERROR 5772 (HY000) : ORDER SIBLINGS BY clause not allowed here
ERROR 5773 (HY000) : NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudo column
ERROR 5774 (HY000) : not enough arguments for function
ERROR 5777 (HY000) : Prepare statement checksum error
ERROR 5778 (HY000) : cannot enable constraint (%.*s) - no such constraint
ERROR 5779 (HY000) : cannot disable constraint (%.*s) - no such constraint
ERROR 5780 (HY000) : PX DOP downgrade from %ld to %ld
ERROR 5785 (HY000) : cannot validate (%.*s.%.*s) - parent keys not found
ERROR 5786 (HY000) : Column check constraint cannot reference other columns
ERROR 5787 (HY000) : batched multi statement execution needs rollback
ERROR 5788 (HY000) : cannot select FOR UPDATE from view with ISTINCT, GROUP BY, etc
ERROR 5789 (HY000) : policy with check option violation
ERROR 5790 (HY000) : policy already applied to table
ERROR 5791 (HY000) : table '%.*s'.'%.*s' is mutating, trigger/function may not see it
ERROR 5792 (HY000) : column is referenced in a multi-column constraint
ERROR 5793 (HY000) : cannot drop parent key column
ERROR 5794 (HY000) : auto increment service busy
ERROR 5795 (HY000) : No insert/update/delete on table with constraint (%.*s.%.*s) disabled and validated
ERROR 5796 (HY000) : active autonomous transaction detected and rolled back
ERROR 5797 (HY000) : ORDER BY not allowed here
ERROR 5798 (HY000) : DISTINCT not allowed here
ERROR 5799 (HY000) : assign user variable with := only allowed in select filed list and as root expression
ERROR 5800 (HY000) : cannot modify constraint (%.*s) - no such constraint
ERROR 5801 (HY000) : implementation restriction: exception handler in nested transaction is illegal
ERROR 5802 (HY000) : invalid ROWID
ERROR 5803 (HY000) : Invalid column in the INSERT VALUES Clause:'%.*s'.'%.*s'
ERROR 5804 (HY000) : incorrect use of the ['%.*s'] operator
ERROR 5805 (HY000) : non-constant expression is not allowed for pivot|unpivot values
ERROR 5806 (HY000) : expect aggregate function inside pivot operation
ERROR 5807 (HY000) : expression must have same datatype as corresponding expression
ERROR 5808 (HY000) : character set mismatch
ERROR 5809 (HY000) : regular expression failed to match
ERROR 5810 (HY000) : invalid regular expression (reg version 0.8)
ERROR 5811 (HY000) : invalid escape \\ sequence in regular expression
ERROR 5812 (HY000) : unmatched bracket in regular expression
ERROR 5813 (HY000) : unmatched parentheses in regular expression
ERROR 5814 (HY000) : invalid back reference in regular expression
ERROR 5815 (HY000) : invalid range in regular expression
ERROR 5816 (HY000) : invalid character class in regular expression
ERROR 5817 (HY000) : invalid collation class in regular expression
ERROR 5818 (HY000) : braces {} not balanced in in regular expression
ERROR 5819 (HY000) : invalid repetition count(s) in regular expression
ERROR 5820 (HY000) : The regular expression was too complex and current library can't be parsed
ERROR 5821 (HY000) : regular expression internal error
ERROR 5822 (HY000) : invalid argument in regular expression
ERROR 5823 (HY000) : character widths of regex and string differ in regular expression
ERROR 5824 (HY000) : invalid embedded option in regular expression
ERROR 5825 (HY000) : nfa has too many states in regular expression, may be the regular expression too long
ERROR 5827 (HY000) : the definition of relative objects have been modified, please check and retry
ERROR 5828 (HY000) : Subscript beyond count
ERROR 5829 (HY000) : PARTITION () clause on non partitioned table
ERROR 5830 (HY000) : Unknown subpartition
ERROR 5831 (HY000) : Invalid SQL ROW LIMITING expression was specified
ERROR 5833 (HY000) : not implemented in SQL static typing engine
ERROR 5834 (HY000) : name is already used by an existing object
ERROR 5835 (HY000) : connection description for remote database not found
ERROR 5836 (HY000) : database link not found
ERROR 5837 (HY000) : Reference to uninitialized composite
ERROR 5838 (HY000) : Reference to uninitialized collection
ERROR 5839 (HY000) : no more rows needed
ERROR 5840 (HY000) : PL/SQL: program error
ERROR 5841 (HY000) : PL/SQL: Return types of Result Set variables or query do not match
ERROR 5842 (HY000) : PL/SQL: storage error
ERROR 5843 (HY000) : Subscript outside of limit
ERROR 5844 (HY000) : invalid cursor
ERROR 5845 (HY000) : invalid username/password; logon denied
ERROR 5846 (HY000) : not logged on
ERROR 5847 (HY000) : method dispatch on NULL SELF argument is disallowed
ERROR 5848 (HY000) : timeout occurred while waiting for a resource
ERROR 5849 (HY000) : column to be modified to NOT NULL is already NOT NULL
ERROR 5850 (HY000) : column to be modified to NULL cannot be modified to NULL
ERROR 5851 (HY000) : cannot enable (%.*s.%.*s) - null values found
ERROR 5852 (HY000) : Argument should be a constant
ERROR 5853 (HY000) : not a single-group group function
ERROR 5854 (HY000) : illegal zero-length identifier
ERROR 5855 (HY000) : parameter cannot be modified because specified value is invalid
ERROR 5856 (HY000) : DBMS_SQL access denied
ERROR 5857 (HY000) : not all variables bound
ERROR 5859 (HY000) : column is referenced in a multi-column constraint
ERROR 5860 (HY000) : cannot modify column datatype with current constraint(s)
ERROR 5861 (HY000) : The percentile value should be a number between 0 and 1
ERROR 5862 (HY000) : The argument should be of numeric or date/datetime type
ERROR 5863 (HY000) : ALTER TABLE|INDEX RENAME may not be combined with other operations
ERROR 5864 (HY000) : only simple column names allowed here
ERROR 5866 (HY000) : cannot specify <(sub)partition-description> clause in CREATE TABLE or CREATE INDEX)
ERROR 5867 (HY000) : Duplicate partition name %.*s
ERROR 5868 (HY000) : Incorrect usage of UPDATE and ORDER BY
ERROR 5869 (HY000) : Incorrect usage of UPDATE and LIMIT
ERROR 5870 (HY000) : rowid type mismatch, expect %.*s, got %.*s
ERROR 5871 (HY000) : rowid num mismatch, expect %ld, actual %ld
ERROR 5872 (HY000) : must name %.*s with a column alias
ERROR 5873 (HY000) : the numeric value does not match the length of the format item
ERROR 5874 (HY000) : invalid datatype
ERROR 5875 (HY000) : table is not partitioned by composite partition method
ERROR 5876 (HY000) : VALUES IN (<value list>) cannot be used for Range subpartitioned tables
ERROR 5877 (HY000) : VALUES IN (<value list>) clause expected
ERROR 5879 (HY000) : Expecting VALUES LESS THAN or AT clause
ERROR 5880 (HY000) : procedure, function, package, or package body does not exist
ERROR 5882 (HY000) : invalid time limit specified
ERROR 5883 (HY000) : ## ERROR(s) in array DML
ERROR 5884 (42000) : %s \'%.*s.%.*s\' compile error
ERROR 5887 (HY000) : missing or invalid password(s)
ERROR 5889 (HY000) : no matching unique or primary key for this column-list
ERROR 5890 (HY000) : duplicate referential constraint specifications
ERROR 5891 (HY000) : such a referential constraint already exists in the table
ERROR 5893 (HY000) : specified data type is not supported for a virtual column
ERROR 5894 (HY000) : referenced table does not have a primary key
ERROR 5895 (HY000) : data type or length of a table partitioning column may not be changed
ERROR 5896 (HY000) : data type or length of a table partitioning column may not be changed
ERROR 5897 (HY000) : cannot decrease column length because some value is too big
ERROR 5898 (HY000) : Datetime/Interval internal error
ERROR 5899 (HY000) : partition extended table name cannot refer to a remote object
ERROR 5901 (HY000) : a view is not appropriate here
ERROR 5902 (HY000) : cannot select ROWID from,or sample, a join view without a key-preserved table
ERROR 5903 (HY000) : cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc
ERROR 5904 (HY000) : table must have at least 1 column that is not virtual
ERROR 5905 (HY000) : only pure functions can be indexed
ERROR 5906 (HY000) : only pure functions can be specified in a virtual column expression
ERROR 5907 (HY000) : UPDATE operation disallowed on virtual columns
ERROR 5908 (HY000) : Invalid column expression was specified
ERROR 5909 (HY000) : table can have only one identity column
ERROR 5910 (HY000) : invalid NOT NULL constraint specified on an identity column
ERROR 5911 (HY000) : cannot modify NOT NULL constraint on an identity column
ERROR 5912 (HY000) : cannot drop NOT NULL constraint on an identity column
ERROR 5913 (HY000) : column to be modified is not an identity column
ERROR 5914 (HY000) : identity column cannot have a default value
ERROR 5915 (HY000) : identity column must be a numeric type
ERROR 5916 (HY000) : prebuilt table managed column cannot be an identity column
ERROR 5917 (HY000) : cannot alter a system-generated sequence
ERROR 5918 (HY000) : cannot drop a system-generated sequence
ERROR 5919 (HY000) : cannot insert into a generated always identity column
ERROR 5920 (HY000) : cannot update a generated always identity column
ERROR 5921 (HY000) : identity column sequence mismatch in ALTER TABLE EXCHANGE PARTITION
ERROR 5922 (HY000) : cannot rename a system-generated sequence
ERROR 5923 (HY000) : UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column
ERROR 5924 (HY000) : not executed, type body '%.*s' does not exist
ERROR 5925 (HY000) : The argument [%s] of WIDTH_BUCKET function is NULL or invalid
ERROR 5926 (HY000) : Not enough memory for CONNECT BY operation
ERROR 5927 (HY000) : illegal parameter in SYS_CONNECT_BY_PATH function
ERROR 5928 (HY000) : host %.*s unknown
ERROR 5929 (HY000) : Window name '%.*s' is not defined
ERROR 5930 (HY000) : maximum open %s exceeded
ERROR 5931 (HY000) : argument is null, invalid, or out of range
ERROR 5932 (HY000) : unexpected name string
ERROR 5933 (HY000) : PL/SQL: could not find program unit being called: '%.*s'
ERROR 5934 (HY000) : fetch out of sequence
ERROR 5959 (HY000) : invalid SIZE specified
ERROR 5975 (HY000) : \ndblink remote error code: %d,\nremote error msg: %.*s"
ERROR 5976 (HY000) : can not find the expected version of OCI LIB: %.*s

This range indicates SQL layer error codes. It includes SQL error codes, WITH clause error codes, and Factoring error codes.

ERROR 5002 (HY000) : Resolve error

  • OceanBase error code: 5002

  • Cause: Parsing error.

  • Solution: Contact technical support for assistance.

ERROR 5010 (21000) : Unknown operator

  • OceanBase error code: 5010

  • Cause: Internal defense check error code during parsing.

  • Solution: Contact technical support for assistance.

ERROR 5011 (42000) : Duplicated star

  • OceanBase error code: 5011

  • Cause: Incorrect usage of *. An SQL statement supports only one *.

  • Solution: Remove the extra * from the SQL statement.

ERROR 5012 (HY000) : Illegal ID

  • OceanBase error code: 5012

  • Cause: Internal parameter defense error.

  • Solution: Contact technical support for assistance.

ERROR 5014 (HY000) : Illegal value

  • OceanBase error code: 5014

  • Cause: Numeric type conversion error.

  • Solution: Check whether the CAST statements in the SQL statement are correct, such as whether implicit conversion exists.

ERROR 5016 (HY000) : Generate logical plan error

  • OceanBase error code: 5016

  • Cause: Error occurred while generating the plan.

  • Solution: Contact technical support for assistance.

ERROR 5017 (HY000) : Schema not set

  • OceanBase error code: 5017

  • Cause: Internal error code.

  • Solution: Contact technical support for assistance.

ERROR 5023 (S1004) : unsupport MySQL type (number). Maybe you should use java.sql.Timestamp instead of java.util.Date

  • OceanBase error code: 5023

  • Cause: Unsupported type.

  • Solution: Contact technical support for assistance.

ERROR 5031 (HY000) : Column not found

  • OceanBase error code: 5031

  • Cause: The column does not exist.

  • Solution: Check whether the column involved in the operation exists, or contact technical support for assistance.

ERROR 5034 (01007) : No user

  • OceanBase error code: 5034

  • Cause: The username is empty.

  • Solution: Provide a username.

ERROR 5050 (42710) : User exists

  • OceanBase error code: 5050

  • Cause: The user or role already exists.

  • Solution: Check whether the user or role involved in the operation already exists, or contact technical support for assistance.

ERROR 5053 (HY093) : Incorrect arguments number to EXECUTE, need %ld arguments but give %ld

  • OceanBase error code: 5053

  • Cause: The number of variables bound during EXECUTE does not match the number of parameters in the PREPARE statement.

  • Solution: Ensure that the number of variables bound during EXECUTE matches the number of parameters required by the PREPARE statement.

ERROR 5058 (42000) : Duplicated parameters

  • OceanBase error code: 5058

  • Cause: Duplicate parameter.

  • Solution: Contact technical support for assistance.

ERROR 5063 (42000) : Unknown hint

  • OceanBase error code: 5063

  • Cause: Parsing error.

  • Solution: Contact technical support for assistance.

ERROR 5066 (HY000) : Session interrupted

  • OceanBase error code: 5066

  • Cause: The session was terminated.

  • Solution: Contact the system administrator or database administrator.

ERROR 5071 (42000) : Cannot alter index column

  • OceanBase error code: 5071

  • Cause: Deleted an index reference column.

  • Solution: Deleting an index reference column is not allowed.

ERROR 5074 (23000) : NOP cannot be used here

  • OceanBase error code: 5074

  • Cause: Kernel bug.

  • Solution: Contact technical support for assistance.

ERROR 5081 (25000) : The server is read only now

  • OceanBase error code: 5081

  • Cause: The data being operated on is read-only.

  • Solution: Check whether the data being operated on is read-only, or contact technical support for assistance.

ERROR 5083 (22000) : invalid obj type for type promotion: left_type=%s right_type=%s

  • OceanBase error code: 5083

  • Cause: Type conversion error.

  • Solution: Contact technical support for assistance.

ERROR 5084 (22000) : Can not cast varchar value to bool type

  • OceanBase error code: 5084

  • Cause: Type conversion error.

  • Solution: Contact technical support for assistance.

ERROR 5085 (22000) : Not a number Can not cast varchar value to number type

  • OceanBase error code: 5085

  • Cause: Type conversion error.

  • Solution: Contact technical support for assistance.

ERROR 5086 (22000) : Not timestamp Can not cast varchar value to timestamp type

  • OceanBase error code: 5086

  • Cause: Type conversion error.

  • Solution: Contact technical support for assistance.

ERROR 5087 (22000) : Result value was out of range when cast to number

  • OceanBase error code: 5087

  • Cause: Value out of range.

  • Solution: Contact technical support for assistance.

ERROR 5090 (22000) : Precision was out of range

  • OceanBase error code: 5090

  • Cause: Precision out of range.

  • Solution: Contact technical support for assistance.

ERROR 5091 (22000) : Scale value was out of range

  • OceanBase error code: 5091

  • Cause: Precision out of range.

  • Solution: Contact technical support for assistance.

ERROR 5092 (42000) : Unknown index

  • OceanBase error code: 5092

  • Cause: The index is unknown.

  • Solution: Check whether the index is used incorrectly in the API.

ERROR 5098 (22001) : Data too long(%d>%ld) for column '%s'

  • OceanBase error code: 5098

  • Cause: The numeric input exceeds the limit.

  • Solution: Reduce the length of the number.

ERROR 5099 (42000) : System config unknown

  • OceanBase error code: 5099

  • Cause: The parameter is invalid.

  • Solution: Check whether the parameter name is correct.

ERROR 5106 (42000) : EXTRACT() expected timestamp or a string as date argument

  • OceanBase error code: 5106

  • Cause: The data type is incorrect.

  • Solution: Contact technical support for assistance.

ERROR 5107 (42000) : Invalid operand type for IS operator, lval=%s

  • OceanBase error code: 5107

  • Cause: The parameter of the IS expression is incorrect.

  • Solution: Contact technical support for assistance.

ERROR 5108 (42000) : function LENGTH() expected a varchar argument

  • OceanBase error code: 5108

  • Cause: The parameter of the LENGTH expression is incorrect.

  • Solution: Contact technical support for assistance.

ERROR 5110 (42000) : TIME_TO_USEC() expected timestamp or a string as date argument

  • OceanBase error code: 5110

  • Cause: The parameter of the TIME_TO_USEC function can only be of the VARCHAR, TIME, DATATIME, or TIMESTAMP type.

  • Solution: Modify the parameter type.

ERROR 5111 (42000) : USEC_TO_TIME expected a interger number as usec argument

  • OceanBase error code: 5111

  • Cause: The parameter of the USEC_TO_TIME function can only be of the TINYINT, MEDIUMINT, INT, or BIGINT type.

  • Solution: Modify the parameter type.

ERROR 5112 (42P01) : Variable %.*s does not exists

  • OceanBase error code: 5112

  • Cause: The variable does not exist.

  • Solution: Check if the variable spelling is incorrect.

ERROR 5114 (42000) : Invalid numeric char '%c'

  • OceanBase error code: 5114

  • Cause: Invalid digit.

  • Solution: Contact technical support for assistance.

ERROR 5116 (HY000) : Logical operator child index overflow

  • OceanBase error code: 5116

  • Cause: Kernel error.

  • Solution: Contact technical support for assistance.

ERROR 5117 (HY000) : fail to explain plan

  • OceanBase error code: 5117

  • Cause: Error occurred during plan generation.

  • Solution: Contact technical support for assistance.

ERROR 5118 (HY000) : fail to copy logical operator

  • OceanBase error code: 5118

  • Cause: An error occurred while generating the execution plan.

  • Solution: Contact technical support for assistance.

ERROR 5119 (HY000) : fail to generate plan

  • OceanBase error code: 5119

  • Cause: An error occurred while generating the execution plan.

  • Solution: Contact technical support for assistance.

ERROR 5120 (HY000) : fail to create raw expr

  • OceanBase error code: 5120

  • Cause: An error occurred during plan generation.

  • Solution: Contact technical support for assistance.

ERROR 5121 (HY000) : fail to generate join order

  • OceanBase error code: 5121

  • Cause: An error occurred during plan generation.

  • Solution: Contact technical support for assistance.

ERROR 5122 (HY000) : optimizer general error

  • OceanBase error code: 5122

  • Cause: An error occurred during plan generation.

  • Solution: Contact technical support for assistance.

ERROR 5130 (HY000) : sql resolver no memory

  • OceanBase error code: 5130

  • Cause: Insufficient memory.

  • Solution: Increase the SQL memory or contact technical support for assistance.

ERROR 5131 (HY000) : plan cache support dml only

  • OceanBase error code: 5131

  • Cause: OUTLINE binding was performed on a non-DML statement.

  • Solution: Do not perform OUTLINE binding on non-DML statements.

ERROR 5133 (42000) : No such grant defined

  • OceanBase error code: 5133

  • Cause: The specified privilege was not granted when revoking it.

ERROR 5136 (HY000) : plan exists in plan cache already

  • OceanBase error code: 5136

  • Cause: The execution plan already exists in the plan cache when it was added.

  • Solution: This is an internal error code. Please contact technical support for assistance.

ERROR 5137 (HY000) : plan is expired

  • OceanBase error code: 5137

  • Cause: The plan has expired.

  • Solution: This is an internal error code. Please contact technical support for assistance.

ERROR 5138 (HY000) : no plan exist

  • OceanBase error code: 5138

  • Cause: The plan does not exist when getting the plan.

  • Solution: This is an internal error code. Please contact technical support for assistance.

ERROR 5144 (HY000) : COLLATION '%.*s' is notvalid for CHARACTER SET '%.*s'

  • OceanBase error code: 5144

  • Cause: One of the following situations may have occurred:

    • The string operands of operators or built-in functions (except for nlsparams parameters) use different character sets.

    • The nlsparams operand is not in the database character set.

    • The string data passed to a built-in function uses a character set other than the database character set, but the built-in function does not accept that character set.

    • The second parameter of CHR() or CSCONVERT() is not CHAR_CS or NCHAR_CS.

    • The character set of a string expression in the VALUES clause of an INSERT statement or in the SET clause of an UPDATE statement is inconsistent with the character set used by the column to be inserted.

    • The character set of the value provided in the DEFAULT clause when creating a table is inconsistent with the character set declared for the column.

    • The parameter of a PL/SQL function does not meet the character set requirements of the corresponding parameter.

ERROR 5150 (HY000) : Tenant not in this server

  • OceanBase error code: 5150

  • Cause: The server does not have resources for the corresponding tenant.

  • Solution: Retry. If this issue persists, please contact technical support for assistance.

ERROR 5151 (42P01) : tablegroup not exist

  • OceanBase error code: 5151

  • Cause: The table group does not exist. An invalid table group name was specified.

  • Solution: Check whether the table group name is correct.

ERROR 5156 (HY000) : tenant \'%s\' already exist

  • OceanBase error code: 5156

  • Cause: The created tenant has a duplicate name or an internal error occurred.

  • Solution: If the tenant name is duplicated, modify the tenant name and create it again. For other scenarios, contact technical support for assistance.

ERROR 5157 (HY000) : Unknown tenant '%.*s'

  • OceanBase error code: 5157

  • Cause: Schema refresh is lagging, or the tenant has been deleted.

  • Solution: Retry. If this issue persists, contact technical support for assistance.

ERROR 5159 (HY000) : tablegroup already exist

  • OceanBase error code: 5159

  • Cause: The table group already exists.

  • Solution: Check whether the table group name is correct.

ERROR 5160 (HY000) : invalid tenant name specified in connection string

  • OceanBase error code: 5160

  • Cause: The specified tenant name does not exist.

  • Solution: Confirm whether the specified tenant exists. If it exists, contact technical support for assistance.

ERROR 5212 (42000) : auto-increment column '%.*s' should not be part of partition key

  • OceanBase error code: 5212

  • Cause: An auto-increment column cannot be part of the partitioning key.

  • Solution: Remove the auto-increment column from the partitioning key.

ERROR 5223 (42000) : wrong ident name

  • OceanBase error code: 5223

  • Cause: The variable name is incorrect.

  • Solution: Use a valid variable name.

ERROR 5226 (42000) : plan cache memory used reach the high water mark

  • OceanBase error code: 5226

  • Cause: The memory used by the plan cache has reached its upper limit, and eviction is automatically triggered.

  • Solution: Increase the upper limit for plan cache memory.

ERROR 5234 (HY000) : The database \'%.*s\' is read only so it cannot execute this statement

  • OceanBase error code: 5234

  • Cause: An operation was performed on a read-only database.

  • Solution: Do not operate on a read-only database.

ERROR 5235 (HY000) : The table \'%.*s.%.*s\' is read only so it cannot execute this statement

  • OceanBase error code: 5235

  • Cause: An operation was performed on a read-only table.

  • Solution: Do not operate on a read-only table.

ERROR 5243 (HY000) : system variables' version maybe different

  • OceanBase error code: 5243

  • Cause: Internal error code.

  • Solution: Contact technical support for assistance.

ERROR 5245 (HY000) : some tasks are skipped, skipped server addr is '%s', the orginal error code is %d

  • OceanBase error code: 5245

  • Cause: Internal error code.

  • Solution: Contact technical support for assistance.

ERROR 5248 (HY000) : Alter table add auto_increment column is dangerous, table_name=\'%.*s\', column_name=\'%s\'

  • OceanBase error code: 5248

  • Cause: Adding an auto-increment column while modifying a table is not recommended.

  • Solution: We recommend that you perform this operation only when the table contains no data.

ERROR 5252 (HY000) : Column \'%.*s\' definition is ambiguous. Column has both NULL and NOT NULL attributes

  • OceanBase error code: 5252

  • Cause: A column is defined as both NULL and NOT NULL.

  • Solution: Specify only one attribute.

ERROR 5258 (HY000) : Invalid block size, block size should between 1024 and 1048576

  • OceanBase error code: 5258

  • Cause: The specified block size is invalid.

  • Solution: Modify the block size.

ERROR 5260 (HY000) : Tenant \'%.*s\' is locked

  • OceanBase error code: 5260

  • Cause: The tenant is locked.

  • Solution: Unlock the tenant.

ERROR 5264 (HY000) : Outline '%.*s' already exists

  • OceanBase error code: 5264

  • Cause: The OUTLINE already exists.

  • Solution: Check whether it is bound to the same OUTLINE by other SQL statements.

ERROR 5265 (HY000) : Outline \'%.*s.%.*s\' doesn\'t exist

  • OceanBase error code: 5265

  • Cause: The specified OUTLINE does not exist.

  • Solution: Check whether the corresponding OUTLINE has been created.

ERROR 5267 (HY000) : invalid outline ,error info:%s

  • OceanBase error code: 5267

  • Cause: The specified OUTLINE is invalid.

  • Solution: Contact technical support for assistance.

ERROR 5268 (HY000) : SQL reach max concurrent num %ld

  • OceanBase error code: 5268

  • Cause: The SQL throttling upper limit is reached.

  • Solution: Reduce the concurrency.

ERROR 5269 (HY000) : can not perform DDL/DML over objects in Recycle Bin

  • OceanBase error code: 5269

  • Cause: You cannot operate on objects in the recycle bin.

  • Solution: Restore the object from the recycle bin and then perform the operation.

ERROR 5270 (HY000) : object not in RECYCLE BIN

  • OceanBase error code: 5270

  • Cause: The object is not in the recycle bin.

  • Solution: Contact technical support for assistance.

ERROR 5272 (HY000) : Outline content '%.*s' of outline '%.*s' already exists when added

  • OceanBase error code: 5272

  • Cause: The OUTLINE has already been created.

  • Solution: Check whether the previously created OUTLINE meets your expectations. If it does, you do not need to create another OUTLINE. If it does not, you can execute DROP OUTLINE and then recreate it.

ERROR 5273 (HY000) : Max concurrent in outline '%.*s' already exists when added

  • OceanBase error code: 5273

  • Cause: The throttling rule to be created already exists.

  • Solution: Check whether the throttling statement contains an existing throttling rule.

ERROR 5278 (HY000) : This partition value with incorrect charset type

  • OceanBase error code: 5278

  • Cause: The meta information of the partition value is inconsistent.

  • Solution: Modify the partition value to make its meta information consistent.

ERROR 5291 (HY000) : The CTXCAT column must be contiguous in the index column list

  • OceanBase error code: 5291

  • Cause: The CTXCAT fields must be contiguous.

  • Solution: Adjust the CTXCAT fields or contact technical support for assistance.

ERROR 5296 (42000) : there has no readable replica

  • OceanBase error code: 5296

  • Cause: No available replica was selected during plan generation.

  • Solution: Contact technical support for troubleshooting.

ERROR 5297 (HY000) : unexpected time zone info transition

  • OceanBase error code: 5297

  • Cause: Gap or overlap time is used.

  • Solution: Use non-gap time or set the error_on_overlap_time variable to false.

ERROR 5298 (HY000) : synonym '%.*s' already exists

  • OceanBase error code: 5298

  • Cause: The synonym already exists.

  • Solution: Check for conflicting synonym names and create a synonym with a different name.

ERROR 5299 (HY000) : synonym \'%.*s.%.*s\' doesn\'t exist

  • OceanBase error code: 5299

  • Cause: The synonym does not exist.

  • Solution: Check whether an non-existent synonym is used.

ERROR 5300 (HY000) : missing ORDER BY expression in the window specification

  • OceanBase error code: 5300

  • Cause: The ORDER BY expression is missing in the window function.

  • Solution: Add the relevant ORDER BY expression to the window function.

ERROR 5301 (HY000) : The argument of the window function should be a constant for a partition

  • OceanBase error code: 5301

  • Cause: The parameter in the window function must be a constant.

  • Solution: Modify the relevant parameter in the window function to a constant value.

ERROR 5307 (HY000) : Not enough thread resource to execute the query. Require setting parallel_servers_target to a value no less than %ld for this query

  • OceanBase error code: 5307

  • Cause: Insufficient execution threads.

  • Solution: Increase the value of the parallel_servers_target system variable.

ERROR 5309 (HY000) : Ignore sql in restore process

  • OceanBase error code: 5309

  • Cause: Specific SQL statements need to be skipped during logical restore.

  • Solution: No action required.

ERROR 5311 (HY000) : Invalid column id for %.*s

  • OceanBase error code: 5311

  • Cause: Invalid column ID.

  • Solution: Contact technical support for assistance.

ERROR 5312 (HY000) : Duplicated ddl id '%.*s'

  • OceanBase error code: 5312

  • Cause: Duplicate DDL ID.

  • Solution: Contact technical support for assistance.

ERROR 5319 (HY000) : Child column \'%.*s\' data length cannot be less than parent column \'%.*s\' data length

  • OceanBase error code: 5319

  • Cause: The length of a foreign key field cannot be less than the length of the referenced field.

  • Solution: Adjust the lengths of the related fields.

ERROR 5320 (HY000) : \'%.*s\': used in a foreign key constraint

  • OceanBase error code: 5320

  • Cause: The field is used in a foreign key constraint.

  • Solution: The field cannot be operated on.

ERROR 5325 (HY000) : ORDER SIBLINGS BY clause not allowed here

  • OceanBase error code: 5325

  • Cause: The ORDER SIBLINGS BY clause is used in an incorrect location.

  • Solution: The ORDER SIBLINGS BY clause can only be used in hierarchical query statements.

ERROR 5326 (HY000) : when using SYS_CONNECT_BY_PATH function, cannot have separator as part of column value

  • OceanBase error code: 5326

  • Cause: The column value contains a string that the SYS_CONNECT_BY_PATH function uses to separate the values.

  • Solution: Specify another separator for the SYS_CONNECT_BY_PATH function. Ensure this separator is not contained in any column value, and then try the operation again.

ERROR 5327 (HY000) : Database can not be specified in public synonym

  • OceanBase error code: 5327

  • Cause: A database was specified when using the public synonym.

  • Solution: For the use of public synonyms, there is no need to execute DATABASE.

ERROR 5328 (HY000) : Looping chain of synonyms

  • OceanBase error code: 5328

  • Cause: A circularly dependent synonym was created.

  • Solution: Check for circularly dependent synonyms and create synonyms with different names to break the cycle.

ERROR 5329 (HY000) : Cannot create a synonym with same name as object

  • OceanBase error code: 5329

  • Cause: The synonym name is the same as the object name.

  • Solution: Create a synonym with a name different from the object name.

ERROR 5330 (HY000) : Synonym %s translation is no longer valid

  • OceanBase error code: 5330

  • Cause: The object corresponding to the synonym does not exist.

  • Solution: Create the object that the synonym depends on.

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

  • OceanBase error code: 5331

  • Cause: The object already exists.

  • Solution: The object involved in PL already exists and cannot be created repeatedly.

ERROR 5337 (HY000) : rowid is wrong

  • OceanBase error code: 5337

  • Cause: The content parsed from ROWID does not meet expectations.

  • Solution: Pass a valid ROWID.

ERROR 5338 (HY000) : Window Function not allowed here

  • OceanBase error code: 5338

  • Cause: A window function appears in an expression within the SQL statement.

  • Solution: Remove the window function from the corresponding expression in the SQL statement.

ERROR 5339 (HY000) : Fail to parse list partition

  • OceanBase error code: 5339

  • Cause: The number of partitions defined does not match the partition specification clause in the LIST partition definition.

  • Solution: Modify the partition count definition.

ERROR 5341 (HY000) : timezone region ID is invalid

  • OceanBase error code: 5341

  • Cause: The Region ID recorded in the TIMESTAMP data cannot be parsed.

  • Solution: Contact technical support for assistance.

ERROR 5342 (HY000) : invalid hex number

  • OceanBase error code: 5342

  • Cause: Invalid hexadecimal.

  • Solution: Contact technical support for assistance.

ERROR 5343 (42000) : wrong number or types of arguments in call to '%.*s'

  • OceanBase error code: 5343

  • Cause: Incorrect parameter list.

  • Solution: Check the parameter list.

ERROR 5345 (HY000) : insufficient parallel query worker available

  • OceanBase error code: 5345

  • Cause: Insufficient PX threads.

  • Solution: Increase the number of PX threads.

ERROR 5346 (HY000) : FOR UPDATE of this query expression is not allowed

  • OceanBase error code: 5346

  • Cause: An invalid expression is specified in the FOR UPDATE clause.

  • Solution: Modify the FOR UPDATE syntax.

ERROR 5347 (HY000) : argument should be a function of expressions in PARTITION BY

  • OceanBase error code: 5347

  • Cause: Parsing error.

  • Solution: Modify the SQL statement.

ERROR 5348 (HY000) : result of string concatenation is too long

  • OceanBase error code: 5348

  • Cause: The concatenated characters by using the WM_CONCAT function are too long.

  • Solution: Check whether the length after concatenation exceeds the value of group_concat_max_len. If so, increase the value of group_concat_max_len.

ERROR 5350 (HY000) : updating partition key column would cause a partition change

  • OceanBase error code: 5350

  • Cause: An UPDATE operation causes the partition of the row to change.

  • Solution: Use the ALTER TABLE statement to enable the ENABLE ROW MOVEMENT clause for the table.

ERROR 5351 (HY000) : invalid type given for an argument

  • OceanBase error code: 5351

  • Cause: The parameter type is incorrect.

  • Solution: Check the parameter type.

ERROR 5352 (HY000) : specified field not found in datetime or interval

  • OceanBase error code: 5352

  • Cause: Invalid data is detected during time zone conversion.

  • Solution: Contact technical support for assistance.

ERROR 5360 (HY000) : insufficient privileges

  • OceanBase error code: 5360

  • Cause: Insufficient privileges.

  • Solution: Grant the corresponding privileges.

ERROR 5361 (HY000) : user %.*s lacks CREATE SESSION privilege; logon denied

  • OceanBase error code: 5361

  • Cause: The user does not have the login privilege.

  • Solution: Grant the user the login privilege.

ERROR 5363 (HY000) : system privileges not granted to '%.*s'

  • OceanBase error code: 5363

  • Cause: The user has not been granted system privileges.

  • Solution: Grant the user the corresponding system privileges.

ERROR 5364 (HY000) : only SELECT and ALTER privileges are valid for sequences

  • OceanBase error code: 5364

  • Cause: Privileges other than SELECT and ALTER have been granted to the SEQUENCE object.

  • Solution: Do not grant privileges other than SELECT and ALTER to a SEQUENCE object.

ERROR 5365 (HY000) : EXECUTE privilege not allowed for tables

  • OceanBase error code: 5365

  • Cause: The EXECUTE privilege has been granted to a table.

  • Solution: Do not grant the EXECUTE privilege to a table.

ERROR 5366 (HY000) : only EXECUTE and DEBUG privileges are valid for procedures

  • OceanBase error code: 5366

  • Cause: Privileges other than EXECUTE and DEBUG have been granted to the PROCEDURE object.

  • Solution: Do not grant privileges other than EXECUTE and DEBUG to a PROCEDURE object.

ERROR 5367 (HY000) : only EXECUTE, DEBUG, and UNDER privileges are valid for types

  • OceanBase error code: 5367

  • Cause: Privileges other than EXECUTE, DEBUG, and UNDER have been granted to a TYPE object.

  • Solution: Do not grant privileges other than EXECUTE, DEBUG, and UNDER to a TYPE object.

ERROR 5368 (HY000) : ADMIN option not granted for role '%.*s'

  • OceanBase error code: 5368

  • Cause: The role does not have the corresponding ADMIN option.

  • Solution: Grant the ADMIN option to the user's role.

ERROR 5369 (HY000) : user or role '%.*s' does not exist

  • OceanBase error code: 5369

  • Cause: The user does not exist.

  • Solution: Check whether the username is misspelled. If so, correct it to the correct one. If not, create the required username.

ERROR 5370 (HY000) : missing ON keyword

  • OceanBase error code: 5370

  • Cause: The ON keyword is missing.

  • Solution: Add the ON keyword.

ERROR 5371 (HY000) : grant option does not exist for '%.*s.%.*s'

  • OceanBase error code: 5371

  • Cause: The user does not have the corresponding sub-authorization permission.

  • Solution: Add the corresponding sub-authorization permission.

ERROR 5372 (HY000) : ALTER, INDEX and EXECUTE not allowed for views

  • OceanBase error code: 5372

  • Cause: Granting the ALTER, INDEX, or EXECUTE privilege to a VIEW object.

  • Solution: Do not grant the ALTER, INDEX, or EXECUTE privilege to a VIEW object.

ERROR 5373 (HY000) : circular role grant detected

  • OceanBase error code: 5373

  • Cause: Circular authorization has occurred for roles.

  • Solution: Avoid circular authorization for roles.

ERROR 5374 (HY000) : invalid privilege on directories

  • OceanBase error code: 5374

  • Cause: An invalid privilege was granted on a directory object.

  • Solution: Grant the correct privilege for operating on the directory object.

ERROR 5375 (HY000) : directory access denied

  • OceanBase error code: 5375

  • Cause: The user does not have the permission to operate on this directory.

  • Solution: If you need access to this directory, contact the system administrator to grant the user permission to operate on this directory.

ERROR 5376 (HY000) : missing or invalid role name

  • OceanBase error code: 5376

  • Cause: The role name is incorrect.

  • Solution: Correct the role name.

ERROR 5377 (HY000) : role '%.*s' not granted or does not exist

  • OceanBase error code: 5377

  • Cause: The role has not been granted, or it does not exist.

ERROR 5378 (HY000) : DEFAULT ROLE '%.*s' not granted to user

  • OceanBase error code: 5378

  • Cause: The default role has not been granted to the user.

  • Solution: Grant the default role to the user.

ERROR 5379 (HY000) : ROLE '%.*s' not granted to '%.*s'

  • OceanBase error code: 5379

  • Cause: When revoking a role from a user, it was found that the role had not been granted to the user.

ERROR 5380 (HY000) : cannot GRANT to a role WITH GRANT OPTION

  • OceanBase error code: 5380

  • Cause: When a user tries to grant a role with the WITH GRANT OPTION clause, it is found that they do not have the required grant option.

  • Solution: Add the grant option to the user's privileges.

ERROR 5381 (HY000) : duplicate username in list

  • OceanBase error code: 5381

  • Cause: The GRANT statement contains duplicate users.

  • Solution: Remove the duplicate users.

ERROR 5382 (HY000) : cannot grant %.*s to a role

  • OceanBase error code: 5382

  • Cause: You cannot grant the REFERENCE or INDEX privilege to a role.

  • Solution: Remove the REFERENCE or INDEX privilege granted to the role.

ERROR 5383 (HY000) : CASCADE CONSTRAINTS must be specified to perform this revoke

  • OceanBase error code: 5383

  • Cause: The CASCADE CONSTRAINTS clause must be specified in the REVOKE statement.

  • Solution: Specify CASCADE CONSTRAINTS.

ERROR 5384 (HY000) : you may not GRANT/REVOKE privileges to/from yourself

  • OceanBase error code: 5384

  • Cause: Granting or revoking privileges on oneself.

  • Solution: OceanBase AI Database does not support users granting or revoking their own privileges. If you need to modify your own privileges, contact the system administrator to perform the relevant operations.

ERROR 5386 (HY000) : Unable to read data -* Table definition has changed

  • OceanBase error code: 5386
  • Compatible MySQL error code: 1412
  • Cause: The table definition has changed, and the snapshot point read is too old, making it impossible to read or parse correctly.
  • Solution: Check if the table definition has changed, confirming whether there have been additions or deletions of columns, modifications to data types or lengths, etc.

ERROR 5401 (HY000) : resultant data type of virtual column is not supported

  • OceanBase error code: 5401

  • Cause: A generated column cannot reference a large object type.

  • Solution: Remove the large object type.

ERROR 5403 (HY000) : ddl schema version not match

  • OceanBase error code: 5403

  • Cause: Concurrent DDL conflict.

  • Solution: Rerun the DDL.

ERROR 5409 (HY000) : Duplicate object name exists, schema refreshing may be hung

  • OceanBase error code: 5409

  • Cause: A duplicate object name was encountered during DDL thread execution.

  • Solution: Contact technical support for assistance.

ERROR 5410 (HY000) : Refresh schema failed continuously, ddl may be hung

  • OceanBase error code: 5410
  • Cause: The DDL thread is hung and cannot receive new DDL requests.
  • Solution: Contact technical support for assistance.

ERROR 5434 (HY000) : retry sql due to spm

  • OceanBase error code: 5434

  • Cause: The SQL statement needs to be automatically retried because of the SPM feature.

  • Solution: Contact technical support for assistance.

ERROR 5435 (HY000) : outline not reproducible

  • OceanBase error code: 5435

  • Cause: The plan specified by the outline cannot be reproduced.

  • Solution: Contact technical support for assistance.

ERROR 5436 (42000) : TIMESTAMP_TO_SCN expected timestamp argument

  • OceanBase error code: 5436

  • Cause: The parameter type does not meet expectations. The TIMESTAMP_TO_SCN function expects a TIMESTAMP type parameter.

  • Solution: Modify the function's parameters.

ERROR 5437 (42000) : SCN_TO_TIMESTAMP expected a integer number as nsec argument

  • OceanBase error code: 5437

  • Cause: The parameter type does not meet expectations. The SCN_TO_TIMESTAMP function expects an integer type parameter.

  • Solution: Modify the function's parameters.

ERROR 5500 (HY000) : Legitimacy check failed for generated columns

  • OceanBase error code: 5500
  • Cause: During the legitimacy check for the values in generated columns or functional indexes, it was found that the stored values differ from the recalculated values based on the column/index definitions in the current environment. This may be due to using built-in functions whose computation results are affected by system variables or whose behavior is inherently uncertain to define the generated columns/indexes. If the _enable_defensive_check parameter is enabled, a defensive error is reported.
  • Solution: Check the definitions of the generated columns and functional indexes. If it is confirmed that the change in computation result is caused by a change in system variables, drop the generated column/index and recreate it. For other situations or if the issue persists, contact technical support for assistance.

ERROR 5540 (HY000) : System variable '%.*s' is different from the old value solidified for '%.*s'(old value:%.*s)

  • OceanBase error code: 5540

  • Cause: The system variable value set in the current session differs from the value that was solidified when creating the functional index or generated column. During calculations, the functional index or generated column uses the value that was solidified when they were created, not the current variable value in the session.

  • Solution: If you need to calculate based on the current session's system variable values, drop and recreate the generated column or functional index.

ERROR 5558 (42000) : %s \'%.*s.%.*s\' already exists

  • OceanBase error code: 5558

  • Cause: The package to be created already exists.

  • Solution: You can use the CREATE [OR REPLACE] statement to create it. After creation, any previously existing package with the same name will be overwritten.

ERROR 5559 (42000) : %s \'%.*s.%.*s\' does not exist

  • OceanBase error code: 5559

  • Cause: The accessed package does not exist.

  • Solution: Check whether the logic is correct.

ERROR 5561 (HY000) : Invalid use of window function

  • OceanBase error code: 5561

  • Cause: An invalid window function is used, such as unreasonable parameter settings.

  • Solution: Modify the window to use a valid window function.

ERROR 5562 (HY000) : Duplicate constraint name '%.*s'

  • OceanBase error code: 5562

  • Cause: The constraint name already exists.

  • Solution: Change the constraint name.

ERROR 5563 (HY000) : Constraint not found

  • OceanBase error code: 5563

  • Cause: The constraint to be operated on does not exist.

  • Solution: Check whether the constraint name is correct.

ERROR 5564 (HY000) : Duplicate alter index operations on column \'%.*s\'

  • OceanBase error code: 5564

  • Cause: In the same SQL statement, the ALTER INDEX operation is repeatedly performed on the same column.

  • Solution: Modify the SQL statement.

ERROR 5572 (HY000) : a partition may be split into exactly two new partitions

  • OceanBase error code: 5572

  • Cause: The number of partitions specified for the SPLIT operation is not 2.

  • Solution: Specify to split the partition into two.

ERROR 5573 (HY000) : this physical attribute may not be specified for a table partition

  • OceanBase error code: 5573

  • Cause: The maximum value is not supported at the split point during partition splitting.

  • Solution: Fix the split point.

ERROR 5574 (HY000) : missing VALUES keyword

  • OceanBase error code: 5574

  • Cause: Syntax error.

  • Solution: Add the VALUES keyword.

ERROR 5575 (HY000) : missing AT or VALUES keyword

  • OceanBase error code: 5575

  • Cause: Syntax error.

  • Solution: Add the AT or VALUES keyword.

ERROR 5578 (HY000) : Plan cache lock conflict

  • OceanBase error code: 5578

  • Cause: Locking failed in the plan cache.

  • Solution: Please try again.

ERROR 5597 (HY000) : last resulting partition cannot contain bounds

  • OceanBase error code: 5597

  • Cause: The partition range is inconsistent before and after splitting.

  • Solution: Modify the SQL statement.

ERROR 5598 (HY000) : cannot add partition when DEFAULT partition exists

  • OceanBase error code: 5598

  • Cause: A default partition already exists in the LIST partition, so no new partition can be added.

  • Solution: Do not add a new partition. Instead, use the method of splitting a partition to add a new one.

ERROR 5599 (HY000) : cannot split partition into one partition, use rename instead

  • OceanBase error code: 5599

  • Cause: Partition splitting is not allowed when the destination has only one partition.

ERROR 5600 (HY000) : can not create user %s in sys tenant, name %.*s

  • OceanBase error code: 5600

  • Cause: Users cannot be created in the sys tenant.

ERROR 5601 (HY000) : Percentage should between 1 and 99

  • OceanBase error code: 5601

  • Cause: Parsing error.

  • Solution: Modify the SQL statement.

ERROR 5603 (0A000) : Attempt to create, alter or drop an index on temporary table already in use

  • OceanBase error code: 5603

  • Cause: An attempt was made to create, alter, or drop an index on a temporary table that is already in use.

  • Solution: Disconnect all sessions that are using the temporary table, then perform the operation.

ERROR 5604 (HY000) : invalid NLS parameter string used in SQL function

  • OceanBase error code: 5604

  • Cause: An invalid time type parameter was used.

  • Solution: Contact technical support for assistance.

ERROR 5605 (HY000) : datetime/interval precision is out of range

  • OceanBase error code: 5605

  • Cause: The precision of a time type exceeds the limit.

  • Solution: Contact technical support for assistance.

ERROR 5606 (42000) : Invalid number format model

  • OceanBase error code: 5606

  • Cause: An invalid number format.

  • Solution: Contact technical support for assistance.

ERROR 5607 (HY000) : SQL command not properly ended

  • OceanBase error code: 5607

  • Cause: The command was not terminated correctly.

  • Solution: Check the command syntax.

ERROR 5608 (42000) : invalid number format model

  • OceanBase error code: 5608

  • Cause: The number format is invalid.

  • Solution: Contact technical support for assistance.

ERROR 5613 (HY000) : too many values

  • OceanBase error code: 5613

  • Cause: Too many values were specified in the statement, commonly seen in INSERT statements.

  • Solution: Adjust the number of values or contact technical support for assistance.

ERROR 5614 (HY000) : not enough values

  • OceanBase error code: 5614

  • Cause: Insufficient values were specified in the statement, commonly seen in INSERT statements.

  • Solution: Adjust the number of values or contact technical support for assistance.

ERROR 5615 (HY000) : single-row subquery returns more than one row

  • OceanBase error code: 5615

  • Cause: The scalar subquery expression is incorrect. It is expected to return one row but actually returns multiple rows.

  • Solution: Check the scalar subquery expression to ensure it returns only one row of results each time.

ERROR 5616 (HY000) : UPDATE ... SET expression must be a subquery

  • OceanBase error code: 5616

  • Cause: In a rowset assignment scenario, the SET clause of an UPDATE statement must be a subquery.

  • Solution: Adjust the syntax of the UPDATE SET clause or contact technical support for assistance.

ERROR 5617 (HY000) : inappropriate INTO

  • OceanBase error code: 5617

  • Cause: The INTO clause is used incorrectly.

  • Solution: Contact technical support for assistance.

ERROR 5619 (HY000) : Column part of using clause can not have qualifier

  • OceanBase error code: 5619

  • Cause: Column names in the USING clause cannot contain database name or table name.

  • Solution: Remove database name or table name from the column names in the USING clause.

ERROR 5623 (HY000) : outer join operator (+) not allowed in operand of OR or IN

  • OceanBase error code: 5623

  • Cause: An outer join appears in an OR clause.

  • Solution: Modify the SQL statement.

ERROR 5624 (HY000) : a column may not be outer-joined to a subquery

  • OceanBase error code: 5624

  • Cause: A column in an + outer join cannot be externally joined to a subquery.

  • Solution: Modify the SQL statement.

ERROR 5625 (HY000) : old style outer join (+) cannot be used with ANSI joins

  • OceanBase error code: 5625

  • Cause: When a query block uses ANSI-style joins, the old notation for specifying outer joins (+) cannot be used.

  • Solution: Modify the SQL statement.

ERROR 5626 (HY000) : outer join operator (+) is not allowed here

  • OceanBase error code: 5626

  • Cause: You tried to reference the (+) operator in the SELECT list, CONNECT BY clause, START WITH clause, or ORDER BY clause.

  • Solution: Modify the SQL statement.

ERROR 5627 (HY000) : Schema try again

  • OceanBase error code: 5627

  • Cause: The local schema version is outdated.

  • Solution: Retry or contact support personnel for assistance.

ERROR 5628 (HY000) : zero-length columns are not allowed

  • OceanBase error code: 5628

  • Cause: The column data length is 0.

  • Solution: Contact technical support for assistance.

ERROR 5629 (HY000) : year conflicts with Julian date

  • OceanBase error code: 5629

  • Cause: The year conflicts with the Julian date. For example, SELECT TO_DATE('2021-03-23 2459063', 'YYYY MM DD J') FROM DUAL;.

ERROR 5630 (HY000) : day of year conflicts with Julian date

  • OceanBase error code: 5630

  • Cause: The day of the year (1 - 366) conflicts with the Julian date.

ERROR 5631 (HY000) : month conflicts with Julian date

  • OceanBase error code: 5631

  • Cause: The month conflicts with the Julian date. For example, SELECT TO_DATE('11 2459063','MM J') FROM DUAL;.

ERROR 5632 (HY000) : day of month conflicts with Julian date

  • OceanBase error code: 5632

  • Cause: The day of the month (1 - 31) conflicts with the Julian date. For example, SELECT TO_DATE('11 2459063','DD J') FROM DUAL;.

ERROR 5633 (HY000) : day of week conflicts with Julian date

  • OceanBase error code: 5633

  • Cause: The day of the week (1 - 7) conflicts with the Julian date. For example, SELECT TO_DATE('3 2459063','D J') FROM DUAL;.

ERROR 5634 (HY000) : hour conflicts with seconds in day

  • OceanBase error code: 5634

  • Cause: The hour conflicts with the seconds in a day.

ERROR 5635 (HY000) : minutes of hour conflicts with seconds in day

  • OceanBase error code: 5635

  • Cause: The minutes in an hour conflict with the seconds in a day.

ERROR 5636 (HY000) : seconds of minute conflicts with seconds in day

  • OceanBase error code: 5636

  • Cause: Seconds in a minute conflict with seconds in a day.

ERROR 5637 (HY000) : date not valid for month specified

  • OceanBase error code: 5637

  • Cause: The date is invalid for the specified month.

ERROR 5638 (HY000) : input value not long enough for date format

  • OceanBase error code: 5638

  • Cause: The input value is not long enough to be used as a date format.

ERROR 5639 (HY000) : (full) year must be between -4713 and +9999, and not be 0

  • OceanBase error code: 5639

  • Cause: The year of a valid date must be between 1 and 9999.

ERROR 5640 (HY000) : quarter must be between 1 and 4

  • OceanBase error code: 5640

  • Cause: The value of quarter must be between 1 and 4.

ERROR 5641 (HY000) : not a valid month

  • OceanBase error code: 5641

  • Cause: Not a valid month.

ERROR 5642 (HY000) : not a valid day of the week

  • OceanBase error code: 5642

  • Cause: Not a valid day of the week.

ERROR 5643 (HY000) : day of year must be between 1 and 365 (366 for leap year)

  • OceanBase error code: 5643

  • Cause: The value of day in a year must be between 1 and 365 (366 in a leap year).

ERROR 5644 (HY000) : hour must be between 1 and 12

  • OceanBase error code: 5644

  • Cause: The hour must be between 1 and 12.

ERROR 5645 (HY000) : hour must be between 0 and 23

  • OceanBase error code: 5645

  • Cause: The hour must be between 0 and 23.

ERROR 5646 (HY000) : minutes must be between 0 and 59

  • OceanBase error code: 5646

  • Cause: The minutes must be between 0 and 59.

ERROR 5647 (HY000) : seconds must be between 0 and 59

  • OceanBase error code: 5647

  • Cause: The seconds must be between 0 and 59.

ERROR 5648 (HY000) : seconds in day must be between 0 and 86399

  • OceanBase error code: 5648

  • Cause: The number of seconds in a day must be between 0 and 86399.

ERROR 5649 (HY000) : julian date must be between 1 and 5373484

  • OceanBase error code: 5649

  • Cause: An invalid Julian date was entered.

  • Solution: The entered Julian date must be between 1 and 5373484.

ERROR 5650 (HY000) : AM/A.M. or PM/P.M. required

  • OceanBase error code: 5650

  • Cause: You must specify the date and time format as AM, A.M., PM, or P.M..

ERROR 5651 (HY000) : BC/B.C. or AD/A.D. required

  • OceanBase error code: 5651

  • Cause: You must specify the date and time format as BC, B.C., AD, or A.D..

ERROR 5652 (HY000) : format code appears twice

  • OceanBase error code: 5652

  • Cause: The input format model is incorrect.

  • Solution: Contact technical support for assistance.

ERROR 5653 (HY000) : day of week may only be specified once

  • OceanBase error code: 5653

  • Cause: The day of the week can only be specified once.

ERROR 5654 (HY000) : signed year precludes use of BC/AD

  • OceanBase error code: 5654

  • Cause: A signed date cannot contain both BC and AD.

ERROR 5655 (HY000) : Julian date precludes use of day of year

  • OceanBase error code: 5655

  • Cause: The Julian date and the day of the year cannot be used together.

ERROR 5656 (HY000) : year may only be specified once

  • OceanBase error code: 5656

  • Cause: The year can only be specified once.

ERROR 5657 (HY000) : hour may only be specified once

  • OceanBase error code: 5657

  • Cause: The hour can only be specified once.

ERROR 5658 (HY000) : AM/PM conflicts with use of A.M./P.M

  • OceanBase error code: 5658

  • Cause: AM or PM conflicts with the corresponding A.M. or P.M ..

ERROR 5659 (HY000) : BC/AD conflicts with use of B.C./A.D

  • OceanBase error code: 5659

  • Cause: BC or AD conflicts with the corresponding B.C. or A.D..

ERROR 5660 (HY000) : month may only be specified once

  • OceanBase error code: 5660

  • Cause: The month can only be specified once.

ERROR 5661 (HY000) : day of week may only be specified once

  • OceanBase error code: 5661

  • Cause: The day of the week can be specified only once.

ERROR 5662 (HY000) : format code cannot appear in date input format

  • OceanBase error code: 5662

  • Cause: The format model is incorrect.

  • Solution: Check whether the number format model complies with syntax requirements.

ERROR 5663 (HY000) : a non-numeric character was found where a numeric was expected

  • OceanBase error code: 5663

  • Cause: An invalid numeric character was found.

  • Solution: Check whether there are invalid characters in the numbers of the SQL statement.

ERROR 5664 (HY000) : 'HH24' precludes use of meridian indicator

  • OceanBase error code: 5664

  • Cause: The AM or PM character appears in the H24 format model.

  • Solution: Contact technical support for assistance.

ERROR 5665 (HY000) : missing or illegal character following the escape character

  • OceanBase error code: 5665

  • Cause: The character following the ESCAPE field in the LIKE query statement is invalid.

  • Solution: Check whether the character following the ESCAPE field in the LIKE statement in the SQL statement complies with requirements.

ERROR 5666 (HY000) : escape character must be character string of length 1

  • OceanBase error code: 5666

  • Cause: The character following the ESCAPE field is not a single character during LIKE calculation.

  • Solution: Specify a single character following the ESCAPE field.

ERROR 5667 (HY000) : day of month must be between 1 and last day of month

  • OceanBase error code: 5667

  • Cause: The value for the day of the month must be between 1 and the last day of the month.

ERROR 5668 (HY000) : not a SELECTed expression

  • OceanBase error code: 5668

  • Cause: An expression was specified in the GROUP BY clause, but this expression does not appear in the SELECT clause.

  • Solution: Modify the SQL syntax.

ERROR 5670 (HY000) : (full) year must be between -4713 and +9999, and not be 0

  • OceanBase error code: 5670

  • Cause: The year of a valid date must be between 1 and 9999.

ERROR 5671 (HY000) : such unique or primary key already exists in the table

  • OceanBase error code: 5671

  • Cause: A unique index already exists.

  • Solution: Unique indexes cannot be created repeatedly.

ERROR 5672 (HY000) : such column list already indexed

  • OceanBase error code: 5672

  • Cause: An index was created repeatedly.

  • Solution: Indexes cannot be created repeatedly.

ERROR 5674 (HY000) : argument '%ld' is out of range

  • OceanBase error code: 5674

  • Cause: The specified parameter is out of range.

  • Solution: Adjust the parameter value .

ERROR 5675 (HY000) : ORDER BY item must be the number of a SELECT-list expression

  • OceanBase error code: 5675

  • Cause: The ORDER BY item is not the correct number of a SELECT item.

  • Solution: Adjust the ORDER BY clause in the SQL statement.

ERROR 5676 (HY000) : the interval is invalid

  • OceanBase error code: 5676

  • Cause: The parameter is invalid.

  • Solution: Contact technical support for assistance.

ERROR 5677 (HY000) : PL/SQL: numeric or value error: %.*s

  • OceanBase error code: 5677

  • Cause: Illegal numeric or other data types were encountered during PL execution.

  • Solution: Check the logic for correctness.

ERROR 5678 (HY000) : name already used by an existing constraint

  • OceanBase error code: 5678

  • Cause: The constraint name already exists.

  • Solution: Change the constraint name.

ERROR 5679 (HY000) : table must have at least one column that is not invisible

  • OceanBase error code: 5679
  • Compatible MySQL error code: 4028
  • Cause: Function-based indexes add hidden columns to a table. This error is returned when all visible columns in the table are deleted while hidden columns exist.
  • Solution: Check the column definitions and metadata of the table to ensure at least one column remains visible after the deletion operation.

ERROR 5681 (HY000) : Column visibility modifications cannot be combined with any other modified column DDL option

  • OceanBase error code: 5681

  • Cause: DDL statements do not support adjusting column visibility and other column attributes simultaneously.

  • Solution: Split the DDL statement to adjust column visibility separately.

ERROR 5682 (HY000) : The visibility of a column from a table owned by a SYS user cannot be changed

  • OceanBase error code: 5682

  • Cause: Column visibility cannot be adjusted for tables owned by the SYS user.

ERROR 5683 (HY000) : too many arguments for function

  • OceanBase error code: 5683

  • Cause: Too many function parameters.

  • Solution: Adjust the number of parameters.

ERROR 5684 (HY000) : PX sql need retry

  • OceanBase error code: 5684

  • Cause: Internal error code. Indicates that PX should retry the SQL.

  • Solution: This error generally does not occur. If encountered, check whether the system switchover and network status are normal.

ERROR 5685 (HY000) : Tenant '(string)' has been dropped

  • OceanBase error code: 5685

  • Cause: The tenant has been dropped.

  • Solution: This is an internal error code. Contact technical support for assistance.

ERROR 5686 (HY000) : invalid extract field for extract source

  • OceanBase error code: 5686

  • Cause: The EXTRACT function cannot parse the specified domain.

  • Solution: Check whether the specified domain is valid.

ERROR 5687 (42000) : %s \'%.*s.%.*s\' compile error

  • OceanBase error code: 5687

  • Cause: Package or UDT compilation failed.

  • Solution: Modify the error according to the error message prompt.

ERROR 5690 (HY000) : subquery not allowed here

  • OceanBase error code: 5690

  • Cause: Subqueries are not allowed at this position.

  • Solution: Contact technical support for assistance.

ERROR 5691 (HY000) : date or system variable wrongly specified in CHECK constraint

  • OceanBase error code: 5691

  • Cause: The CHECK constraint does not allow the use of the DATE function or system variables.

ERROR 5692 (HY000) : Cannot drop constraint - nonexistent constraint

  • OceanBase error code: 5692

  • Cause: The constraint does not exist.

ERROR 5693 (HY000) : check constraint violated

  • OceanBase error code: 5693

  • Cause: The CHECK constraint is not satisfied.

  • Solution: Check whether the data of the columns involved in the DML operation satisfies the existing CHECK constraints.

ERROR 5694 (HY000) : group function is not allowed here

  • OceanBase error code: 5694

  • Cause: An aggregate function is used in an invalid location.

  • Solution: Adjust the aggregate functions in the SQL statement.

ERROR 5695 (HY000) : policy string not found

  • OceanBase error code: 5695

  • Cause: The security policy was not found.

  • Solution: Create a security policy.

ERROR 5696 (HY000) : invalid label string

  • OceanBase error code: 5696

  • Cause: The label string is invalid.

  • Solution: Specify a valid label string.

ERROR 5697 (HY000) : undefined compartment string for policy string

  • OceanBase error code: 5697

  • Cause: The compartment string is invalid.

  • Solution: Specify a valid compartment string.

ERROR 5698 (HY000) : undefined level string for policy string

  • OceanBase error code: 5698

  • Cause: The level string is invalid.

  • Solution: Specify a valid level string.

ERROR 5699 (HY000) : undefined group string for policy string

  • OceanBase error code: 5699

  • Cause: The group string is invalid.

  • Solution: Specify a valid group string.

ERROR 5700 (HY000) : LBAC error: %s

  • OceanBase error code: 5700

  • Cause: A general tag security error. For details, see the specific error message.

  • Solution: Modify the corresponding operation based on the error message.

ERROR 5701 (HY000) : policy role already exists for policy string

  • OceanBase error code: 5701

  • Cause: The policy name already exists.

  • Solution: Check and correct the policy name or delete the existing policy.

ERROR 5702 (HY000) : NULL or invalid user label: %s

  • OceanBase error code: 5702

  • Cause: The user label is invalid.

  • Solution: Specify a valid user label.

ERROR 5703 (HY000) : Add index failed

  • OceanBase error code: 5703

  • Cause: An error occurred while adding an index.

  • Solution: Check whether the index is valid. You can try to drop and recreate it.

ERROR 5704 (HY000) : profile %.*s does not exist

  • OceanBase error code: 5704

  • Cause: The profile name is incorrect.

  • Solution: Check the profile name.

ERROR 5705 (HY000) : invalid resource limit %s

  • OceanBase error code: 5705

  • Cause: In the profile-related DDL, the specified FAILED_LOGIN_ATTEMPTS or PASSWORD_LOCK_TIME is not a valid integer type, or its value is 0.

  • Solution: Adjust the parameter values in the related DDL of the profile.

ERROR 5706 (HY000) : profile %.*s already exists

  • OceanBase error code: 5706

  • Cause: The profile already exists.

  • Solution: Change the profile name .

ERROR 5707 (HY000) : profile %.*s has users assigned, cannot drop without CASCADE

  • OceanBase error code: 5707

  • Cause: The profile is in use by a user. It can only be deleted cascadingly.

  • Solution: Add CASCADE.

ERROR 5708 (HY000) : the leading precision of the interval is too small

  • OceanBase error code: 5708

  • Cause: The precision is invalid.

  • Solution: Contact technical support for assistance.

ERROR 5709 (HY000) : time zone hour must be between -12 and 14

  • OceanBase error code: 5709

  • Cause: The hour value is out of the valid range when setting the time_zone system variable.

  • Solution: The valid range is [-12, 14].

ERROR 5710 (HY000) : time zone minute must be between -59 and 59

  • OceanBase error code: 5710

  • Cause: The minute value is out of the valid range when setting the time_zone system variable.

  • Solution: The valid range is [-59, 59].

ERROR 5711 (HY000) : not a valid time zone

  • OceanBase error code: 5711

  • Cause: TZD, TZH, TZM, and TZR cannot be used in the DATE format.

ERROR 5712 (HY000) : date format is too long for internal buffer

  • OceanBase error code: 5712

  • Cause: The length of the DATE format is too large.

  • Solution: Reduce the length of the DATE format.

ERROR 5713 (HY000) : cannot validate (%.*s.%.*s) - check constraint violated

  • OceanBase error code: 5713

  • Cause: The input violates the constraint.

  • Solution: Contact technical support for assistance.

ERROR 5714 (HY000) : data manipulation operation not legal on this view

  • OceanBase error code: 5714

  • Cause: You attempted to modify an immutable view using INSERT, UPDATE, or DELETE statements, such as a view with generated columns, an expression-based column, or a view whose data comes from multiple tables.

  • Solution: Modify the base table directly, or redefine the view.

ERROR 5715 (HY000) : virtual column not allowed here

  • OceanBase error code: 5715

  • Cause: You attempted to modify an expression in a view using INSERT, DELETE, or UPDATE statements.

  • Solution: Modify the base table directly.

ERROR 5716 (HY000) : cannot modify more than one base table through a join view

  • OceanBase error code: 5716

  • Cause: A column belongs to multiple tables and cannot be inserted into or updated.

  • Solution: Split the statement into multiple statements.

ERROR 5721 (HY000) : cannot delete from view without exactly one key-preserved table

  • OceanBase error code: 5721

  • Cause: The table to be deleted has no key-preserved table, or has multiple key-preserved tables, or the key-preserved table is from a read-only view.

  • Solution: Redefine the view, or perform the deletion on the base table.

ERROR 5722 (HY000) : cannot modify a column which maps to a non key-preserved table

  • OceanBase error code: 5722

  • Cause: You attempted to insert or update a non-key-preserved table in a JOIN view.

  • Solution: Modify the base table directly.

ERROR 5723 (HY000) : cannot perform a DML operation on a read-only view

  • OceanBase error code: 5723

  • Cause: You attempted to modify a view defined as read-only using INSERT, DELETE, or UPDATE statements.

  • Solution: Modify the base table directly, or modify the view to make it updatable.

ERROR 5724 (HY000) : invalid INITRANS option value

  • OceanBase error code: 5724

  • Cause: The value of the INITRANS parameter is invalid.

  • Solution: Adjust the parameter value.

ERROR 5725 (HY000) : invalid MAXTRANS option value

  • OceanBase error code: 5725

  • Cause: The value of the MAXTRANS parameter is invalid.

  • Solution: Adjust the parameter value.

ERROR 5726 (HY000) : invalid value for PCTFREE or PCTUSED

  • OceanBase error code: 5726

  • Cause: The value of the PCTFREE or PCTUSED parameter is invalid.

  • Solution: Adjust the parameter value.

ERROR 5727 (HY000) : SQL request should be rerouted

  • OceanBase error code: 5727

  • Cause: The current SQL request needs to be redirected to another OBServer node for execution.

  • Solution:

    • The normal workflow of OBProxy.
    • If this error frequently appears in application logs, it may indicate improper OBProxy routing configuration, frequent cluster topology changes, or network or node stability issues.

ERROR 5728 (HY000) : illegal argument for function

  • OceanBase error code: 5728

  • Cause: The parameter is invalid.

  • Solution: Adjust the parameter value.

ERROR 5729 (HY000) : this operator cannot be used with lists

  • OceanBase error code: 5729

  • Cause: Vector comparison operations are not supported.

  • Solution: Remove the vector comparison operation.

ERROR 5730 (HY000) : SAMPLE percentage must be in the range [0.000001,100)

  • OceanBase error code: 5730

  • Cause: Parsing error.

  • Solution: Modify the SQL statement.

ERROR 5731 (HY000) : specifying owner's name of the table is not allowed

  • OceanBase error code: 5731

  • Cause: The table object involved in renaming cannot contain a username.

ERROR 5732 (HY000) : stmt trigger with when clause

  • OceanBase error code: 5732

  • Cause: A statement-level trigger cannot specify a WHEN condition.

  • Solution: Remove the WHEN condition from the statement-level trigger.

ERROR 5732 (HY000) : not enough arguments for function

  • OceanBase error code: 5732

  • Cause: Insufficient number of function parameters.

  • Solution: Provide all required parameters.

ERROR 5733 (HY000) : trigger '%.*s' does not exist

  • OceanBase error code: 5733

  • Cause: The specified trigger does not exist.

  • Solution: Verify the existence of the specified trigger.

ERROR 5734 (HY000) : trigger '%.*s' already exist

  • OceanBase error code: 5734

  • Cause: The specified trigger already exists.

  • Solution: Verify the existence of the specified trigger.

ERROR 5735 (HY000) : trigger '%.*s' already exists on another table, cannot replace it

  • OceanBase error code: 5735

  • Cause: A trigger with the same name already exists on another table, preventing the creation of the current trigger.

  • Solution: Rename the current trigger and then create it again.

ERROR 5736 (HY000) : error signaled in parallel query server

  • OceanBase error code: 5736

  • Cause: An internal error code. When PX needs to terminate execution, it broadcasts this error code to all execution nodes to stop the current execution.

  • Solution: This is an internal error code. Please contact technical support for assistance in troubleshooting.

ERROR 5763 (HY000) : Specified pseudo column or operator not allowed here

  • OceanBase error code: 5763

  • Cause: The LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, or CONNECT_BY_ISCYCLE keywords are not allowed at this position.

  • Solution: Remove the LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, or CONNECT_BY_ISCYCLE keyword.

ERROR 5764 (HY000) : CONNECT BY loop in user data

  • OceanBase error code: 5764

  • Cause: A CONNECT BY loop exists in the user data.

ERROR 5765 (HY000) : cannot have join with CONNECT BY

  • OceanBase error code: 5765

  • Cause: Joins are not allowed with CONNECT BY.

ERROR 5766 (HY000) : CONNECT BY clause required in this query block

  • OceanBase error code: 5766

  • Cause: A CONNECT BY clause is required in this query block.

ERROR 5768 (HY000) : SYS_CONNECT_BY_PATH function is not allowed here

  • OceanBase error code: 5768

  • Cause: The SYS_CONNECT_BY_PATH function is called outside the SELECT list and ORDER BY clause.

  • Solution: Remove calls to the SYS_CONNECT_BY_PATH function outside the SELECT list and ORDER BY clause.

ERROR 5769 (HY000) : illegal parameter in SYS_CONNECT_BY_PATH function

  • OceanBase error code: 5769

  • Cause: The SYS_CONNECT_BY_PATH function contains invalid parameters.

ERROR 5770 (HY000) : A column value contained the string that the SYS_CONNECT_BY_PATH function was to use to separate column values

  • OceanBase error code: 5770

  • Cause: A column value contains the string that the SYS_CONNECT_BY_PATH function uses to separate column values.

  • Solution: Specify another separator for the SYS_CONNECT_BY_PATH function, ensuring this separator is not present in any column value.

ERROR 5771 (HY000) : CONNECT BY ROOT operator is not supported in the START WITH or in the CONNECT BY condition

  • OceanBase error code: 5771

  • Cause: Attempted to use the CONNECT BY ROOT operator in a START WITH or CONNECT BY condition.

  • Solution: Remove the CONNECT BY ROOT operator from the START WITH or CONNECT BY condition.

ERROR 5772 (HY000) : ORDER SIBLINGS BY clause not allowed here

  • OceanBase error code: 5772

  • Cause: The query with the specified ORDER SIBLINGS BY clause does not contain a CONNECT BY clause.

  • Solution: Remove the ORDER SIBLINGS BY clause or add a CONNECT BY clause to the query.

ERROR 5773 (HY000) : NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudo column

  • OceanBase error code: 5773

  • Cause: Specified CONNECT_BY_ISCYCLE in the query, but the query does not contain the NOCYCLE keyword.

  • Solution: Remove CONNECT_BY_ISCYCLE or add the NOCYCLE keyword.

ERROR 5774 (HY000) : not enough arguments for function

  • OceanBase error code: 5774

  • Cause: Insufficient parameters for the function.

ERROR 5777 (HY000) : Prepare statement checksum error

  • OceanBase error code: 5777

  • Cause: The server session is in a non-recoverable state.

  • Solution: Log in to OceanBase AI Database again to automatically create a new server session. For details, check the session trace file.

ERROR 5778 (HY000) : cannot enable constraint (%.*s) - no such constraint

  • OceanBase error code: 5778

  • Cause: The specified constraint does not exist in this table.

ERROR 5779 (HY000) : cannot disable constraint (%.*s) - no such constraint

  • OceanBase error code: 5779

  • Cause: The specified constraint does not exist in this table.

ERROR 5780 (HY000) : PX DOP downgrade from %ld to %ld

  • OceanBase error code: 5780

  • Cause: Normal exit.

ERROR 5785 (HY000) : cannot validate (%.*s.%.*s) - parent keys not found

  • OceanBase error code: 5785

  • Cause: The operation to modify the table failed validation constraints because the table contains orphan subrecords.

ERROR 5786 (HY000) : Column check constraint cannot reference other columns

  • OceanBase error code: 5786

  • Cause: Attempt to define a column check constraint that references another column.

  • Solution: Define it as a table check constraint.

ERROR 5787 (HY000) : batched multi statement execution needs rollback

  • OceanBase error code: 5787

  • Cause: Does not meet the execution requirements for batched multi-stmt.

  • Solution: No action required. The server will automatically roll back to single-statement execution.

ERROR 5788 (HY000) : cannot select FOR UPDATE from view with ISTINCT, GROUP BY, etc

  • OceanBase error code: 5788

  • Cause: Attempt to select FOR UPDATE from an unmerged view. The view is unmerged because it uses syntax that prevents merging (such as DISTINCT or GROUP BY) or due to parameter settings in the initialization file.

  • Solution: Determine the reason why the view is unmerged and modify it so that the view can be merged.

ERROR 5789 (HY000) : policy with check option violation

  • OceanBase error code: 5789

  • Cause: Incorrect write of the data security marker.

ERROR 5790 (HY000) : policy already applied to table

  • OceanBase error code: 5790

  • Cause: Attempt to apply a policy to a table that is already protected by that policy.

  • Solution: To change policy options, predicates, or label values, remove the policy from the table and then reapply it.

ERROR 5791 (HY000) : table '%.*s'.'%.*s' is mutating, trigger/function may not see it

  • OceanBase error code: 5791

  • Cause: A trigger (or a user-defined plsql function referenced in this statement) attempts to view (or modify) a table, but statements that trigger this table are also modifying it.

  • Solution: Rewrite the trigger (or function) so that it does not read from this table.

Related issue case:

  • Error 'table is mutating' when calling a function in a DML statement

ERROR 5792 (HY000) : column is referenced in a multi-column constraint

  • OceanBase error code: 5792

  • Cause: You try to drop a column that is referenced by a constraint.

  • Solution: Drop all constraints that reference this column or specify CASCADE CONSTRAINTS in the statement.

ERROR 5793 (HY000) : cannot drop parent key column

  • OceanBase error code: 5793

  • Cause: You try to drop a parent key column that is referenced by a constraint.

  • Solution: Drop all constraints that reference the parent key column or specify CASCADE CONSTRAINTS in the statement.

ERROR 5794 (HY000) : auto increment service busy

  • OceanBase error code: 5794

  • Cause: Internal error code.

  • Solution: Contact technical support for assistance.

ERROR 5795 (HY000) : No insert/update/delete on table with constraint (%.*s.%.*s) disabled and validated

  • OceanBase error code: 5795

  • Cause: You try to perform an INSERT, UPDATE, or DELETE operation on a table with the DISABLE VALIDATE constraint enabled.

  • Solution: Change the state of the constraint.

ERROR 5796 (HY000) : active autonomous transaction detected and rolled back

  • OceanBase error code: 5796

  • Cause: All autonomous transactions started within an autonomous PL block must be completed (committed or rolled back) before returning from the block. If not, the running autonomous transaction is implicitly rolled back, and this error code is returned.

  • Solution: Ensure that any ongoing autonomous transactions are explicitly specified or rolled back before returning from the autonomous PL block.

ERROR 5797 (HY000) : ORDER BY not allowed here

  • OceanBase error code: 5797

  • Cause: The ORDER BY clause is not allowed for the DISTINCT function and the RATIO_TO_REPORT function.

ERROR 5798 (HY000) : DISTINCT not allowed here

  • OceanBase error code: 5798

  • Cause: The DISTINCT option is not allowed for this function.

ERROR 5799 (HY000) : assign user variable with := only allowed in select filed list and as root expression

  • OceanBase error code: 5799

  • Cause: When using := to assign a value to a user variable, it is only allowed inside a SELECT statement and must be the root node of an expression.

  • Solution: It is recommended not to use := to assign values to user variables.

ERROR 5800 (HY000) : cannot modify constraint (%.*s) - no such constraint

  • OceanBase error code: 5800

  • Cause: The specified constraint does not exist on this table.

ERROR 5801 (HY000) : implementation restriction: exception handler in nested transaction is illegal

  • OceanBase error code: 5801

  • Cause: Catching exceptions is not allowed within nested transactions.

  • Solution: Remove exception catching from nested transactions.

ERROR 5802 (HY000) : invalid ROWID

  • OceanBase error code: 5802

  • Cause: The ROWID is invalid.

ERROR 5803 (HY000) : Invalid column in the INSERT VALUES Clause:'%.*s'.'%.*s'

  • OceanBase error code: 5803

  • Cause: The INSERT VALUES clause references an invalid table column.

ERROR 5804 (HY000) : incorrect use of the ['%.*s'] operator

  • OceanBase error code: 5804

  • Cause: An error occurred during the execution of an arithmetic operation.

  • Solution: Check the operator's parameters and return type.

ERROR 5805 (HY000) : non-constant expression is not allowed for pivot|unpivot values

  • OceanBase error code: 5805

  • Cause: A non-constant expression was used for a pivot|unpivot value.

  • Solution: Use a constant expression for the pivot|unpivot value.

ERROR 5806 (HY000) : expect aggregate function inside pivot operation

  • OceanBase error code: 5806

  • Cause: An attempt was made to use a non-aggregate function inside a pivot operation.

  • Solution: Use an aggregate function.

ERROR 5807 (HY000) : expression must have same datatype as corresponding expression

  • OceanBase error code: 5807

  • Cause: An expression must have the same data type as its corresponding expression.

ERROR 5808 (HY000) : character set mismatch

  • OceanBase error code: 5808

  • Cause: One of the following situations may have occurred:

    • The string operands of operators or built-in functions (except for the nlsparams parameter) use different character sets.

    • The nlsparams operand is not in the database character set.

    • The string data passed to a built-in function uses a character set other than the database character set, and the built-in function does not accept that character set.

    • The second parameter of CHR() or CSCONVERT() is not CHAR_CS or NCHAR_CS.

    • The character set of a string expression in the VALUES clause of an INSERT statement or in the SET clause of an UPDATE statement is inconsistent with the character set used by the column to be inserted.

    • The character set of the value provided in the DEFAULT clause when creating a table is inconsistent with the character set declared for the column.

    • The parameter of a PL/SQL function does not meet the character set requirements of the corresponding parameter.

ERROR 5809 (HY000) : regular expression failed to match

  • OceanBase error code: 5809

  • Cause: The regular expression matching failed, and no matching string was found.

  • Solution: This is an internal error code. Contact technical support for assistance.

ERROR 5810 (HY000) : invalid regular expression (reg version 0.8)

  • OceanBase error code: 5810

  • Cause: The given regular expression pattern is invalid.

  • Solution: Adjust the given regular expression pattern.

ERROR 5811 (HY000) : invalid escape \\ sequence in regular expression

  • OceanBase error code: 5811

  • Cause: An invalid ESCAPE is found in the regular expression.

  • Solution: Remove the invalid ESCAPE.

ERROR 5812 (HY000) : unmatched bracket in regular expression

  • OceanBase error code: 5812

  • Cause: The regular expression has an unmatched square bracket.

  • Solution: Ensure that the square brackets are matched.

ERROR 5813 (HY000) : unmatched parentheses in regular expression

  • OceanBase error code: 5813

  • Cause: The regular expression has an unmatched round bracket.

  • Solution: Ensure that the round brackets are matched.

ERROR 5814 (HY000) : invalid back reference in regular expression

  • OceanBase error code: 5814

  • Cause: A back reference is used in a subexpression.

  • Solution: Ensure that the referenced subexpression is valid.

ERROR 5815 (HY000) : invalid range in regular expression

  • OceanBase error code: 5815

  • Cause: An invalid range is found in the regular expression.

  • Solution: Ensure that a valid range is used.

ERROR 5816 (HY000) : invalid character class in regular expression

  • OceanBase error code: 5816

  • Cause: An unknown character class is found in the regular expression.

  • Solution: Ensure that a valid character class is used.

ERROR 5817 (HY000) : invalid collation class in regular expression

  • OceanBase error code: 5817

  • Cause: The regular expression contains an unknown collation class.

  • Solution: Ensure that a valid collation class is used.

ERROR 5818 (HY000) : braces {} not balanced in in regular expression

  • OceanBase error code: 5818

  • Cause: The {} in the regular expression is not fully enclosed.

  • Solution: Correct the {} in the regular expression.

ERROR 5819 (HY000) : invalid repetition count(s) in regular expression

  • OceanBase error code: 5819

  • Cause: The regular expression engine encountered invalid repetition counts.

  • Solution: Contact technical support for assistance.

ERROR 5820 (HY000) : The regular expression was too complex and current library can't be parsed

  • OceanBase error code: 5820

  • Cause: The regular expression is too complex for the current regular expression engine to parse.

  • Solution: Contact technical support for assistance.

ERROR 5821 (HY000) : regular expression internal error

  • OceanBase error code: 5821

  • Cause: The regular expression is too complex for the current regular expression engine to parse.

  • Solution: Contact technical support for assistance.

ERROR 5822 (HY000) : invalid argument in regular expression

  • OceanBase error code: 5822

  • Cause: The regular expression contains invalid arguments.

  • Solution: Check the validity of the arguments in the regular expression.

ERROR 5823 (HY000) : character widths of regex and string differ in regular expression

  • OceanBase error code: 5823

  • Cause: The regular expression engine encountered a mix of different character sets.

  • Solution: Contact technical support for assistance.

ERROR 5824 (HY000) : invalid embedded option in regular expression

  • OceanBase error code: 5824

  • Cause: The pattern in the regular expression specifies an invalid matching parameter.

  • Solution: Correct the pattern matching parameter in the regular expression.

ERROR 5825 (HY000) : nfa has too many states in regular expression, may be the regular expression too long

  • OceanBase error code: 5825

  • Cause: An exception occurred in the transition-state machine of the regular expression engine.

  • Solution: Contact technical support for assistance.

ERROR 5827 (HY000) : the definition of relative objects have been modified, please check and retry

  • OceanBase error code: 5827

  • Cause: A concurrency DDL operation encountered a conflict.

  • Solution: This is an internal error code. Contact technical support for assistance.

ERROR 5828 (HY000) : Subscript beyond count

  • OceanBase error code: 5828

  • Cause: The subscript is greater than the maximum length of the VARRAY array or is too large for a nested table.

  • Solution: Check the program logic and explicitly extend it if necessary.

ERROR 5829 (HY000) : PARTITION () clause on non partitioned table

  • OceanBase error code: 5829

  • Cause: The table or index is not partitioned. Syntax error.

  • Solution: Retry the command using the correct syntax.

ERROR 5830 (HY000) : Unknown subpartition

  • OceanBase error code: 5830

  • Cause: The secondary partition of the object was not found.

  • Solution: Use the correct subpartition name and try again.

ERROR 5831 (HY000) : Invalid SQL ROW LIMITING expression was specified

  • OceanBase error code: 5831

  • Cause: The ROW LIMITING expression in the SQL statement contains components other than text, bound variables, related variables, or subqueries.

  • Solution: Modify the ROW LIMITING expression in the SQL statement and try again.

ERROR 5833 (HY000) : not implemented in SQL static typing engine

  • OceanBase error code: 5833

  • Cause: This feature is not implemented in the new engine.

  • Solution: No action is required. The SQL engine will automatically retry.

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

  • OceanBase error code: 5834

  • Cause: The object already exists.

  • Solution: The object involved in the PL statement already exists and cannot be created repeatedly.

ERROR 5835 (HY000) : connection description for remote database not found

  • OceanBase error code: 5835

  • Cause: The connection description for the remote database could not be found.

ERROR 5836 (HY000) : database link not found

  • OceanBase error code: 5836

  • Cause: The database link to be dropped could not be found in the dictionary.

  • Solution: Correct the database link name.

ERROR 5837 (HY000) : Reference to uninitialized composite

  • OceanBase error code: 5837

  • Cause: A composite, LOB, or other multi-part partition is referenced on the left side, but the object, LOB, or other multi-part partition is not initialized.

  • Solution: Initialize the multi-part partition using the appropriate constructor or a full-object assignment.

ERROR 5838 (HY000) : Reference to uninitialized collection

  • OceanBase error code: 5838

  • Cause: An element of a nested table or Varray, or a Member function, was referenced when the collection was not initialized.

  • Solution: Initialize the collection using an appropriate constructor or a full-object assignment.

ERROR 5839 (HY000) : no more rows needed

  • OceanBase error code: 5839

  • Cause: The caller of the pipeline function does not need the pipeline function to generate more rows.

  • Solution: Do not catch the NO_DATA_NEEDED exception in the exception handling block.

ERROR 5840 (HY000) : PL/SQL: program error

  • OceanBase error code: 5840

  • Cause: This is an internal error message. An error was detected in the PL program.

  • Solution: This is an internal error code. Contact technical support engineers for assistance in troubleshooting.

ERROR 5841 (HY000) : PL/SQL: Return types of Result Set variables or query do not match

  • OceanBase error code: 5841

  • Cause: The number or type of columns in the query does not match the return type declared for the result set variables, or the types declared for two result set variables do not match.

  • Solution: Modify the program statements or declarations.

ERROR 5842 (HY000) : PL/SQL: storage error

  • OceanBase error code: 5842

  • Cause: PL cannot allocate additional storage. Sometimes this error may be caused by an out-of-control program.

  • Solution:

    1. Ensure there are no issues or errors using additional memory in the PL program.

    2. Programmatically release unused objects (for example, set them to NULL).

    3. Increase the amount of shared or process memory available (if applicable).

ERROR 5843 (HY000) : Subscript outside of limit

  • OceanBase error code: 5843

  • Cause: The subscript is greater than the limit value of the VARRAY, or the subscript is a non-positive value for the VARRAY or nested table.

  • Solution: Check the program logic and, if necessary, increase the limit value of the VARRAY.

ERROR 5844 (HY000) : invalid cursor

  • OceanBase error code: 5844

  • Cause: The cursor is invalid.

ERROR 5845 (HY000) : invalid username/password; logon denied

  • OceanBase error code: 5845

  • Cause: The username or password is invalid. Logon is denied.

ERROR 5846 (HY000) : not logged on

  • OceanBase error code: 5846

  • Cause: Not logged on.

ERROR 5847 (HY000) : method dispatch on NULL SELF argument is disallowed

  • OceanBase error code: 5847

  • Cause: A Member method of some type is called with a NULL SELF parameter.

  • Solution: Change the method call type to pass a valid SELF parameter.

ERROR 5848 (HY000) : timeout occurred while waiting for a resource

  • OceanBase error code: 5848

  • Cause: Usually due to a dead instance.

  • Solution: Check if there are any dead or unrecovered instances. If so, recover them.

ERROR 5849 (HY000) : column to be modified to NOT NULL is already NOT NULL

  • OceanBase error code: 5849

  • Cause: The column to be changed to NOT NULL is already NOT NULL.

ERROR 5850 (HY000) : column to be modified to NULL cannot be modified to NULL

  • OceanBase error code: 5850

  • Cause: The column may already allow NULL values, and the NOT NULL constraint is part of a primary key or a CHECK constraint.

  • Solution: If a primary key or CHECK constraint enforces the NOT NULL constraint, remove that constraint.

ERROR 5851 (HY000) : cannot enable (%.*s.%.*s) - null values found

  • OceanBase error code: 5851

  • Cause: The operation to enable constraints on the table failed because some values in the table do not meet the constraints.

ERROR 5852 (HY000) : Argument should be a constant

  • OceanBase error code: 5852

  • Cause: The parameter must be a constant.

ERROR 5853 (HY000) : not a single-group group function

  • OceanBase error code: 5853

  • Cause: It is not a single-group Group function.

ERROR 5854 (HY000) : illegal zero-length identifier

  • OceanBase error code: 5854

  • Cause: Illegal zero-length identifier.

ERROR 5855 (HY000) : parameter cannot be modified because specified value is invalid

  • OceanBase error code: 5855

  • Cause: Initialization parameters can be modified, but the specified value is invalid.

  • Solution: Refer to the "Reference guide" for the corresponding version of OceanBase AI Database to view the valid range of this parameter.

ERROR 5856 (HY000) : DBMS_SQL access denied

  • OceanBase error code: 5856

  • Cause: Access to DBMS_SQL has been denied for security reasons.

  • Solution: Try to obtain more information from the Alert logs and trace files.

ERROR 5857 (HY000) : not all variables bound

  • OceanBase error code: 5857

  • Cause: Some variables are not configured.

ERROR 5859 (HY000) : column is referenced in a multi-column constraint

  • OceanBase error code: 5859

  • Cause: You tried to drop a column that is referenced by a multi-column constraint.

  • Solution: Drop all constraints that reference this column or specify CASCADE CONSTRAINTS in the statement.

ERROR 5860 (HY000) : cannot modify column datatype with current constraint(s)

  • OceanBase error code: 5860

  • SQLSTATE: HY000

  • Cause: You are trying to modify the data type of a column with a CHECK constraint. However, for a column with a CHECK constraint, you can only change the data type from CHAR to VARCHAR.

  • Solution: Drop the constraint or do not perform the invalid operation.

ERROR 5861 (HY000) : The percentile value should be a number between 0 and 1

  • OceanBase error code: 5861

  • Cause: The percentile value specified for the PERCENTILE_CONT or PERCENTILE_DISC function is not within the valid range.

  • Solution: Specify a value within the [0,1] range.

ERROR 5862 (HY000) : The argument should be of numeric or date/datetime type

  • OceanBase error code: 5862

  • Cause: The parameter must be of numeric or date/time type.

ERROR 5863 (HY000) : ALTER TABLE|INDEX RENAME may not be combined with other operations

  • OceanBase error code: 5863

  • Cause: The ALTER TABLE or ALTER INDEX statement attempts to combine a RENAME operation with other operations, which is illegal.

  • Solution: Ensure the ALTER TABLE or ALTER INDEX statement contains only the RENAME operation.

ERROR 5864 (HY000) : only simple column names allowed here

  • OceanBase error code: 5864

  • Cause: Only simple column names are allowed here.

ERROR 5866 (HY000) : cannot specify <(sub)partition-description> clause in CREATE TABLE or CREATE INDEX)

  • OceanBase error code: 5866

  • Cause: The request attempts to generate a default partition description (possibly via PARTITIONS number-of-partitions) while specifying the <(sub)partition-description> clause, which is illegal.

  • Solution: Remove one of the offending clauses.

ERROR 5867 (HY000) : Duplicate partition name %.*s

  • OceanBase error code: 5867

  • Cause: The name of a subpartition created for a table or index is not unique.

  • Solution: Rename the subpartition to ensure its name is unique among all subpartitions created for the table or index.

ERROR 5868 (HY000) : Incorrect usage of UPDATE and ORDER BY

  • OceanBase error code: 5868

  • Cause: The ORDER BY clause cannot be used when performing a multi-table UPDATE.

  • Solution: Remove the ORDER BY clause.

ERROR 5869 (HY000) : Incorrect usage of UPDATE and LIMIT

  • OceanBase error code: 5869

  • Cause: The LIMIT clause cannot be used when performing a multi-table UPDATE.

  • Solution: Remove the LIMIT clause.

ERROR 5870 (HY000) : rowid type mismatch, expect %.*s, got %.*s

  • OceanBase error code: 5870

  • Cause: Internal error code.

  • Solution: Contact technical support for assistance.

ERROR 5871 (HY000) : rowid num mismatch, expect %ld, actual %ld

  • OceanBase error code: 5871

  • Cause: Internal error code.

  • Solution: Contact technical support for assistance.

ERROR 5872 (HY000) : must name %.*s with a column alias

  • OceanBase error code: 5872

  • SQLSTATE: HY000

  • Cause: The expression must be named with a column alias.

ERROR 5873 (HY000) : the numeric value does not match the length of the format item

  • OceanBase error code: 5873

  • Cause: When specifying the FX or FM format codes for an input date, the number of digits must exactly match the number of digits specified by the format code. For example, 9 does not match the format specifier DD, but 09 does.

  • Solution: Correct the input date or remove the FX or FM format specifiers from the format string.

ERROR 5874 (HY000) : invalid datatype

  • OceanBase error code: 5874

  • Cause: Invalid data type.

ERROR 5875 (HY000) : table is not partitioned by composite partition method

  • OceanBase error code: 5875

  • Cause: Performing a subpartition maintenance operation on a non-subpartitioned table.

  • Solution: Ensure the table is a subpartitioned table.

ERROR 5876 (HY000) : VALUES IN (<value list>) cannot be used for Range subpartitioned tables

  • OceanBase error code: 5876

  • Cause: The VALUES (value list) clause is used for RANGE subpartitioned tables.

  • Solution: Use the VALUES LESS THAN or AT clause with RANGE subpartitioned tables.

ERROR 5877 (HY000) : VALUES IN (<value list>) clause expected

  • OceanBase error code: 5877

  • Cause: The VALUES (value list) clause was not specified for the LIST subpartition.

  • Solution: Specify the VALUES (value list) clause.

ERROR 5879 (HY000) : Expecting VALUES LESS THAN or AT clause

  • OceanBase error code: 5879

  • Cause: The VALUES (value list) clause can only be used with LIST partitioned tables.

  • Solution: Use the VALUES LESS THAN clause with a RANGE-partitioned table.

ERROR 5880 (HY000) : procedure, function, package, or package body does not exist

  • OceanBase error code: 5880

  • Cause: You are trying to access a non-existent procedure, function, package, or package body.

  • Solution: Ensure that the name of the object you want to access is correct.

ERROR 5882 (HY000) : invalid time limit specified

  • OceanBase error code: 5882

  • Cause: The input parameter time of the dbms_lock.sleep(time) package specifies a non-positive value.

  • Solution: Specify a positive value.

ERROR 5883 (HY000) : ## ERROR(s) in array DML

  • OceanBase error code: 5883

  • Cause: One or more rows in the DML statement failed.

  • Solution: Check the error stack during exception capture to obtain the specific exception.

ERROR 5884 (42000) : %s \'%.*s.%.*s\' compile error

  • OceanBase error code: 5884

  • Cause: An error occurred in the DDL statement that creates the trigger.

  • Solution: Modify the DDL statement as prompted and re-execute it.

ERROR 5887 (HY000) : missing or invalid password(s)

  • OceanBase error code: 5887

  • Cause: The password is incorrect.

  • Solution: Ensure that you are using the correct password and try again.

ERROR 5889 (HY000) : no matching unique or primary key for this column-list

  • OceanBase error code: 5889

  • Cause: The REFERENCES clause in a CREATE TABLE or ALTER TABLE statement provides a list of columns, but there is no matching unique or primary key constraint in the referenced table.

  • Solution: Use the ALL_CONS_COLUMNS directory view to find the correct column name.

ERROR 5890 (HY000) : duplicate referential constraint specifications

  • OceanBase error code: 5890

  • Cause: When creating a table, there are multiple foreign key constraints on the same table that have the same referencing and referenced columns.

  • Solution: Modify the CREATE TABLE statement to ensure that a table cannot have multiple foreign key constraints with the same referencing and referenced columns.

ERROR 5891 (HY000) : such a referential constraint already exists in the table

  • OceanBase error code: 5891

  • Cause: When modifying a table, there are multiple foreign key constraints on the same table that have the same referencing and referenced columns.

  • Solution: Modify the ALTER TABLE statement to ensure that a table cannot have multiple foreign key constraints with the same referencing and referenced columns.

ERROR 5893 (HY000) : specified data type is not supported for a virtual column

  • OceanBase error code: 5893

  • Cause: The data type of the generated column is the currently unsupported LOB type.

  • Solution: Adjust the data type of the generated column.

ERROR 5894 (HY000) : referenced table does not have a primary key

  • OceanBase error code: 5894

  • Cause: When specifying the referenced column of a foreign key, the parent table lacks a primary key.

  • Solution: Before creating a foreign key, you must create a primary key or a unique index on the referenced column.

ERROR 5895 (HY000) : data type or length of a table partitioning column may not be changed

  • OceanBase error code: 5895

  • Cause: The data type and length of a partitioning column cannot be changed.

ERROR 5896 (HY000) : data type or length of a table partitioning column may not be changed

  • OceanBase error code: 5896

  • Cause: The data type and length of a subpartitioning column cannot be changed.

ERROR 5897 (HY000) : cannot decrease column length because some value is too big

  • OceanBase error code: 5897

  • Cause: The maximum column length cannot be reduced.

ERROR 5898 (HY000) : Datetime/Interval internal error

  • OceanBase error code: 5898

  • Cause: Internal error.

  • Solution: Contact technical support for assistance.

ERROR 5899 (HY000) : partition extended table name cannot refer to a remote object

  • OceanBase error code: 5899

  • Cause: Attempted to name a remote object using extended partition table syntax.

  • Solution: Correct the expression and try again.

ERROR 5901 (HY000) : a view is not appropriate here

  • OceanBase error code: 5901

  • Cause: Attempted to define EDITIONING_VIEW on a view.

  • Solution: EDITIONING_VIEW can only be created on base tables.

ERROR 5902 (HY000) : cannot select ROWID from,or sample, a join view without a key-preserved table

  • OceanBase error code: 5902

  • Cause: Cannot query ROWID from a joined view or sample without a key-preserved table.

ERROR 5903 (HY000) : cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc

  • OceanBase error code: 5903

  • Cause: Cannot query ROWID from a view with DISTINCT or GROUP BY.

ERROR 5904 (HY000) : table must have at least 1 column that is not virtual

  • OceanBase error code: 5904

  • Cause: You attempted to create a table that contains only virtual columns.

  • Solution: Ensure the table to be created contains at least one non-virtual column.

ERROR 5905 (HY000) : only pure functions can be indexed

  • OceanBase error code: 5905

  • Cause: The index function uses SYSDATE or the user environment.

  • Solution: The PL function must be a pure function (RNDS, RNPS, WNDS, WNPS).

ERROR 5906 (HY000) : only pure functions can be specified in a virtual column expression

  • OceanBase error code: 5906

  • Cause: The virtual column expression contains a function whose value is uncertain.

  • Solution: Rewrite the expression to reference only pure functions.

ERROR 5907 (HY000) : UPDATE operation disallowed on virtual columns

  • OceanBase error code: 5907

  • Cause: You attempted to update the value of a virtual column.

  • Solution: Rerun the statement without setting the value for the virtual column.

ERROR 5908 (HY000) : Invalid column expression was specified

  • OceanBase error code: 5908

  • Cause: The virtual column expression is not a valid arithmetic expression. It may reference another column in the table.

  • Solution: Modify the virtual column expression.

ERROR 5909 (HY000) : table can have only one identity column

  • OceanBase error code: 5909

  • Cause: You attempted to specify multiple identity columns for a table.

  • Solution: Specify only one identity column per table.

ERROR 5910 (HY000) : invalid NOT NULL constraint specified on an identity column

  • OceanBase error code: 5910

  • Cause: The NOT NULL constraint was not correctly specified on the identity column.

  • Solution: If the NOT NULL constraint is specified on the identity column, it must be enabled and cannot be deferred.

ERROR 5911 (HY000) : cannot modify NOT NULL constraint on an identity column

  • OceanBase error code: 5911

  • Cause: The NOT NULL constraint on the identity column cannot be modified.

  • Solution: Do not modify the NOT NULL constraint on the identity column.

ERROR 5912 (HY000) : cannot drop NOT NULL constraint on an identity column

  • OceanBase error code: 5912

  • Cause: The NOT NULL constraint on the identity column cannot be dropped.

  • Solution: Do not drop the NOT NULL constraint on the identity column. The only way to remove a constraint is to use the DROP IDENTITY clause of ALTER TABLE MODIFY to drop the column's identity attribute.

ERROR 5913 (HY000) : column to be modified is not an identity column

  • OceanBase error code: 5913

  • Cause: You are trying to modify the identity attribute of a column that is not an identity column.

  • Solution: Modify the identity attribute of the identity column.

ERROR 5914 (HY000) : identity column cannot have a default value

  • OceanBase error code: 5914

  • Cause: You are trying to add a default value to the identity column.

  • Solution: You cannot specify a default value for the identity column.

ERROR 5915 (HY000) : identity column must be a numeric type

  • OceanBase error code: 5915

  • Cause: You are trying to create or change the value of an identity column to a non-numeric data type.

  • Solution: Do not assign non-numeric data types to the identity column.

ERROR 5916 (HY000) : prebuilt table managed column cannot be an identity column

  • OceanBase error code: 5916

  • Cause: An attempt was made to create an instance view on a prebuilt table with an identity column.

  • Solution: Either remove the IDENTITY attribute or remove the identity column from the instance view definition.

ERROR 5917 (HY000) : cannot alter a system-generated sequence

  • OceanBase error code: 5917

  • Cause: An attempt was made to modify a system-generated sequence.

  • Solution: System-generated sequences, such as those created for identity columns, cannot be modified.

ERROR 5918 (HY000) : cannot drop a system-generated sequence

  • OceanBase error code: 5918

  • Cause: An attempt was made to drop a system-generated sequence.

  • Solution: System-generated sequences, such as those created for identity columns, cannot be dropped.

ERROR 5919 (HY000) : cannot insert into a generated always identity column

  • OceanBase error code: 5919

  • Cause: An attempt was made to insert a value into an identity column created using the GENERATED ALWAYS keyword.

  • Solution: Identity columns generated using the GENERATED ALWAYS keyword cannot be directly inserted. Instead, the value is provided by the associated sequence generator.

ERROR 5920 (HY000) : cannot update a generated always identity column

  • OceanBase error code: 5920

  • Cause: An attempt was made to update an identity column created using the GENERATED ALWAYS keyword.

  • Solution: Identity columns generated using the GENERATED ALWAYS keyword cannot be directly updated.

ERROR 5921 (HY000) : identity column sequence mismatch in ALTER TABLE EXCHANGE PARTITION

  • OceanBase error code: 5921

  • Cause: The sequences of the identity columns for the two tables specified in the EXCHANGE clause do not increase or decrease by the same amount.

  • Solution: Ensure that the identity columns with INCREMENT BY have sequences with the same sign.

ERROR 5922 (HY000) : cannot rename a system-generated sequence

  • OceanBase error code: 5922

  • Cause: An attempt was made to rename a system-generated sequence.

  • Solution: System-generated sequences (such as those created for identity columns) cannot be renamed.

ERROR 5923 (HY000) : UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column

  • OceanBase error code: 5923

  • Cause: UPDATE or REFERENCES can only be revoked from the entire table, not by column.

ERROR 5924 (HY000) : not executed, type body '%.*s' does not exist

  • OceanBase error code: 5924

  • Cause: An attempt was made to execute a non-existent stored program.

  • Solution: Ensure the correct name is provided.

ERROR 5925 (HY000) : The argument [%s] of WIDTH_BUCKET function is NULL or invalid

  • OceanBase error code: 5925

  • Cause: The parameter [%s] for the WIDTH_BUCKET function is NULL or invalid.

ERROR 5926 (HY000) : Not enough memory for CONNECT BY operation

  • OceanBase error code: 5926

  • Cause: On the new engine, an error is reported when the recursion depth is too deep, with a limit of 2 to the power of 30. On the old engine, an error is reported if the number of all nodes and their descendants on the path from the root node to the current node exceeds a fixed value (2 to the power of 30). This value is currently set fixed and generally should not be exceeded.

  • Solution: No temporary solution is available. Increasing memory size does not resolve this issue. The only solution is to reduce the recursion depth or decrease the data volume.

ERROR 5927 (HY000) : illegal parameter in SYS_CONNECT_BY_PATH function

  • OceanBase error code: 5927

  • Cause: There is an illegal parameter in the SYS_CONNECT_BY_PATH function.

ERROR 5928 (HY000) : host %.*s unknown

  • OceanBase error code: 5928

  • Cause: The specified host is unknown.

  • Solution: Check the spelling of the hostname or IP address to ensure it is valid.

ERROR 5929 (HY000) : Window name '%.*s' is not defined

  • OceanBase error code: 5929

  • Cause: The specified window function does not exist.

  • Solution: Ensure the relevant window function has been created and that the correct window function name is used.

ERROR 5930 (HY000) : maximum open %s exceeded

  • OceanBase error code: 5930

  • Cause: The number of cursors open simultaneously in the system exceeds the limit.

  • Solution: Close cursors or adjust the open_cursors parameter.

ERROR 5931 (HY000) : argument is null, invalid, or out of range

  • OceanBase error code: 5931

  • Cause: The passed parameter value is NULL, invalid, or out of range. For example, the position or size parameter for LOB / FILE exceeds the range of 1 to (4GB-1), or a file is opened in an invalid open mode.

  • Solution: Check and correct the program so that it does not pass NULL, invalid, or out-of-range parameter values.

ERROR 5932 (HY000) : unexpected name string

  • OceanBase error code: 5932

  • Cause: Incorrect name character.

ERROR 5933 (HY000) : PL/SQL: could not find program unit being called: '%.*s'

  • OceanBase error code: 5933

  • Cause: The program unit cannot be found.

ERROR 5934 (HY000) : fetch out of sequence

  • OceanBase error code: 5934

  • SQLSTATE: HY000

  • Cause: Attempts to access data from an invalid cursor. This error can occur for the following reasons:

    • Accessing data from the cursor after retrieving the last row and returning the OBE-1403 error.

    • Accessing data after issuing a COMMIT statement following the use of the FOR UPDATE clause to open the cursor.

    • Rebinding all placeholders in an SQL statement and then accessing data before re-executing the statement.

    Note

    Implicit fetches during a PL cursor loop can also cause this error.

  • Solution:

    • Do not issue a FETCH statement after retrieving the last row.

    • Do not access data after issuing a COMMIT following the use of the FOR UPDATE clause to open the cursor.

    • Rebind and execute the SQL statement, then access data.

ERROR 5959 (HY000) : invalid SIZE specified

  • OceanBase error code: 5959

  • Cause: The specified SIZE value for the histogram is out of range.

  • Solution: Specify a SIZE value within the range [1, 2048].

ERROR 5975 (HY000) : \ndblink remote error code: %d,\nremote error msg: %.*s"

  • OceanBase error code: 5975

  • Cause: An error occurred while connecting to the remote database, and the error code cannot be mapped to an OceanBase error code.

  • Solution: Investigate the cause based on the error code provided in the error message.

ERROR 5976 (HY000) : can not find the expected version of OCI LIB: %.*s

  • OceanBase error code: 5976

  • Cause: The expected version of the OCI library was not found.

Previous topic

4500 ~ 4999
Last

Next topic

6000 ~ 6999
Next
on this page
ERROR 5002 (HY000) : Resolve error
ERROR 5010 (21000) : Unknown operator
ERROR 5011 (42000) : Duplicated star
ERROR 5012 (HY000) : Illegal ID
ERROR 5014 (HY000) : Illegal value
ERROR 5016 (HY000) : Generate logical plan error
ERROR 5017 (HY000) : Schema not set
ERROR 5023 (S1004) : unsupport MySQL type (number). Maybe you should use java.sql.Timestamp instead of java.util.Date
ERROR 5031 (HY000) : Column not found
ERROR 5034 (01007) : No user
ERROR 5050 (42710) : User exists
ERROR 5053 (HY093) : Incorrect arguments number to EXECUTE, need %ld arguments but give %ld
ERROR 5058 (42000) : Duplicated parameters
ERROR 5063 (42000) : Unknown hint
ERROR 5066 (HY000) : Session interrupted
ERROR 5071 (42000) : Cannot alter index column
ERROR 5074 (23000) : NOP cannot be used here
ERROR 5081 (25000) : The server is read only now
ERROR 5083 (22000) : invalid obj type for type promotion: left_type=%s right_type=%s
ERROR 5084 (22000) : Can not cast varchar value to bool type
ERROR 5085 (22000) : Not a number Can not cast varchar value to number type
ERROR 5086 (22000) : Not timestamp Can not cast varchar value to timestamp type
ERROR 5087 (22000) : Result value was out of range when cast to number
ERROR 5090 (22000) : Precision was out of range
ERROR 5091 (22000) : Scale value was out of range
ERROR 5092 (42000) : Unknown index
ERROR 5098 (22001) : Data too long(%d>%ld) for column '%s'
ERROR 5099 (42000) : System config unknown
ERROR 5106 (42000) : EXTRACT() expected timestamp or a string as date argument
ERROR 5107 (42000) : Invalid operand type for IS operator, lval=%s
ERROR 5108 (42000) : function LENGTH() expected a varchar argument
ERROR 5110 (42000) : TIME_TO_USEC() expected timestamp or a string as date argument
ERROR 5111 (42000) : USEC_TO_TIME expected a interger number as usec argument
ERROR 5112 (42P01) : Variable %.*s does not exists
ERROR 5114 (42000) : Invalid numeric char '%c'
ERROR 5116 (HY000) : Logical operator child index overflow
ERROR 5117 (HY000) : fail to explain plan
ERROR 5118 (HY000) : fail to copy logical operator
ERROR 5119 (HY000) : fail to generate plan
ERROR 5120 (HY000) : fail to create raw expr
ERROR 5121 (HY000) : fail to generate join order
ERROR 5122 (HY000) : optimizer general error
ERROR 5130 (HY000) : sql resolver no memory
ERROR 5131 (HY000) : plan cache support dml only
ERROR 5133 (42000) : No such grant defined
ERROR 5136 (HY000) : plan exists in plan cache already
ERROR 5137 (HY000) : plan is expired
ERROR 5138 (HY000) : no plan exist
ERROR 5144 (HY000) : COLLATION '%.*s' is notvalid for CHARACTER SET '%.*s'
ERROR 5150 (HY000) : Tenant not in this server
ERROR 5151 (42P01) : tablegroup not exist
ERROR 5156 (HY000) : tenant \'%s\' already exist
ERROR 5157 (HY000) : Unknown tenant '%.*s'
ERROR 5159 (HY000) : tablegroup already exist
ERROR 5160 (HY000) : invalid tenant name specified in connection string
ERROR 5212 (42000) : auto-increment column '%.*s' should not be part of partition key
ERROR 5223 (42000) : wrong ident name
ERROR 5226 (42000) : plan cache memory used reach the high water mark
ERROR 5234 (HY000) : The database \'%.*s\' is read only so it cannot execute this statement
ERROR 5235 (HY000) : The table \'%.*s.%.*s\' is read only so it cannot execute this statement
ERROR 5243 (HY000) : system variables' version maybe different
ERROR 5245 (HY000) : some tasks are skipped, skipped server addr is '%s', the orginal error code is %d
ERROR 5248 (HY000) : Alter table add auto_increment column is dangerous, table_name=\'%.*s\', column_name=\'%s\'
ERROR 5252 (HY000) : Column \'%.*s\' definition is ambiguous. Column has both NULL and NOT NULL attributes
ERROR 5258 (HY000) : Invalid block size, block size should between 1024 and 1048576
ERROR 5260 (HY000) : Tenant \'%.*s\' is locked
ERROR 5264 (HY000) : Outline '%.*s' already exists
ERROR 5265 (HY000) : Outline \'%.*s.%.*s\' doesn\'t exist
ERROR 5267 (HY000) : invalid outline ,error info:%s
ERROR 5268 (HY000) : SQL reach max concurrent num %ld
ERROR 5269 (HY000) : can not perform DDL/DML over objects in Recycle Bin
ERROR 5270 (HY000) : object not in RECYCLE BIN
ERROR 5272 (HY000) : Outline content '%.*s' of outline '%.*s' already exists when added
ERROR 5273 (HY000) : Max concurrent in outline '%.*s' already exists when added
ERROR 5278 (HY000) : This partition value with incorrect charset type
ERROR 5291 (HY000) : The CTXCAT column must be contiguous in the index column list
ERROR 5296 (42000) : there has no readable replica
ERROR 5297 (HY000) : unexpected time zone info transition
ERROR 5298 (HY000) : synonym '%.*s' already exists
ERROR 5299 (HY000) : synonym \'%.*s.%.*s\' doesn\'t exist
ERROR 5300 (HY000) : missing ORDER BY expression in the window specification
ERROR 5301 (HY000) : The argument of the window function should be a constant for a partition
ERROR 5307 (HY000) : Not enough thread resource to execute the query. Require setting parallel_servers_target to a value no less than %ld for this query
ERROR 5309 (HY000) : Ignore sql in restore process
ERROR 5311 (HY000) : Invalid column id for %.*s
ERROR 5312 (HY000) : Duplicated ddl id '%.*s'
ERROR 5319 (HY000) : Child column \'%.*s\' data length cannot be less than parent column \'%.*s\' data length
ERROR 5320 (HY000) : \'%.*s\': used in a foreign key constraint
ERROR 5325 (HY000) : ORDER SIBLINGS BY clause not allowed here
ERROR 5326 (HY000) : when using SYS_CONNECT_BY_PATH function, cannot have separator as part of column value
ERROR 5327 (HY000) : Database can not be specified in public synonym
ERROR 5328 (HY000) : Looping chain of synonyms
ERROR 5329 (HY000) : Cannot create a synonym with same name as object
ERROR 5330 (HY000) : Synonym %s translation is no longer valid
ERROR 5331 (HY000) : name is already used by an existing object
ERROR 5337 (HY000) : rowid is wrong
ERROR 5338 (HY000) : Window Function not allowed here
ERROR 5339 (HY000) : Fail to parse list partition
ERROR 5341 (HY000) : timezone region ID is invalid
ERROR 5342 (HY000) : invalid hex number
ERROR 5343 (42000) : wrong number or types of arguments in call to '%.*s'
ERROR 5345 (HY000) : insufficient parallel query worker available
ERROR 5346 (HY000) : FOR UPDATE of this query expression is not allowed
ERROR 5347 (HY000) : argument should be a function of expressions in PARTITION BY
ERROR 5348 (HY000) : result of string concatenation is too long
ERROR 5350 (HY000) : updating partition key column would cause a partition change
ERROR 5351 (HY000) : invalid type given for an argument
ERROR 5352 (HY000) : specified field not found in datetime or interval
ERROR 5360 (HY000) : insufficient privileges
ERROR 5361 (HY000) : user %.*s lacks CREATE SESSION privilege; logon denied
ERROR 5363 (HY000) : system privileges not granted to '%.*s'
ERROR 5364 (HY000) : only SELECT and ALTER privileges are valid for sequences
ERROR 5365 (HY000) : EXECUTE privilege not allowed for tables
ERROR 5366 (HY000) : only EXECUTE and DEBUG privileges are valid for procedures
ERROR 5367 (HY000) : only EXECUTE, DEBUG, and UNDER privileges are valid for types
ERROR 5368 (HY000) : ADMIN option not granted for role '%.*s'
ERROR 5369 (HY000) : user or role '%.*s' does not exist
ERROR 5370 (HY000) : missing ON keyword
ERROR 5371 (HY000) : grant option does not exist for '%.*s.%.*s'
ERROR 5372 (HY000) : ALTER, INDEX and EXECUTE not allowed for views
ERROR 5373 (HY000) : circular role grant detected
ERROR 5374 (HY000) : invalid privilege on directories
ERROR 5375 (HY000) : directory access denied
ERROR 5376 (HY000) : missing or invalid role name
ERROR 5377 (HY000) : role '%.*s' not granted or does not exist
ERROR 5378 (HY000) : DEFAULT ROLE '%.*s' not granted to user
ERROR 5379 (HY000) : ROLE '%.*s' not granted to '%.*s'
ERROR 5380 (HY000) : cannot GRANT to a role WITH GRANT OPTION
ERROR 5381 (HY000) : duplicate username in list
ERROR 5382 (HY000) : cannot grant %.*s to a role
ERROR 5383 (HY000) : CASCADE CONSTRAINTS must be specified to perform this revoke
ERROR 5384 (HY000) : you may not GRANT/REVOKE privileges to/from yourself
ERROR 5386 (HY000) : Unable to read data -* Table definition has changed
ERROR 5401 (HY000) : resultant data type of virtual column is not supported
ERROR 5403 (HY000) : ddl schema version not match
ERROR 5409 (HY000) : Duplicate object name exists, schema refreshing may be hung
ERROR 5410 (HY000) : Refresh schema failed continuously, ddl may be hung
ERROR 5434 (HY000) : retry sql due to spm
ERROR 5435 (HY000) : outline not reproducible
ERROR 5436 (42000) : TIMESTAMP_TO_SCN expected timestamp argument
ERROR 5437 (42000) : SCN_TO_TIMESTAMP expected a integer number as nsec argument
ERROR 5500 (HY000) : Legitimacy check failed for generated columns
ERROR 5540 (HY000) : System variable '%.*s' is different from the old value solidified for '%.*s'(old value:%.*s)
ERROR 5558 (42000) : %s \'%.*s.%.*s\' already exists
ERROR 5559 (42000) : %s \'%.*s.%.*s\' does not exist
ERROR 5561 (HY000) : Invalid use of window function
ERROR 5562 (HY000) : Duplicate constraint name '%.*s'
ERROR 5563 (HY000) : Constraint not found
ERROR 5564 (HY000) : Duplicate alter index operations on column \'%.*s\'
ERROR 5572 (HY000) : a partition may be split into exactly two new partitions
ERROR 5573 (HY000) : this physical attribute may not be specified for a table partition
ERROR 5574 (HY000) : missing VALUES keyword
ERROR 5575 (HY000) : missing AT or VALUES keyword
ERROR 5578 (HY000) : Plan cache lock conflict
ERROR 5597 (HY000) : last resulting partition cannot contain bounds
ERROR 5598 (HY000) : cannot add partition when DEFAULT partition exists
ERROR 5599 (HY000) : cannot split partition into one partition, use rename instead
ERROR 5600 (HY000) : can not create user %s in sys tenant, name %.*s
ERROR 5601 (HY000) : Percentage should between 1 and 99
ERROR 5603 (0A000) : Attempt to create, alter or drop an index on temporary table already in use
ERROR 5604 (HY000) : invalid NLS parameter string used in SQL function
ERROR 5605 (HY000) : datetime/interval precision is out of range
ERROR 5606 (42000) : Invalid number format model
ERROR 5607 (HY000) : SQL command not properly ended
ERROR 5608 (42000) : invalid number format model
ERROR 5613 (HY000) : too many values
ERROR 5614 (HY000) : not enough values
ERROR 5615 (HY000) : single-row subquery returns more than one row
ERROR 5616 (HY000) : UPDATE ... SET expression must be a subquery
ERROR 5617 (HY000) : inappropriate INTO
ERROR 5619 (HY000) : Column part of using clause can not have qualifier
ERROR 5623 (HY000) : outer join operator (+) not allowed in operand of OR or IN
ERROR 5624 (HY000) : a column may not be outer-joined to a subquery
ERROR 5625 (HY000) : old style outer join (+) cannot be used with ANSI joins
ERROR 5626 (HY000) : outer join operator (+) is not allowed here
ERROR 5627 (HY000) : Schema try again
ERROR 5628 (HY000) : zero-length columns are not allowed
ERROR 5629 (HY000) : year conflicts with Julian date
ERROR 5630 (HY000) : day of year conflicts with Julian date
ERROR 5631 (HY000) : month conflicts with Julian date
ERROR 5632 (HY000) : day of month conflicts with Julian date
ERROR 5633 (HY000) : day of week conflicts with Julian date
ERROR 5634 (HY000) : hour conflicts with seconds in day
ERROR 5635 (HY000) : minutes of hour conflicts with seconds in day
ERROR 5636 (HY000) : seconds of minute conflicts with seconds in day
ERROR 5637 (HY000) : date not valid for month specified
ERROR 5638 (HY000) : input value not long enough for date format
ERROR 5639 (HY000) : (full) year must be between -4713 and +9999, and not be 0
ERROR 5640 (HY000) : quarter must be between 1 and 4
ERROR 5641 (HY000) : not a valid month
ERROR 5642 (HY000) : not a valid day of the week
ERROR 5643 (HY000) : day of year must be between 1 and 365 (366 for leap year)
ERROR 5644 (HY000) : hour must be between 1 and 12
ERROR 5645 (HY000) : hour must be between 0 and 23
ERROR 5646 (HY000) : minutes must be between 0 and 59
ERROR 5647 (HY000) : seconds must be between 0 and 59
ERROR 5648 (HY000) : seconds in day must be between 0 and 86399
ERROR 5649 (HY000) : julian date must be between 1 and 5373484
ERROR 5650 (HY000) : AM/A.M. or PM/P.M. required
ERROR 5651 (HY000) : BC/B.C. or AD/A.D. required
ERROR 5652 (HY000) : format code appears twice
ERROR 5653 (HY000) : day of week may only be specified once
ERROR 5654 (HY000) : signed year precludes use of BC/AD
ERROR 5655 (HY000) : Julian date precludes use of day of year
ERROR 5656 (HY000) : year may only be specified once
ERROR 5657 (HY000) : hour may only be specified once
ERROR 5658 (HY000) : AM/PM conflicts with use of A.M./P.M
ERROR 5659 (HY000) : BC/AD conflicts with use of B.C./A.D
ERROR 5660 (HY000) : month may only be specified once
ERROR 5661 (HY000) : day of week may only be specified once
ERROR 5662 (HY000) : format code cannot appear in date input format
ERROR 5663 (HY000) : a non-numeric character was found where a numeric was expected
ERROR 5664 (HY000) : 'HH24' precludes use of meridian indicator
ERROR 5665 (HY000) : missing or illegal character following the escape character
ERROR 5666 (HY000) : escape character must be character string of length 1
ERROR 5667 (HY000) : day of month must be between 1 and last day of month
ERROR 5668 (HY000) : not a SELECTed expression
ERROR 5670 (HY000) : (full) year must be between -4713 and +9999, and not be 0
ERROR 5671 (HY000) : such unique or primary key already exists in the table
ERROR 5672 (HY000) : such column list already indexed
ERROR 5674 (HY000) : argument '%ld' is out of range
ERROR 5675 (HY000) : ORDER BY item must be the number of a SELECT-list expression
ERROR 5676 (HY000) : the interval is invalid
ERROR 5677 (HY000) : PL/SQL: numeric or value error: %.*s
ERROR 5678 (HY000) : name already used by an existing constraint
ERROR 5679 (HY000) : table must have at least one column that is not invisible
ERROR 5681 (HY000) : Column visibility modifications cannot be combined with any other modified column DDL option
ERROR 5682 (HY000) : The visibility of a column from a table owned by a SYS user cannot be changed
ERROR 5683 (HY000) : too many arguments for function
ERROR 5684 (HY000) : PX sql need retry
ERROR 5685 (HY000) : Tenant '(string)' has been dropped
ERROR 5686 (HY000) : invalid extract field for extract source
ERROR 5687 (42000) : %s \'%.*s.%.*s\' compile error
ERROR 5690 (HY000) : subquery not allowed here
ERROR 5691 (HY000) : date or system variable wrongly specified in CHECK constraint
ERROR 5692 (HY000) : Cannot drop constraint - nonexistent constraint
ERROR 5693 (HY000) : check constraint violated
ERROR 5694 (HY000) : group function is not allowed here
ERROR 5695 (HY000) : policy string not found
ERROR 5696 (HY000) : invalid label string
ERROR 5697 (HY000) : undefined compartment string for policy string
ERROR 5698 (HY000) : undefined level string for policy string
ERROR 5699 (HY000) : undefined group string for policy string
ERROR 5700 (HY000) : LBAC error: %s
ERROR 5701 (HY000) : policy role already exists for policy string
ERROR 5702 (HY000) : NULL or invalid user label: %s
ERROR 5703 (HY000) : Add index failed
ERROR 5704 (HY000) : profile %.*s does not exist
ERROR 5705 (HY000) : invalid resource limit %s
ERROR 5706 (HY000) : profile %.*s already exists
ERROR 5707 (HY000) : profile %.*s has users assigned, cannot drop without CASCADE
ERROR 5708 (HY000) : the leading precision of the interval is too small
ERROR 5709 (HY000) : time zone hour must be between -12 and 14
ERROR 5710 (HY000) : time zone minute must be between -59 and 59
ERROR 5711 (HY000) : not a valid time zone
ERROR 5712 (HY000) : date format is too long for internal buffer
ERROR 5713 (HY000) : cannot validate (%.*s.%.*s) - check constraint violated
ERROR 5714 (HY000) : data manipulation operation not legal on this view
ERROR 5715 (HY000) : virtual column not allowed here
ERROR 5716 (HY000) : cannot modify more than one base table through a join view
ERROR 5721 (HY000) : cannot delete from view without exactly one key-preserved table
ERROR 5722 (HY000) : cannot modify a column which maps to a non key-preserved table
ERROR 5723 (HY000) : cannot perform a DML operation on a read-only view
ERROR 5724 (HY000) : invalid INITRANS option value
ERROR 5725 (HY000) : invalid MAXTRANS option value
ERROR 5726 (HY000) : invalid value for PCTFREE or PCTUSED
ERROR 5727 (HY000) : SQL request should be rerouted
ERROR 5728 (HY000) : illegal argument for function
ERROR 5729 (HY000) : this operator cannot be used with lists
ERROR 5730 (HY000) : SAMPLE percentage must be in the range [0.000001,100)
ERROR 5731 (HY000) : specifying owner's name of the table is not allowed
ERROR 5732 (HY000) : stmt trigger with when clause
ERROR 5732 (HY000) : not enough arguments for function
ERROR 5733 (HY000) : trigger '%.*s' does not exist
ERROR 5734 (HY000) : trigger '%.*s' already exist
ERROR 5735 (HY000) : trigger '%.*s' already exists on another table, cannot replace it
ERROR 5736 (HY000) : error signaled in parallel query server
ERROR 5763 (HY000) : Specified pseudo column or operator not allowed here
ERROR 5764 (HY000) : CONNECT BY loop in user data
ERROR 5765 (HY000) : cannot have join with CONNECT BY
ERROR 5766 (HY000) : CONNECT BY clause required in this query block
ERROR 5768 (HY000) : SYS_CONNECT_BY_PATH function is not allowed here
ERROR 5769 (HY000) : illegal parameter in SYS_CONNECT_BY_PATH function
ERROR 5770 (HY000) : A column value contained the string that the SYS_CONNECT_BY_PATH function was to use to separate column values
ERROR 5771 (HY000) : CONNECT BY ROOT operator is not supported in the START WITH or in the CONNECT BY condition
ERROR 5772 (HY000) : ORDER SIBLINGS BY clause not allowed here
ERROR 5773 (HY000) : NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudo column
ERROR 5774 (HY000) : not enough arguments for function
ERROR 5777 (HY000) : Prepare statement checksum error
ERROR 5778 (HY000) : cannot enable constraint (%.*s) - no such constraint
ERROR 5779 (HY000) : cannot disable constraint (%.*s) - no such constraint
ERROR 5780 (HY000) : PX DOP downgrade from %ld to %ld
ERROR 5785 (HY000) : cannot validate (%.*s.%.*s) - parent keys not found
ERROR 5786 (HY000) : Column check constraint cannot reference other columns
ERROR 5787 (HY000) : batched multi statement execution needs rollback
ERROR 5788 (HY000) : cannot select FOR UPDATE from view with ISTINCT, GROUP BY, etc
ERROR 5789 (HY000) : policy with check option violation
ERROR 5790 (HY000) : policy already applied to table
ERROR 5791 (HY000) : table '%.*s'.'%.*s' is mutating, trigger/function may not see it
ERROR 5792 (HY000) : column is referenced in a multi-column constraint
ERROR 5793 (HY000) : cannot drop parent key column
ERROR 5794 (HY000) : auto increment service busy
ERROR 5795 (HY000) : No insert/update/delete on table with constraint (%.*s.%.*s) disabled and validated
ERROR 5796 (HY000) : active autonomous transaction detected and rolled back
ERROR 5797 (HY000) : ORDER BY not allowed here
ERROR 5798 (HY000) : DISTINCT not allowed here
ERROR 5799 (HY000) : assign user variable with := only allowed in select filed list and as root expression
ERROR 5800 (HY000) : cannot modify constraint (%.*s) - no such constraint
ERROR 5801 (HY000) : implementation restriction: exception handler in nested transaction is illegal
ERROR 5802 (HY000) : invalid ROWID
ERROR 5803 (HY000) : Invalid column in the INSERT VALUES Clause:'%.*s'.'%.*s'
ERROR 5804 (HY000) : incorrect use of the ['%.*s'] operator
ERROR 5805 (HY000) : non-constant expression is not allowed for pivot|unpivot values
ERROR 5806 (HY000) : expect aggregate function inside pivot operation
ERROR 5807 (HY000) : expression must have same datatype as corresponding expression
ERROR 5808 (HY000) : character set mismatch
ERROR 5809 (HY000) : regular expression failed to match
ERROR 5810 (HY000) : invalid regular expression (reg version 0.8)
ERROR 5811 (HY000) : invalid escape \\ sequence in regular expression
ERROR 5812 (HY000) : unmatched bracket in regular expression
ERROR 5813 (HY000) : unmatched parentheses in regular expression
ERROR 5814 (HY000) : invalid back reference in regular expression
ERROR 5815 (HY000) : invalid range in regular expression
ERROR 5816 (HY000) : invalid character class in regular expression
ERROR 5817 (HY000) : invalid collation class in regular expression
ERROR 5818 (HY000) : braces {} not balanced in in regular expression
ERROR 5819 (HY000) : invalid repetition count(s) in regular expression
ERROR 5820 (HY000) : The regular expression was too complex and current library can't be parsed
ERROR 5821 (HY000) : regular expression internal error
ERROR 5822 (HY000) : invalid argument in regular expression
ERROR 5823 (HY000) : character widths of regex and string differ in regular expression
ERROR 5824 (HY000) : invalid embedded option in regular expression
ERROR 5825 (HY000) : nfa has too many states in regular expression, may be the regular expression too long
ERROR 5827 (HY000) : the definition of relative objects have been modified, please check and retry
ERROR 5828 (HY000) : Subscript beyond count
ERROR 5829 (HY000) : PARTITION () clause on non partitioned table
ERROR 5830 (HY000) : Unknown subpartition
ERROR 5831 (HY000) : Invalid SQL ROW LIMITING expression was specified
ERROR 5833 (HY000) : not implemented in SQL static typing engine
ERROR 5834 (HY000) : name is already used by an existing object
ERROR 5835 (HY000) : connection description for remote database not found
ERROR 5836 (HY000) : database link not found
ERROR 5837 (HY000) : Reference to uninitialized composite
ERROR 5838 (HY000) : Reference to uninitialized collection
ERROR 5839 (HY000) : no more rows needed
ERROR 5840 (HY000) : PL/SQL: program error
ERROR 5841 (HY000) : PL/SQL: Return types of Result Set variables or query do not match
ERROR 5842 (HY000) : PL/SQL: storage error
ERROR 5843 (HY000) : Subscript outside of limit
ERROR 5844 (HY000) : invalid cursor
ERROR 5845 (HY000) : invalid username/password; logon denied
ERROR 5846 (HY000) : not logged on
ERROR 5847 (HY000) : method dispatch on NULL SELF argument is disallowed
ERROR 5848 (HY000) : timeout occurred while waiting for a resource
ERROR 5849 (HY000) : column to be modified to NOT NULL is already NOT NULL
ERROR 5850 (HY000) : column to be modified to NULL cannot be modified to NULL
ERROR 5851 (HY000) : cannot enable (%.*s.%.*s) - null values found
ERROR 5852 (HY000) : Argument should be a constant
ERROR 5853 (HY000) : not a single-group group function
ERROR 5854 (HY000) : illegal zero-length identifier
ERROR 5855 (HY000) : parameter cannot be modified because specified value is invalid
ERROR 5856 (HY000) : DBMS_SQL access denied
ERROR 5857 (HY000) : not all variables bound
ERROR 5859 (HY000) : column is referenced in a multi-column constraint
ERROR 5860 (HY000) : cannot modify column datatype with current constraint(s)
ERROR 5861 (HY000) : The percentile value should be a number between 0 and 1
ERROR 5862 (HY000) : The argument should be of numeric or date/datetime type
ERROR 5863 (HY000) : ALTER TABLE|INDEX RENAME may not be combined with other operations
ERROR 5864 (HY000) : only simple column names allowed here
ERROR 5866 (HY000) : cannot specify <(sub)partition-description> clause in CREATE TABLE or CREATE INDEX)
ERROR 5867 (HY000) : Duplicate partition name %.*s
ERROR 5868 (HY000) : Incorrect usage of UPDATE and ORDER BY
ERROR 5869 (HY000) : Incorrect usage of UPDATE and LIMIT
ERROR 5870 (HY000) : rowid type mismatch, expect %.*s, got %.*s
ERROR 5871 (HY000) : rowid num mismatch, expect %ld, actual %ld
ERROR 5872 (HY000) : must name %.*s with a column alias
ERROR 5873 (HY000) : the numeric value does not match the length of the format item
ERROR 5874 (HY000) : invalid datatype
ERROR 5875 (HY000) : table is not partitioned by composite partition method
ERROR 5876 (HY000) : VALUES IN (<value list>) cannot be used for Range subpartitioned tables
ERROR 5877 (HY000) : VALUES IN (<value list>) clause expected
ERROR 5879 (HY000) : Expecting VALUES LESS THAN or AT clause
ERROR 5880 (HY000) : procedure, function, package, or package body does not exist
ERROR 5882 (HY000) : invalid time limit specified
ERROR 5883 (HY000) : ## ERROR(s) in array DML
ERROR 5884 (42000) : %s \'%.*s.%.*s\' compile error
ERROR 5887 (HY000) : missing or invalid password(s)
ERROR 5889 (HY000) : no matching unique or primary key for this column-list
ERROR 5890 (HY000) : duplicate referential constraint specifications
ERROR 5891 (HY000) : such a referential constraint already exists in the table
ERROR 5893 (HY000) : specified data type is not supported for a virtual column
ERROR 5894 (HY000) : referenced table does not have a primary key
ERROR 5895 (HY000) : data type or length of a table partitioning column may not be changed
ERROR 5896 (HY000) : data type or length of a table partitioning column may not be changed
ERROR 5897 (HY000) : cannot decrease column length because some value is too big
ERROR 5898 (HY000) : Datetime/Interval internal error
ERROR 5899 (HY000) : partition extended table name cannot refer to a remote object
ERROR 5901 (HY000) : a view is not appropriate here
ERROR 5902 (HY000) : cannot select ROWID from,or sample, a join view without a key-preserved table
ERROR 5903 (HY000) : cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc
ERROR 5904 (HY000) : table must have at least 1 column that is not virtual
ERROR 5905 (HY000) : only pure functions can be indexed
ERROR 5906 (HY000) : only pure functions can be specified in a virtual column expression
ERROR 5907 (HY000) : UPDATE operation disallowed on virtual columns
ERROR 5908 (HY000) : Invalid column expression was specified
ERROR 5909 (HY000) : table can have only one identity column
ERROR 5910 (HY000) : invalid NOT NULL constraint specified on an identity column
ERROR 5911 (HY000) : cannot modify NOT NULL constraint on an identity column
ERROR 5912 (HY000) : cannot drop NOT NULL constraint on an identity column
ERROR 5913 (HY000) : column to be modified is not an identity column
ERROR 5914 (HY000) : identity column cannot have a default value
ERROR 5915 (HY000) : identity column must be a numeric type
ERROR 5916 (HY000) : prebuilt table managed column cannot be an identity column
ERROR 5917 (HY000) : cannot alter a system-generated sequence
ERROR 5918 (HY000) : cannot drop a system-generated sequence
ERROR 5919 (HY000) : cannot insert into a generated always identity column
ERROR 5920 (HY000) : cannot update a generated always identity column
ERROR 5921 (HY000) : identity column sequence mismatch in ALTER TABLE EXCHANGE PARTITION
ERROR 5922 (HY000) : cannot rename a system-generated sequence
ERROR 5923 (HY000) : UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column
ERROR 5924 (HY000) : not executed, type body '%.*s' does not exist
ERROR 5925 (HY000) : The argument [%s] of WIDTH_BUCKET function is NULL or invalid
ERROR 5926 (HY000) : Not enough memory for CONNECT BY operation
ERROR 5927 (HY000) : illegal parameter in SYS_CONNECT_BY_PATH function
ERROR 5928 (HY000) : host %.*s unknown
ERROR 5929 (HY000) : Window name '%.*s' is not defined
ERROR 5930 (HY000) : maximum open %s exceeded
ERROR 5931 (HY000) : argument is null, invalid, or out of range
ERROR 5932 (HY000) : unexpected name string
ERROR 5933 (HY000) : PL/SQL: could not find program unit being called: '%.*s'
ERROR 5934 (HY000) : fetch out of sequence
ERROR 5959 (HY000) : invalid SIZE specified
ERROR 5975 (HY000) : \ndblink remote error code: %d,\nremote error msg: %.*s"
ERROR 5976 (HY000) : can not find the expected version of OCI LIB: %.*s