ORA-01500 to ORA-01999

ORA-01543: tablespace '%.*s' already exists

• OceanBase error code: 4353

• SQLSTATE: HY000

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

• Solution: Change the name of the tablespace to be created.

ORA-01555: snapshot too old

• OceanBase error code: 4138

• SQLSTATE: HY000

• Cause: The rollback records required by the reader for consistency reads are overwritten by other compilers.

• Solution: Change the value of undo_retention to extend the range of rollback records.

ORA-01700: duplicate username in list

• OceanBase error code: 5381

• SQLSTATE: HY000

• Cause: The username is duplicate with an existing one.

ORA-01702: a view is not appropriate here

• OceanBase error code: 5901

• SQLSTATE: HY000

• Cause: The operation attempted to define EDITIONING_VIEW in a view.

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

ORA-01705: an outer join cannot be specified on a correlation column

• OceanBase error code: 5622

• SQLSTATE: HY000

• Cause: You cannot specify an outer join on a correlated column.

ORA-01711: duplicate privilege listed

• OceanBase error code: 4349

• SQLSTATE: HY000

• Cause: The statement lists duplicate privileges.

ORA-01718: BY ACCESS | SESSION clause not allowed for NOAUDIT

• OceanBase error code: 4362

• SQLSTATE: HY000

• Cause: NOAUDIT does not allow the BY ACCESS or BY SESSION clause.

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

ORA-01719: outer join operator (+) not allowed in operand of OR or IN

• OceanBase error code: 5623

• SQLSTATE: HY000

• Cause: The OR clause contains an outer join operator (+).

• Solution: If A and B are predicates, you can try the following method to obtain the effect of (A(+) or B):

  SELECT WHERE (A(+) AND NOT B)) UNION ALL (SELECT WHERE (B));
  

ORA-01720: grant option does not exist for '%.*s.%.*s'

• OceanBase error code: 5371

• SQLSTATE: HY000

• Cause: A grant is being performed on a view, or the view is being replaced, but the underlying object does not have the grant option.

• Solution: Obtain the grant options of all underlying objects in the view, or revoke the current grant on the view.

ORA-01722: invalid number: '%.*s'

• OceanBase error code: 4262

• SQLSTATE: 01000

• Cause: The specified number is invalid.

• Solution: Specify a valid number.

ORA-01722: invalid number

• OceanBase error code: 5085

• SQLSTATE: 22000

• Cause: The specified number is invalid.

• Solution: Specify a valid number.

ORA-01722: invalid number char '%c'

• OceanBase error code: 5114

• SQLSTATE: 42000

• Cause: The specified number is invalid.

• Solution: Specify a valid number.

ORA-01723: zero-length columns are not allowed

• OceanBase error code: 5628

• SQLSTATE: HY000

• Cause: Zero-length columns exist.

• Solution: Use qualified columns.

ORA-01724: floating point precision is out of range (1 to 126)

• OceanBase error code: 4356

• SQLSTATE: HY000

• Cause: The floating-point precision exceeds the range of 1 to 126.

• Solution: Use a correct floating-point precision.

ORA-01727: numeric precision specifier is out of range (1 to 38)

• OceanBase error code: 4357

• SQLSTATE: HY000

• Cause: The numeric precision exceeds the range of 1 to 38.

• Solution: Use a correct numeric precision.

ORA-01728: numeric scale specifier is out of range (-84 to 127)

• OceanBase error code: 4358

• SQLSTATE: HY000

• Cause: The numeric scale exceeds the range of -84 to 127.

• Solution: Use a correct scale.

ORA-01729: database link name expected

• OceanBase error code: 5097

• SQLSTATE: HY000

• Cause: No database link name exists behind the at sign (@).

ORA-01730: invalid number of column names specified

• OceanBase error code: 5242

• SQLSTATE: HY000

• Cause: The number of column names defined in the view is different from the number of output columns returned by the query that defines the view.

• Solution: Modify the view definition to ensure that the number of column names in the view is the same as the number of output columns returned by the query.

ORA-01731: circular view definition encountered

• OceanBase error code: 5239

• SQLSTATE: 42S02

• Cause: A circular view is defined.

ORA-01732: data manipulation operation not legal on this view

• OceanBase error code: 5714

• SQLSTATE: HY000

• Cause: The data manipulation operation on this view is invalid.

ORA-01733: virtual column not allowed here

• OceanBase error code: 5715

• SQLSTATE: HY000

• Cause: Virtual columns are present.

ORA-01741: illegal zero-length identifier

• OceanBase error code: 5854

• SQLSTATE: HY000

• Cause: The zero-length identifier is invalid.

ORA-01741: illegal zero-length identifier

• OceanBase error code: 5455
• SQLSTATE: 42000
• Cause: A pair of double quotation marks ("") cannot be used as the identifier. The identifier must be at least one character in length.
• Solution: Insert at least one character between the double quotation marks for the identifier. To use the blank identifier, enter a space between double quotation marks ("").

ORA-01747: invalid user.table.column, table.column, or column specification

• OceanBase error code: 5457
• SQLSTATE: 42000
• Cause: The user.table.column, table.column, or column specification is invalid.
• Solution: Correct and reissue the command.

ORA-01747: invalid user.table.column, table.column, or column specification

• OceanBase error code: 4763
• SQLSTATE: HY000
• Cause: The username, table name, or column name specified in the SQL statement is incorrect or invalid.
• Solution: Make sure that the username, table name, and column name specified in the SQL statement are free of spelling or syntax errors.

ORA-01743: only pure functions can be indexed

• OceanBase error code: 5905

• SQLSTATE: HY000

• Cause: The SYSDATE or user environment is used in the index function.

• Solution: PL functions must be pure functions such as RNDS, RNPS, WNDS, and WNPS.

ORA-01744: inappropriate INTO

• OceanBase error code: 5617

• SQLSTATE: HY000

• Cause: The INTO statement is inappropriate.

ORA-01748: only simple column names allowed here

• OceanBase error code: 5864

• SQLSTATE: HY000

• Cause: Only a simple column name is allowed.

ORA-01749: you may not GRANT/REVOKE privilege to/from yourself

• OceanBase error code: 5384

• SQLSTATE: HY000

• Cause: You are attempting to grant privileges to yourself or revoke your own privileges, which is not allowed.

ORA-01750: UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column

• OceanBase error code: 5923

• SQLSTATE: HY000

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

ORA-01752: cannot delete from view without exactly one key-preserved table

• OceanBase error code: 5721

• SQLSTATE: HY000

• Cause: The deleted table may have the following problems:

  • The table does not contain key-preserved tables.

  • The table contains multiple key-preserved tables.

  • The key-preserved table is an unmerged view.

• Solution: Redefine the view or delete the view from the base table.

ORA-01758: table must be empty to add mandatory (NOT NULL) column

• OceanBase error code: 5946

• SQLSTATE: HY000

• Cause: A mandatory (NOT NULL) column can be added only to an empty table.

ORA-01760: illegal argument for function

• OceanBase error code: 5728

• SQLSTATE: HY000

• Cause: The function contains invalid arguments.

ORA-01765: specifying owner's name of the table is not allowed

• OceanBase error code: 5731

• SQLSTATE: HY000

• Cause: You are attempting to rename an object by using username.tablename.

• Solution: Do not specify username.tablename when you query for a table name.

ORA-01767: UPDATE ... SET expression must be a subquery

• OceanBase error code: 5616

• SQLSTATE: HY000

• Cause: The UPDATE ... SET expression must be a subquery.

ORA-01776: cannot modify more than one base table through a join view

• OceanBase error code: 5716

• SQLSTATE: HY000

• Cause: A column that belongs to multiple base tables is inserted or updated.

• Solution: Split the statement into two or more independent statements.

ORA-01779: cannot modify a column which maps to a non key-preserved table

• OceanBase error code: 5722

• SQLSTATE: HY000

• Cause: You are attempting to insert or update columns of a join view that are mapped to a non-key-preserved table.

• Solution: Modify the base table.

ORA-01785: ORDER BY item must be the number of a SELECT-list expression

• OceanBase error code: 5675

• SQLSTATE: HY000

• Cause: The ORDER BY option must be a number of a SELECT-list expression.

ORA-01786: FOR UPDATE of this query expression is not allowed

• OceanBase error code: 5346

• SQLSTATE: HY000

• Cause: This query expression does not support FOR UPDATE.

ORA-01788: CONNECT BY clause required in this query block

• OceanBase error code: 5766

• SQLSTATE: HY000

• Cause: This query block requires the CONENCT BY clause.

ORA-01790: expression must have same datatype as corresponding expression

• OceanBase error code: 5807

• SQLSTATE: HY000

• Cause: The data type of the expression must be the same as that of the corresponding expression.

ORA-01791: not a SELECTed expression

• OceanBase error code: 5668

• SQLSTATE: HY000

• Cause: The expression is not a SELECT expression.

ORA-01796: this operator cannot be used with lists

• OceanBase error code: 5729

• SQLSTATE: HY000

• Cause: This operator cannot be used with lists.

ORA-01799: a column may not be outer-joined to a subquery

• OceanBase error code: 5624

• SQLSTATE: HY000

• Cause: A column cannot be joined to a subquery by an outer join operator (+).

• Solution: Delete the subquery.

ORA-01801: date format is too long for internal buffer

• OceanBase error code: 5712

• SQLSTATE: HY000

• Cause: The date format is too long for the internal buffer.

ORA-01804: failure to initialize timezone information

• OceanBase error code: 5123

• SQLSTATE: HY000

• Cause: Failed to read the time zone information file.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ORA-01810: format code appears twice

• OceanBase error code: 5652

• SQLSTATE: HY000

• Cause: The format code appears twice.

ORA-01811: Julian date precludes use of day of year

• OceanBase error code: 5655

• SQLSTATE: HY000

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

ORA-01812: year may only be specified once

• OceanBase error code: 5656

• SQLSTATE: HY000

• Cause: The year can be specified only once.

ORA-01813: hour may only be specified once

• OceanBase error code: 5657

• SQLSTATE: HY000

• Cause: The hour can be specified only once.

ORA-01814: AM/PM conflicts with use of A.M./P.M.

• OceanBase error code: 5658

• SQLSTATE: HY000

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

ORA-01815: BC/AD conflicts with use of B.C./A.D.

• OceanBase error code: 5659

• SQLSTATE: HY000

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

ORA-01816: month may only be specified once

• OceanBase error code: 5660

• SQLSTATE: HY000

• Cause: The month can be specified only once.

ORA-01817: day of week may only be specified once

• OceanBase error code: 5653

• SQLSTATE: HY000

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

ORA-01817: day of week may only be specified once

• OceanBase error code: 5661

• SQLSTATE: HY000

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

ORA-01818: 'HH24' precludes use of meridian indicator

• OceanBase error code: 5664

• SQLSTATE: HY000

• Cause: The HH24 format does not support AM or PM.

ORA-01819: signed year precludes use of BC/AD

• OceanBase error code: 5654

• SQLSTATE: HY000

Cause: The signed date cannot contain BC or AD.

ORA-01820: format code cannot appear in date input format

• OceanBase error code: 5662

• SQLSTATE: HY000

• Cause: The format code cannot be displayed in date input format.

ORA-01821: date format not recognized, %s=%d must between %d and %d

• OceanBase error code: 4158

• SQLSTATE: 22007

• Cause: The date format cannot be recognized.

• Solution: Put %s=%d between %d and %d.

ORA-01830: date format picture ends before converting entire input string

• OceanBase error code: 4190

• SQLSTATE: 22007

• Cause: The date format picture ends before the entire input string is converted.

ORA-01831: year conflicts with Julian date

• OceanBase error code: 5629

• SQLSTATE: HY000

• Cause: The year conflicts with the Julian day.

ORA-01832: day of year conflicts with Julian date

• OceanBase error code: 5630

• SQLSTATE: HY000

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

ORA-01833: month conflicts with Julian date

• OceanBase error code: 5631

• SQLSTATE: HY000

• Cause: The month conflicts with the Julian day.

ORA-01834: day of month conflicts with Julian date

• OceanBase error code: 5632

• SQLSTATE: HY000

• Cause: The day of the month (1 to 31) conflicts with the Julian day.

ORA-01835: day of week conflicts with Julian date

• OceanBase error code: 5633

• SQLSTATE: HY000

• Cause: The day of the week (1 to 7) conflicts with the Julian day.

ORA-01836: hour conflicts with seconds in day

• OceanBase error code: 5634

• SQLSTATE: HY000

• Cause: The hour conflicts with the second in the day.

ORA-01837: minutes of hour conflicts with seconds in day

• OceanBase error code: 5635

• SQLSTATE: HY000

• Cause: The minute of the hour conflicts with the second in the day.

ORA-01838: seconds of minute conflicts with seconds in day

• OceanBase error code: 5636

• SQLSTATE: HY000

• Cause: The second of the minute conflicts with the second in the day.

ORA-01839: date not valid for month specified

• OceanBase error code: 5637

• SQLSTATE: HY000

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

ORA-01840: input value not long enough for date format

• OceanBase error code: 5638

• SQLSTATE: HY000

• Cause: The input value is too short to be used in the date format.

ORA-01842: quarter must be between 1 and 4

• OceanBase error code: 5640

• SQLSTATE: HY000

• Cause: Quarter must range from 1 to 4.

ORA-01843: not a valid month

• OceanBase error code: 5641

• SQLSTATE: HY000

• Cause: The month is invalid.

ORA-01846: not a valid day of the week

• OceanBase error code: 5642

• SQLSTATE: HY000

• Cause: The day of the week is invalid.

ORA-01847: day of month must be between 1 and last day of month

• OceanBase error code: 5667

• SQLSTATE: HY000

• Cause: The day of the month is not within the range of the first to the last day of the month.

ORA-01848: day of year must be between 1 and 365 (366 for leap year)

• OceanBase error code: 5643

• SQLSTATE: HY000

• Cause: The day of the year must be within the range of 1 to 365 or 1 to 366 for a leap year.

ORA-01849: hour must be between 1 and 12

• OceanBase error code: 5644

• SQLSTATE: HY000

• Cause: The hour is not within the range of 1 to 12 and is invalid.

ORA-01850: hour must be between 0 and 23

• OceanBase error code: 5645

• SQLSTATE: HY000

• Cause: The hour is not within the range of 0 to 23 and is invalid.

ORA-01851: minutes must be between 0 and 59

• OceanBase error code: 5646

• SQLSTATE: HY000

• Cause: The minute is not within the range of 0 to 59 and is invalid.

ORA-01852: seconds must be between 0 and 59

• OceanBase error code: 5647

• SQLSTATE: HY000

• Cause: The second is not within the range of 0 to 59 and is invalid.

ORA-01853: seconds in day must be between 0 and 86399

• OceanBase error code: 5648

• SQLSTATE: HY000

• Cause: The seconds of the day must be within the range of 0 to 86399.

ORA-01854: julian date must be between 1 and 5373484

• OceanBase error code: 5649

• SQLSTATE: HY000

• Cause: The Julian day is invalid.

• Solution: Input a Julian date ranging from 1 to 5373484.

ORA-01855: AM/A.M. or PM/P.M. required

• OceanBase error code: 5650

• SQLSTATE: HY000

• Cause: The AM, A.M., PM, or P.M. datetime format is not specified.

ORA-01856: BC/B.C. or AD/A.D. required

• OceanBase error code: 5651

• SQLSTATE: HY000

• Cause: The BC, B.C., AD, or A.D. datetime format is not specified.

ORA-01857: not a valid time zone

• OceanBase error code: 5711

• SQLSTATE: HY000

• Cause: The time zone is invalid.

ORA-01858: a non-numeric character was found where a numeric was expected

• OceanBase error code: 5663

• SQLSTATE: HY000

• Cause: The input data is converted by using the date format model, but the input data is incorrect. Specifically, a non-numeric character is input to the numeric position of the date format model.

• Solution: Modify the input data or change the date format model to ensure that the element quantity and type are correct. Then, try this operation again.

ORA-01861: literal does not match format string: '%.*s' for column '%s'

• OceanBase error code: 4219

• SQLSTATE: 22007

• Cause: The input string does not match the format string.

• Solution: Correct the input string.

ORA-01862: the numeric value does not match the length of the format item

• OceanBase error code: 5873

• SQLSTATE: HY000

• Cause: When code in FX or FM format is specified for the input date, the number of digits must be exactly the same as that specified by the format code. For example, 9 does not match the format specifier DD, but 09 does.

• Solution: Correct the input date or disable the specifier for the FX or FM format in the format string.

ORA-01867: the interval is invalid

• OceanBase error code: 5676

• SQLSTATE: HY000

• Cause: The specified interval is invalid.

• Solution: Specify a valid interval.

ORA-01873: the leading precision of the interval is too small

• OceanBase error code: 5708

• SQLSTATE: HY000

• Cause: The specified interval cannot be stored due to a small leading precision of the interval.

• Solution: Increase the leading precision of the interval, or specify an interval with a smaller leading precision.

ORA-01874: time zone hour must be between -12 and 14

• OceanBase error code: 5709

• SQLSTATE: HY000

• Cause: The specified hour of the time zone is not within the valid range.

• Solution: Specify an hour value ranging from –15 to 15 for the time zone.

ORA-01875: time zone minute must be between -59 and 59

• OceanBase error code: 5710

• SQLSTATE: HY000

• Cause: The specified minute of the time zone is not within the valid range.

• Solution: Specify a minute value ranging from –59 to 59 for the time zone.

ORA-01878: specified field not found in datetime or interval

• OceanBase error code: 5352

• SQLSTATE: HY000

• Cause: The specified field cannot be found in the datetime or interval.

• Solution: Ensure that the specified field is in the datetime or interval.

ORA-01881: timezone region ID is invalid

• OceanBase error code: 5341

• SQLSTATE: HY000

• Cause: The region ID is invalid.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ORA-01882: timezone region not found

• OceanBase error code: 5192

• SQLSTATE: HY000

• Cause: The specified region name is not found.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ORA-01891: Datetime/Interval internal error

• OceanBase error code: 5898

• SQLSTATE: HY000

• Cause: An internal error occurred.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ORA-01930: auditing the object is not supported

• OceanBase error code: 4363

• SQLSTATE: HY000

• Cause: AUDIT or NOAUDIT is specified for an object that does not support auditing.

• Solution: Do not audit objects of this type.

ORA-01917: user or role '%.*s' does not exist

• OceanBase error code: 5369

• SQLSTATE: HY000

• Cause: No user or role with this name exists.

• Solution: Specify a new name.

ORA-01918: user '%.*s' does not exist

• OceanBase error code: 4042

• SQLSTATE: 42000

• Cause: This user does not exist in the system.

• Solution: Check whether the username is correct.

ORA-01919: role '%.*s' does not exist

• OceanBase error code: 4347

• SQLSTATE: HY000

• Cause: No role with this name exists.

• Solution: Check whether the role name is correct.

ORA-01920: user name conflicts with another user or role name

• OceanBase error code: 5050

• SQLSTATE: 42710

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

• Solution: Specify another username.

ORA-01921: role name '%.*s' conflicts with another user or role name

• OceanBase error code: 4348

• SQLSTATE: HY000

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

• Solution: Specify another role name.

ORA-01924: role '%.*s' not granted or does not exist

• OceanBase error code: 5377

• SQLSTATE: HY000

• Cause: This role is not granted to the user or does not exist.

• Solution: Create the role or grant the role to the user, and then try this operation again.

ORA-01926: cannot GRANT to a role WITH GRANT OPTION

• OceanBase error code: 5380

• SQLSTATE: HY000

• Cause: You are attempting to grant privileges to a role with the grant option.

• Solution: Remove the grant option and grant privileges to the role.

ORA-01927: cannot REVOKE privileges you did not grant

• OceanBase error code: 5362

• SQLSTATE: 42000

• Cause: You are attempting to revoke privileges not granted by you, which is not allowed.

• Solution: Do not revoke these privileges.

ORA-01930: auditing the object is not supported

• OceanBase error code: 4363

• SQLSTATE: HY000

• Cause: AUDIT or NOAUDIT is specified for an object that does not support auditing.

• Solution: Do not attempt to audit the object.

ORA-01931: cannot grant %.*s to a role

• OceanBase error code: 5382

• SQLSTATE: HY000

• Cause:

  Granting privileges to a role failed. You cannot grant REFERENCES, INDEX, and management privileges such as SYSDBA, SYSOPER, SYSASM, SYSBACKUP, and SYSKM to a role.

• Solution: Grant privileges to users instead of roles.

ORA-01932: ADMIN option not granted for role '%.*s'

• OceanBase error code: 5368

• SQLSTATE: HY000

• Cause: This operation requires the admin option on the role.

• Solution: Obtain the admin option and retry.

ORA-01934: circular role grant detected

• OceanBase error code: 5373

• SQLSTATE: HY000

• Cause: It is not allowed to grant a role circularly. In addition, it is not allowed to grant a role to itself.

• Solution: Do not perform such granting operations.

ORA-01937: missing or invalid role name

• OceanBase error code: 5376

• SQLSTATE: HY000

• Cause: The role name is invalid.

• Solution: Specify a valid role name.

ORA-01951: ROLE '%.*s' not granted to '%.*s'

• OceanBase error code: 5379

• SQLSTATE: HY000

• Cause: The role that you are attempting to revoke is not granted to the user.

• Solution: Do not attempt to revoke privileges that are not granted.

ORA-01952: system privileges not granted to '%.*s'

• OceanBase error code: 5363

• SQLSTATE: HY000

• Cause: The system privileges that you are attempting to revoke are not granted to the user.

• Solution: Make sure that the system privileges that you are attempting to revoke have been granted to the user.

ORA-01955: DEFAULT ROLE '%.*s' not granted to user

• OceanBase error code: 5378

• SQLSTATE: HY000

• Cause: The modified user is not granted this role.

• Solution: Grant the role to the user.

ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

• OceanBase error code: 5383

• SQLSTATE: HY000

• Cause: Some foreign key constraints are deleted when the revoke operation is performed. The CASCADE constraint must be specified for automatic execution of this operation.

• Solution: Delete the foreign key constraints or specify the CASCADE constraint.