ORA-00000 to ORA-00999

ORA-00000: PX DOP downgrade from %ld to %ld

• Error code in OceanBase Database: 5780

• SQLSTATE: HY000

• Cause: The error code indicates a normal exit.

ORA-00000: parallel_max_serversdowngrade due to insufficient cpu resource from %ld to %ld

• Error code in OceanBase Database: 5781

• SQLSTATE: HY000

• Cause: The error code indicates a normal exit.

Note

The error code is no longer used in the current version.

ORA-00001: unique constraint \'%s\' for key \'%.*s\' violated

• Error code in OceanBase Database: 5024

• SQLSTATE: 23000

• Cause: An UPDATE or INSERT statement is attempting to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert this key.

ORA-00001: unique constraint (%.*s) violated

• Error code in OceanBase Database: 5595

• SQLSTATE: 23000

• Cause: An UPDATE or INSERT statement is attempting to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert this key.

ORA-00001: unique constraint violated, column '%.*s' with value '%.*s' in %s

• Error code in OceanBase Database: 5334

• SQLSTATE: HY000

• Cause: An UPDATE or INSERT statement is attempting to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert this key.

ORA-00001: unique constraint (%.*s) violated

• Error code in OceanBase Database: 5562

• SQLSTATE: HY000

• Cause: An UPDATE or INSERT statement is attempting to insert a duplicate key.

• Solution: Remove the UNIQUE constraint or do not insert this key.

ORA-00051: timeout occurred while waiting for a resource

• Error code in OceanBase Database: 5848

• SQLSTATE: HY000

• Cause: The error is usually caused by dead instances.

• Solution: Check whether dead or unrecovered instances exist. If yes, recover the instances.

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

• Error code in OceanBase Database: 6006

• SQLSTATE: HY000

• Cause: The resource is busy.

• Solution: Try again or increase the timeout period.

ORA-00060: deadlock detected while waiting for resource

• Error code in OceanBase Database: 4101

• SQLSTATE: HY000

• Cause: A deadlock is detected while waiting for resources.

• Solution: View the Trace file and the involved transactions and resources. Try again if necessary.

ORA-00600: Invalid JSON text

• Error code in OceanBase Database: 5411

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: Invalid JSON text in argument

• Error code in OceanBase Database: 5412

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: The JSON binary value contains invalid data

• Error code in OceanBase Database: 5413

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: Invalid JSON path expression

• Error code in OceanBase Database: 5414

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: Cannot create a JSON value from a string

• Error code in OceanBase Database: 5415

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: Invalid JSON character data provided to function

• Error code in OceanBase Database: 5416

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: Invalid data type for JSON data in argument %u to function %s; a JSON string or JSON type is required

• Error code in OceanBase Database: 5417

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: Cannot CAST value to JSON

• Error code in OceanBase Database: 5418

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: A path expression must be encoded in the utf8 character set

• Error code in OceanBase Database: 5419

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: In this situation, path expressions may not contain the * and ** tokens

• Error code in OceanBase Database: 5420

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: The JSON value is too big to be stored in a JSON column

• Error code in OceanBase Database: 5421

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: The JSON object contains a key name that is too long

• Error code in OceanBase Database: 5422

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: JSON column '%.*s' cannot be used in key specification

• Error code in OceanBase Database: 5423

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: The path expression is not allowed in this context

• Error code in OceanBase Database: 5424

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: The oneOrAll argument may take these values: \'one\' or \'all\'

• Error code in OceanBase Database: 5425

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: Out of range JSON value for CAST

• Error code in OceanBase Database: 5426

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: Invalid JSON value for CAST

• Error code in OceanBase Database: 5427

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: The JSON document exceeds the maximum depth

• Error code in OceanBase Database: 5428

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: JSON documents may not contain NULL member names

• Error code in OceanBase Database: 5429

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: Invalid default value for \'%.*s\'

• Error code in OceanBase Database: 5430

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: A path expression is not a path to a cell in an array

• Error code in OceanBase Database: 5431

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: No value was found by '%.192s' on the specified path

• Error code in OceanBase Database: 5432

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: More than one value was found by '%.192s' on the specified path

• Error code in OceanBase Database: 5433

• SQLSTATE: 22032

• Cause: An internal error occurred.

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

ORA-00600: auto increment service busy

• Error code in OceanBase Database: 5794

• SQLSTATE: HY000

• Cause: An internal error occurred.

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

ORA-00600: rowid type mismatch, expect %.*s, got %.*s"

• Error code in OceanBase Database: 5870

• SQLSTATE: HY000

• Cause: An internal error occurred.

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

ORA-00600: rowid num mismatch, expect %ld, actual %ld

• Error code in OceanBase Database: 5871

• SQLSTATE: HY000

• Cause: An internal error occurred.

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

ORA-00603: Prepare statement checksum error

• Error code in OceanBase Database: 5777

• SQLSTATE: HY000

• Cause: The server session is unrecoverable.

• Solution: Log on to OceanBase Database again so that the system automatically creates a server session. For more information, see the session trace file.

ORA-00900: invalid SQL statement

• Error code in OceanBase Database: 5001

• SQLSTATE: 42000

• Cause: An error exists in the SQL statement.

• Solution: For the correct SQL statements, see SQL Reference (Oracle Mode) of the corresponding OceanBase Database version.

ORA-00900: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use

• Error code in OceanBase Database: 5006

• SQLSTATE: 42000

• Cause: An error exists in the SQL statement.

• Solution: For the correct SQL statements, see SQL Reference (Oracle Mode) of the corresponding OceanBase Database version.

ORA-00902: invalid datatype

• Error code in OceanBase Database: 5874

• SQLSTATE: HY000

• Cause: The data type is invalid.

ORA-00903: invalid table name

• Error code in OceanBase Database: 5163

• SQLSTATE: 42000

• Cause: The table name is invalid.

ORA-00904: invalid identifier '%.*s'

• Error code in OceanBase Database: 5164

• SQLSTATE: 42000

• Cause: The string contains an invalid identifier.

ORA-00904: invalid identifier '%.*s'in '%.*s'

• Error code in OceanBase Database: 5217

• SQLSTATE: 42S22

• Cause: The string contains an invalid identifier.

ORA-00905: missing keyword

• Error code in OceanBase Database: 5096

• SQLSTATE: HY000

• Cause: A keyword is missing from the SQL statement.

ORA-00909: invalid number of arguments in the call to native function '%.*s'

• Error code in OceanBase Database: 5054

• SQLSTATE: 42000

• Cause: The number of arguments is invalid.

ORA-00910: specified length too long for column '%s' (max = %d byte)

• Error code in OceanBase Database: 5198

• SQLSTATE: 42000

• Cause: The specified string length is greater than the length supported by the data type. Specifically, the specified string length exceeds 2000 for the CHAR and RAW data types and 4000 for other data types.

• Solution: Reduce the string length, or switch to another data type that supports a longer string length, such as VARCHAR2, LONG CHAR, or LONG RAW.

ORA-00913: too many values

• Error code in OceanBase Database: 5613

• SQLSTATE: HY000

• Cause: Too many values exist.

ORA-00917: missing comma

• Error code in OceanBase Database: 7403
• SQLSTATE: 42000
• Cause: A required comma is omitted from a list of columns or values in an INSERT statement or a list such as ((C,D),(E,F), ...).
• Solution: Correct the syntax.

ORA-00918: column '%.*s' in %.*sambiguously defined

• Error code in OceanBase Database: 5207

• SQLSTATE: 23000

• Cause: The column definition is ambiguous.

ORA-00926: missing VALUES keyword

• Error code in OceanBase Database: 5574

• SQLSTATE: HY000

• Cause: The VALUES keyword is missing.

ORA-00931: missing identifier

• Error code in OceanBase Database: 5963

• SQLSTATE: HY000

• Cause: The identifier is missing.

ORA-00932: inconsistent datatypes: expected %s got %s

• Error code in OceanBase Database: 7402
• SQLSTATE: 22000
• Cause:
  • You attempted to operate on incompatible data types.
  • You attempted to use an undocumented view.
• Solution:
  • Use correct data types.
  • Access objects that are intended for normal use.

ORA-00932: inconsistent datatypes: left_type=%s right_type=%s

• Error code in OceanBase Database: 5083

• SQLSTATE: 22000

• Cause: The data types are inconsistent.

ORA-00933: SQL command not properly ended

• Error code in OceanBase Database: 5607

• SQLSTATE: HY000

• Cause: The SQL command is not properly ended.

ORA-00934: group function is not allowed here

• Error code in OceanBase Database: 5694

• SQLSTATE: HY000

• Cause: The group function is not supported.

ORA-00937: not a single-group group function

• Error code in OceanBase Database: 5853

• SQLSTATE: HY000

• Cause: A non-single-group group function is used.

ORA-00938: not enough arguments for function

• Error code in OceanBase Database: 5774

• SQLSTATE: HY000

• Cause: Arguments of the function are insufficient.

ORA-00939: too many arguments for function

• Error code in OceanBase Database: 5683

• SQLSTATE: HY000

• Cause: The function contains excessive arguments.

ORA-00942: table or view \'%s.%s\'does not exist

• Error code in OceanBase Database: 5019

• SQLSTATE: 42S02

• Cause: The table or view does not exist. In OceanBase Database V2.2.70 and later versions, role privileges are added. If the current role does not have the SELECT privilege on some tables or views, this error is returned.

• Solution: Check the spelling of the SQL statement. In particular, check the privileges of the current role in OceanBase Database V2.2.70 and later versions.

ORA-00942: table or view '%.*s' does not exist

• Error code in OceanBase Database: 5201

• SQLSTATE: 42S02

• Cause: The table or view does not exist. In OceanBase Database V2.2.70 and later versions, role privileges are added. If the current role does not have the SELECT privilege on some tables or views, this error is returned.

• Solution: Check the spelling of the SQL statement. In particular, check the privileges of the current role in OceanBase Database V2.2.70 and later versions.

ORA-00947: not enough values

• Error code in OceanBase Database: 5614

• SQLSTATE: HY000

• Cause: Values are not enough.

ORA-00955: name is already used by an existing object

• Error codes in OceanBase Database: 5331 and 5834

• SQLSTATE: HY000

• Cause: The name is already used by an existing object.

ORA-00957: duplicate column name

• Error code in OceanBase Database: 4228

• SQLSTATE: 42000

• Cause: The column name is duplicated with an existing one.

ORA-00959: tablespace '%.*s' does not exist

• Error code in OceanBase Database: 4354

• SQLSTATE: HY000

• Cause: The tablespace does not exist.

ORA-00969: missing ON keyword

• Error code in OceanBase Database: 5370

• SQLSTATE: HY000

• Cause: The ON keyword is missing.

ORA-00972: identifier \'%.*s\' is too long

• Error code in OceanBase Database: 5179

• SQLSTATE: 42000

• Cause: The specified identifier exceeds the length limit.

• Solution: Limit the length of the identifier to the range allowed.

ORA-00976: Specified pseudo column or operator not allowed here

• Error code in OceanBase Database: 5763

• SQLSTATE: HY000

• Cause: The LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, or CONNECT_BY_ISCYCLE keyword is not allowed at the current location.

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

ORA-00979: not a GROUP BY expression

• Error code in OceanBase Database: 5218

• SQLSTATE: 42000

• Cause: The expression is not a GROUP BY expression.

ORA-00980: synonym translation is no longer valid

• Error code in OceanBase Database: 5330

• SQLSTATE: HY000

• Cause: The synonym is not converted into a valid target object. The possible causes are as follows:

  • The target mode does not exist.

  • The target object does not exist.

  • The synonym specifies an incorrect database link.

  • The synonym specifies a target object for versioning but does not perform versioning.

• Solution: Modify the definition of the synonym so that the synonym points to a valid object.

ORA-00984: column not allowed here

• Error code in OceanBase Database: 5942

• SQLSTATE: HY000

• Cause: This column cannot be inserted here.

ORA-00988: missing or invalid password(s)

• Error code in OceanBase Database: 5887

• SQLSTATE: HY000

• Cause: The password is invalid.

ORA-00998: must name this expression with a column alias

• Error code in OceanBase Database: 5872

• SQLSTATE: HY000

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