Chapter 10. 10000 ~ 10999

10001: Cursor pool overflow.

CauseThe cursor pool is full.
ActionIncrease the size of the pool.

10003: Data is too long to be bound to the specified type.

CauseThe amount of data exceeds the maximum allowed of the type to which it will be bound.
ActionModify the length of the data.

10004: Cannot use UNION command on these tables or views.

CauseCannot perform the UNION operation for the given tables or views.
ActionCheck that the numbers of columns are equal and that the types of each column are compatible.

10005: NOT NULL constraint violation (\'%1$s\'.\'%2$s\'.\'%3$s\').

CauseAn attempt was made to insert the NULL value into a column where the NOT NULL constraint is specified.
ActionRemove the NOT NULL constraint, or insert a value that is not NULL.

10006: CHECK constraint violation (\'%1$s\'.\'%2$s\').

CauseThe inserted value(s) do(es) not satisfy the existing CHECK condition.
ActionInsert a value that satisfies the CHECK condition.

10007: UNIQUE constraint violation (\'%1$s\'.\'%2$s\').

CauseAn attempt was made to insert a duplicate value into a column where the UNIQUE constraint is specified.
ActionCancel the UNIQUE constraint, or insert a unique value.

10008: INTEGRITY constraint violation (\'%1$s\'.\'%2$s\'): primary key not found.

CauseA primary key does not exist for the foreign key.
ActionDelete the foreign key, or add a primary key.

10009: INTEGRITY constraint violation (\'%1$s\'.\'%2$s\'): foreign key exists.

CauseAn attempt was made to delete a primary key that is referenced by a foreign key.
ActionDelete the foreign key first and then try again.

10010: Statement does not satisfy the WHERE clause of the view.

CauseThe INSERT or UPDATE statement of the view does not satisfy the WHERE clause when the WITH CHECK OPTION is specified.
ActionModify the DML statement to satisfy the WHERE condition clause of the view, or delete WITH CHECK OPTION of the view.

10011: SORT_AREA_SIZE is too small to accommodate all active sort operators.

CauseThere are not enough allocated sort areas.
ActionIncrease the value of SORT_AREA_SIZE.

10012: Cannot pin more blocks.

CauseCannot process all data because the buffer cache is not big enough.
ActionIncrease the value of DB_CACHE_SIZE.

10013: HASH_AREA_SIZE is too small to accommodate all active sort operators.

CauseThere are not enough allocated hash areas.
ActionIncrease the value of HASH_AREA_SIZE.

10014: Maximum LEVEL value exceeded during a CONNECT BY operation.

CauseThe LEVEL value of a node exceeded the maximum during a CONNECT BY operation.
ActionContact the technical support team.

10015: Loop detected during a CONNECT BY operation.

CauseA loop was detected during a CONNECT BY operation.
ActionModify the CONNECT BY clause and data so that a loop does not occur.

10016: Table mutation occurred during trigger execution.

CauseTable mutation occurred during trigger execution.
ActionDelete the mutation.

10017: Unable to open file \'%1$s\' in file scan mode.

CauseThe specified file could not be found.
ActionCheck the name and directory of the specified datafile.

10018: Partition key does not map to a partition.

CauseThere is no defined partition to which the partition key is mapped.
ActionCheck the definition of the partition in the corresponding table.

10019: Updating partition key column would cause a partition change.

CauseUpdating the partitioned table key will cause a partition change.
ActionCheck the definition of the partition in the corresponding table.

10020: Specified row no longer exists.

CauseThe specified row does not exist.
ActionVerify that the specified row is correct.

10021: Inconsistent set of rows in source tables.

CauseInconsistent DML result due to a non-deterministic WHERE condition.
ActionModify the non-deterministic WHERE condition.

10022: Empty pivot column must not exist.

CauseThere is an empty pivot column.
ActionModify the PIVOT_PICK_COL parameter.

10023: Invalid pivot aggregation alias.

CauseAn error occurred in the string pattern that determines a column name when performing a pivot operation.
ActionCheck to see if a percent (%) character is missing in the string pattern.

10024: Pivot column name must be unique for CASE or DECODE operations.

CauseResults with the same pivot column name were selected when performing a CASE/DECODE operation.
ActionModify the string pattern for the column names given to each set operation when performing a pivot operation.

10025: Too many pivot column names generated after calculation.

CauseThere are too many pivot column names created after calculation.
ActionDecrease the number of calculations.

10026: The REFCUR table contains invalid number of columns.

CauseThe number of columns defined in the REFCUR table does not match the actual number.
ActionModify the REFCUR table clause to match the actual number.

10027: REFCUR table contains invalid column type.

CauseThe data type of a column defined in the REFCUR table does not match the actual data type.
ActionModify the REFCUR table clause to match the actual data type.

10028: Number of columns specified in file \'%1$s\' and in data dictionary do not match.

CauseThe number of columns specified in the file does not match the number of columns in the data dictionary.
ActionCheck the number of columns of specified in the file.

10029: Unable to read table (or index) with old snapshot.

CauseUnable to read a table or index with an old snapshot.
ActionUse a snapshot from after the table or index was modified.

10030: Invalid WKB geometry data.

CauseThe entered WKB data is invalid.
ActionCheck the WKB data.

10031: Invalid geometric object type.

CauseAn invalid geometric object type was executed.
ActionCheck to see if the geometric object type is executable.

10032: Index number is out of range.

CauseThe value of N is less than 1 or larger than the number of Points in LineString.
ActionCheck the N value.

10033: Invalid WKT geometry data.

CauseThe entered WKT data is invalid.
ActionCheck the WKT data.

10034: Internal error: %1$s.

CauseAn internal error occurred.
ActionCheck the data.

10035: Invalid pivot expression.

CauseToo many pivot columns were created after the operation.
ActionCheck the query.

10036: Invalid XML.

CauseAn invalid type of XML was entered.
ActionCheck the XML.

10037: Invalid XQuery.

CauseInvalid XQuery.
ActionCheck the XQuery syntax.

10038: Comparing multi-valued pivot columns is restricted.

CauseComparing multi-valued pivot columns is restricted.
ActionCheck whether the pivot columns have multi values.

10039: Invalid text query syntax.

CauseInvalid query syntax of the text.
ActionCheck the query syntax.

10040: No more stop words can be inserted.

CauseCannot add another stop word for the text.
ActionCheck the number of stop words.

10041: The text index is invalid.

CauseThe text index is not available.
ActionCheck the text index status.

10042: A multi valued result is not allowed.

CauseMulti valued results are not allowed.
ActionThere are multiple results for XPath in the XML.

10043: Invalid XPath expression.

CauseInvalid XPath expression.
ActionCheck the XPath expression.

10044: Invalid child value.

CauseInvalid child value.
ActionCheck the child value.

10046: XML library error '%1$s'.

CauseAn error occurred in an external XML library.
ActionCheck the error message.

10047: XQuery type mismatch.

CauseThe return type of XQuery does not match the declared column type.
ActionChange the type of the column.

10048: XPath does not point to a leaf node.

CauseThe given XPath does not indicate a leaf node.
ActionModify XPath to indicate a leaf node.

10049: XPath does not point to a single node.

CauseThe given XPath has multiple nodes.
ActionModify XPath to have only one node.

10050: Size of datatype is too small to serialize the XML document.

CauseThe size of the data type to serialize the XML document is too small.
ActionIncrease the data type size.

10051: Invalid XML namespace.

CauseThe format of the XML namespace is invalid.
ActionCheck whether the format is 'xmlns:<prefix>=<href>'.

10052: The XML document is too big for the DOM tree.

CauseThe XML document is too big for the DOM tree.
ActionDecrease the size of the XML document.

10053: It is impossible to bind two or more LOBs or LONG data together.

CauseIt was attempted to bind two or more LOBs or LONG data through the database link.
ActionCheck the SQL and change it.

10054: The table needs more tablets.

CauseAdd tablets to the table
Action 

10055: The table needs more tablets for bucketno \'%1$d\'.

CauseAdd \'%1$d\' bucketno tablets to table.
Action 

10062: Unable to access LONG or LOB columns through DBlink.

CauseAn attempt was made use DBlink to refer to an object with LONG or LOB columns.
ActionModify the query.

10063: The cached remote table information does not match the actual remote table's information.

CauseThe remote table definition (number of columns, type, or length) has changed.
ActionTry again.

10064: Loop detected during %1$s operation.

CauseA loop was detected during a %1$s operation.
ActionModify the %1$s clause or data so that a loop does not occur.

10065: There are too many Aggregate functions.

CauseCannot be executed in parallel or in multiple passes.
ActionCannot be executed in parallel or in multiple passes.

10066: Invalid TSN value.

CauseThe TSN value of the flashback query must be greater than 0.
ActionUse a valid TSN value.

10067: The policy check constraint is violated.

CauseThe data to be added or updated does not satisfy the policy predicate.
ActionNone

10068: The number of columns in the cached remote table does not match the number of columns in the remote table. (local: %1$d, remote: %2$d)

CauseThe number of columns in the remote table has changed, or the number of columns in the REFCUR/PROC table has been incorrectly set.
ActionRetry or modify the number of columns in the REFCUR/PROC table.

10069: The column length of the cached remote table is shorter than the column length of the remote table. (column: %1$d, local: %2$d bytes, remote: %3$d bytes)

CauseThe column length of the remote table has changed, or the column length of the RERCUR/PROC table has been incorrectly set.
ActionRetry or modify the column length of the REFCUR/PROC table so that it is longer than or the same as the column length of the remote table.

10070: The column type of the cached remote table does not match the column type of the remote table. (column: %1$d, local: %2$s, remote: %3$s)

CauseThe column type of the remote table has changed, or the column type of the REFCUR/PROC table has been incorrectly set.
ActionRetry or modify the column type in the REFCUR/PROC table.

10071: Cannot assign a process to execute the global view.

CauseAll processes are currently in use.
ActionIncrease the number of processes or terminate another session.

10072: Cannot assign a thread to execute the global view.

CauseAll threads are currently in use.
ActionIncrease the number of threads or terminate another session.

10073: Response time for the global view exceeded threshold.

CauseGlobal view search is taking a long time or there is a network problem.
ActionIncrease the response time limit for the global view.

10074: An error occurred while executing the '%1$s' function.

CauseCheck the definition of the object type.
ActionModify the definition of the object type and regenerate it.

10075: Exceeds the reject limit.

CauseExceeds the reject limit.
ActionModify the data or increase the reject limit.

10076: Received a GV error reply(ec=%1$d) from session %2$d.

CauseOne of GV sessions sent an error reply.
ActionCheck the error of the error-occurred session in the log file.