ORA-01500 to ORA-01999

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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5381

• SQLSTATE: HY000

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

ORA-01702: a view is not appropriate here

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5622

• SQLSTATE: HY000

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

ORA-01711: duplicate privilege listed

• Error code in OceanBase Database: 4349

• SQLSTATE: HY000

• Cause: The statement lists duplicate privileges.

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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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'

• Error code in OceanBase Database: 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'

• Error code in OceanBase Database: 4262

• SQLSTATE: 01000

• Cause: The specified number is invalid.

• Solution: Specify a valid number.

ORA-01722: invalid number

• Error code in OceanBase Database: 5085

• SQLSTATE: 22000

• Cause: The specified number is invalid.

• Solution: Specify a valid number.

ORA-01722: invalid number char '%c'

• Error code in OceanBase Database: 5114

• SQLSTATE: 42000

• Cause: The specified number is invalid.

• Solution: Specify a valid number.

ORA-01723: zero-length columns are not allowed

• Error code in OceanBase Database: 5628

• SQLSTATE: HY000

• Cause: Zero-length columns exist.

• Solution: Use qualified columns.

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

• Error code in OceanBase Database: 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)

• Error code in OceanBase Database: 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)

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5097

• SQLSTATE: HY000

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

ORA-01730: invalid number of column names specified

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5239

• SQLSTATE: 42S02

• Cause: A circular view is defined.

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

• Error code in OceanBase Database: 5714

• SQLSTATE: HY000

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

ORA-01733: virtual column not allowed here

• Error code in OceanBase Database: 5715

• SQLSTATE: HY000

• Cause: Virtual columns are present.

ORA-01741: illegal zero-length identifier

• Error code in OceanBase Database: 5854

• SQLSTATE: HY000

• Cause: The zero-length identifier is invalid.

ORA-01743: only pure functions can be indexed

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5617

• SQLSTATE: HY000

• Cause: The INTO statement is inappropriate.

ORA-01748: only simple column names allowed here

• Error code in OceanBase Database: 5864

• SQLSTATE: HY000

• Cause: Only a simple column name is allowed.

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

• Error code in OceanBase Database: 5384

• SQLSTATE: HY000

• Cause: You attempted 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5946

• SQLSTATE: HY000

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

ORA-01760: illegal argument for function

• Error code in OceanBase Database: 5728

• SQLSTATE: HY000

• Cause: The function contains invalid arguments.

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

• Error code in OceanBase Database: 5731

• SQLSTATE: HY000

• Cause: You attempted 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5722

• SQLSTATE: HY000

• Cause: You attempted 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5346

• SQLSTATE: HY000

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

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

• Error code in OceanBase Database: 5766

• SQLSTATE: HY000

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

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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5668

• SQLSTATE: HY000

• Cause: The expression is not a SELECT expression.

ORA-01796: this operator cannot be used with lists

• Error code in OceanBase Database: 5729

• SQLSTATE: HY000

• Cause: This operator cannot be used with lists.

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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5712

• SQLSTATE: HY000

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

ORA-01804: failure to initialize timezone information

• Error code in OceanBase Database: 5123

• SQLSTATE: HY000

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

ORA-01810: format code appears twice

• Error code in OceanBase Database: 5652

• SQLSTATE: HY000

• Cause: The format code appears twice.

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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5656

• SQLSTATE: HY000

• Cause: The year can be specified only once.

ORA-01813: hour may only be specified once

• Error code in OceanBase Database: 5657

• SQLSTATE: HY000

• Cause: The hour can be specified only once.

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

• Error code in OceanBase Database: 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.

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5660

• SQLSTATE: HY000

• Cause: The month can be specified only once.

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

• Error code in OceanBase Database: 5653

• SQLSTATE: HY000

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

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

• Error code in OceanBase Database: 5661

• SQLSTATE: HY000

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

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

• Error code in OceanBase Database: 5664

• SQLSTATE: HY000

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

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

• Error code in OceanBase Database: 5654

• SQLSTATE: HY000

Cause: The signed date cannot contain BC or AD.

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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 4190

• SQLSTATE: 22007

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

ORA-01831: year conflicts with Julian date

• Error code in OceanBase Database: 5629

• SQLSTATE: HY000

• Cause: The year conflicts with the Julian day.

ORA-01832: day of year conflicts with Julian date

• Error code in OceanBase Database: 5630

• SQLSTATE: HY000

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

ORA-01833: month conflicts with Julian date

• Error code in OceanBase Database: 5631

• SQLSTATE: HY000

• Cause: The month conflicts with the Julian day.

ORA-01834: day of month conflicts with Julian date

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5634

• SQLSTATE: HY000

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

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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5636

• SQLSTATE: HY000

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

ORA-01839: date not valid for month specified

• Error code in OceanBase Database: 5637

• SQLSTATE: HY000

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

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

• Error code in OceanBase Database: 5638

• SQLSTATE: HY000

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

ORA-01841: (full) year must be between -4713 and +9999 and not be 0

• Error code in OceanBase Database: 5639

• SQLSTATE: HY000

• Cause: The input year is invalid.

• Solution: Input a year within the specified range.

ORA-01842: quarter must be between 1 and 4

• Error code in OceanBase Database: 5640

• SQLSTATE: HY000

• Cause: Quarter must range from 1 to 4.

ORA-01843: not a valid month

• Error code in OceanBase Database: 5641

• SQLSTATE: HY000

• Cause: The month is invalid.

ORA-01846: not a valid day of the week

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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)

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5651

• SQLSTATE: HY000

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

ORA-01857: not a valid time zone

• Error code in OceanBase Database: 5711

• SQLSTATE: HY000

• Cause: The time zone is invalid.

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

• Error code in OceanBase Database: 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'

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5873

• SQLSTATE: HY000

• Cause: When code in FX or FM format is specified for the input date, the number of digits must be 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5341

• SQLSTATE: HY000

• Cause: The region ID is invalid.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ORA-01882: timezone region not found

• Error code in OceanBase Database: 5192

• SQLSTATE: HY000

• Cause: The specified region name is not found.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ORA-01891: Datetime/Interval internal error

• Error code in OceanBase Database: 5898

• SQLSTATE: HY000

• Cause: An internal error occurred.

• Solution: Contact OceanBase Technical Support for troubleshooting.

ORA-01930: auditing the object is not supported

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5369

• SQLSTATE: HY000

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

• Solution: Specify a new name.

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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5380

• SQLSTATE: HY000

• Cause: You attempted 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

• Error code in OceanBase Database: 5362

• SQLSTATE: 42000

• Cause: You attempted 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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'

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 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

• Error code in OceanBase Database: 5376

• SQLSTATE: HY000

• Cause: The role name is invalid.

• Solution: Specify a valid role name.

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

• Error code in OceanBase Database: 5379

• SQLSTATE: HY000

• Cause: The role that you attempted 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'

• Error code in OceanBase Database: 5363

• SQLSTATE: HY000

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

• Solution: Ensure that the system privileges that you attempted to revoke have been granted to the user.

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

• Error code in OceanBase Database: 5378

• SQLSTATE: HY000

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

  Note

  Sub-roles cannot be used in the DEFAULT ROLE clause.

• Solution: Grant the role to the user.

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

• Error code in OceanBase Database: 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.