Skip to content

Fatih Acar's blog

About of Database Systems and Information Technologies

Menu
  • Home
  • About Me
  • Contact Me
Menu

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13100 to ORA-13200

Posted on 14/09/201608/02/2017 by Fatih Acar

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13100 to ORA-13200

ORA-13100: feature does not exist

Cause: The feature does not exist.

Action: Contact Oracle Support Services.

ORA-13101: invalid ptn_type parameter

Cause: An incorrect ptn_type parameter was specified.

Action: Ensure the ptn_type parameter value is correct.

ORA-13102: invalid ptn_capacity parameter

Cause: An incorrect ptn_capacity parameter was specified.

Action: Ensure the ptn_capacity parameter value is correct.

ORA-13103: invalid numdim parameter

Cause: An incorrect numdim parameter was specified.

Action: Ensure the numdim parameter value is correct.

ORA-13104: null values not allowed in input data

Cause: Null values cannot be specified in the supplied input data.

Action: Ensure that all null-values have been removed from the data.

ORA-13105: invalid Parameters for Partition_Table

Cause: One or more parameters for the Partition_Table() function are invalid.

Action: Ensure that the identified parameters are correctly specified.

ORA-13106: invalid MASK parameter

Cause: The specified MASK parameter was invalid.

Action: Ensure that the MASK parameter values are correctly specified.

ORA-13107: operation not supported for Non-Uniform Rational B-Spline type

Cause: This operation cannot be executed for Non-Uniform Rational B-Spline curves.

Action: Specify a geometry that does not contain a Non-Uniform Rational B-Spline curve type.

ORA-13108: spatial table string not found

Cause: The specified spatial table did not exist.

Action: Check the spatial data dictionary to ensure that the table is registered.

ORA-13109: spatial table string exists

Cause: The specified spatial table is registered in the Spatial data dictionary.

Action: Remove the existing table from the Spatial data dictionary or use a different name.

ORA-13110: cannot drop topology with associated topo_geometry tables

Cause: The drop_topology procedure was invoked for a topology that has assocated topo_geometry layers with it.

Action: Delete the topo_geometry layers from the topology before dropping the topology. Use SDO_TOPO.delete_topo_geometry_layer to delete topo_geometry layers from the topology.

ORA-13111: cannot add topo_geometry layer [string] to topology

Cause: It was not possible to add the specified TOPO_GEOMETRY layer to the topology.

Action: Ensure that the TOPO_GEOMETRY layer table exists in the database.

ORA-13112: cannot delete topo_geometry layer [string] from topology

Cause: It was not possible to delete the specified topo_geometry layer from the topology.

Action: Check USER_SDO_TOPO_METADATA to see if the specified topo_geometry layer is part of the topology. Only those topo_geometry layers which are part of the topology can be deleted from it.

ORA-13113: invalid tg_layer_id in sdo_topo_geometry constructor

Cause: An invalid layer_id was passed to the SDO_TOPO_GEOMETRY constructor.

Action: Valid layer_ids are obtained by adding a topo_geometry layer to the topology. Check USER_SDO_TOPO_METADATA to find out the layer_id for an existing topo_geometry layer.

ORA-13114: [string]_NODE$ table does not exist

Cause: The NODE$ table for the topology did not exist in the database.

Action: There is a severe corruption of the topology. Call Oracle Support Services with the error number.

ORA-13115: [string]_EDGE$ table does not exist

Cause: The EDGE$ table for the topology did not exist in the database.

Action: There is a severe corruption of the topology. Call Oracle Support Services with the error number.

ORA-13116: [string]_FACE$ table does not exist

Cause: The FACE$ table for the topology did not exist in the database.

Action: There is a severe corruption of the topology. Call Oracle Support Services with the error number.

ORA-13117: [string]_RELATION$ table does not exist

Cause: The RELATION$ table for the topology did not exist in the database.

Action: There is a severe corruption of the topology. Call Oracle Support Services with the error number.

ORA-13118: invalid node_id [string]

Cause: A topology node operation was invoked with an invalid node_id.

Action: Check the topology node$ table to see if the specified node_id exists in the topology.

ORA-13119: invalid edge_id [string]

Cause: A topology edge operation was invoked with an invalid edge_id.

Action: Check the topology edge$ table to see if the specified edge_id exists in the topology.

ORA-13120: invalid face_id [string]

Cause: A topology face operation was invoked with an invalid face_id.

Action: Check the topology face$ table to see if the specified face_id exists in the topology.

ORA-13121: layer type type mismatch with topo_geometry layer type

Cause: The tg_type in SDO_TOPO_GEOMETRY constructor did not match the type specified for the layer.

Action: Check the USER_SDO_TOPO_METADATA view to see the layer type for the layer and use it in the constructor.

ORA-13122: invalid topo_geometry specified

Cause: The SDO_TOPO_GEOMETRY object passed into the function/operator was not valid.

Action: Check the SDO_TOPO_GEOMETRY object and verify that it is a valid topo_geometry object.

ORA-13123: invalid TOPOLOGY name specified

Cause: The create_topo operation requires a unique TOPOLOGY name, that already does not exist in the database.

Action: Check to see if there is already an entry in the USER_SDO_TOPO_METADATA (or the MDSYS.SDO_TOPO_METADATA_TABLE) with this topology name.

ORA-13124: unable to determine column id for column string

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13125: partition key is already set

Cause: A partition key is already set for the spatial table.

Action: Only one partition key can be specified per spatial table.

ORA-13126: unable to determine class for spatial table string

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13127: failed to generate target partition

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13128: current tiling level exceeds user specified tiling level

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13129: HHCODE column string not found

Cause: The specified spatial column does not exist.

Action: Verify that the specified column is a spatial column by checking the Spatial data dictionary.

ORA-13135: failed to alter spatial table

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13136: null common code generated

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13137: failed to generate tablespace sequence number

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13138: could not determine name of object string

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13139: could not obtain column definition for string

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13140: invalid target type

Cause: The specified target type is not valid.

Action: Substitute a valid target type. Valid target types are TABLE and VIEW.

ORA-13141: invalid RANGE window definition

Cause: The RANGE window specified is not correctly defined.

Action: A RANGE window is defined by specifying the lower and upper boundary of each dimension as a pair of values (e.g.: lower_bound1,upper_bound1,lower_bound2,upper_bound2,…). There should be an even number of values.

ORA-13142: invalid PROXIMITY window definition

Cause: The PROXIMITY window specified is not correctly defined.

Action: A PROXIMITY window is defined by specifying a center point and a radius. The center point is defined by ND values. There should be ND+1 values.

ORA-13143: invalid POLYGON window definition

Cause: The POLYGON window specified is not correctly defined.

Action: A POLYGON window is defined by specifying N pairs of values that represent the vertices of the polygon. There should be an even number of values.

ORA-13144: target table string not found

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13145: failed to generate range list

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13146: could not find table substitution variable string

Cause: The partition name substitution variable %s was not found in the SQL filter.

Action: The substitution variable %s must be in the SQL filter to indicate where that partition name should be placed.

ORA-13147: failed to generate MBR

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13148: failed to generate SQL filter

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13149: failed to generate next sequence number for spatial table string

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13150: failed to insert exception record

Cause: Operation failed to insert a record into the exception table.

Action: Fix any other errors reported.

ORA-13151: failed to remove exception record

Cause: Operation failed to remove a record from the exception table.

Action: Fix any other errors reported.

ORA-13152: invalid HHCODE type

Cause: Specified HHCODE type is not valid.

Action: Substitute a valid HHCODE type. Valid HHCODE types are POINT and LINE.

ORA-13153: invalid high water mark specified

Cause: The high water mark was not greater than or equal to zero.

Action: Ensure that the high water mark is an integer greater than or equal to zero.

ORA-13154: invalid precision specified

Cause: The precision specified is out of range.

Action: The precision must be an integer greater than or equal to zero.

ORA-13155: invalid number of dimensions specified

Cause: The number of dimensions specified is out of range.

Action: The number of dimension must be between 1 and 32.

ORA-13156: table to be registered string.string is not empty

Cause: The specified table contained rows.

Action: Ensure that the table to be registered is empty.

ORA-13157: Oracle error ORAstring encountered while string

Cause: The specified Oracle error was encountered.

Action: Correct the Oracle error.

ORA-13158: Oracle object string does not exist

Cause: The specified object does not exist.

Action: Verify that the specified object exists.

ORA-13159: Oracle table string already exists

Cause: The specified table already exists.

Action: Drop the specified table.

ORA-13181: unable to determine length of column string_SDOINDEX.SDO_CODE

Cause: The length of the SDO_CODE column in the layer_SDOINDEX table could not be determined.

Action: Ensure that the layer_SDOINDEX table exists with the SDO_CODE column. Verify that the appropriate privileges exist on the table. Then retry the operation.

ORA-13182: failed to read element string.string.string

Cause: The specified element could not be read from the layer_SDOGEOM table.

Action: Verify that the specified element exists in the table. Then retry the operation.

ORA-13183: unsupported geometric type for geometry string.string

Cause: The geometry type in the layer_SDOGEOM table is unsupported.

Action: Modify the geometry type to be one of the supported types.

ORA-13184: failed to initialize tessellation package

Cause: Initialization of the tessellation package failed.

Action: Record the error messages that are returned and contact Oracle Support Services.

ORA-13185: failed to generate initial HHCODE

Cause: This is an internal error.

Action: Record the error messages that are returned and contact Oracle Support Services.

ORA-13186: fixed tile size tessellation failed

Cause: This is an internal error.

Action: Record the error messages that are returned and contact Oracle Support Services.

ORA-13187: subdivision failed

Cause: This is an internal error.

Action: Record the error messages that are returned and contact Oracle Support Services.

ORA-13188: cell decode failed

Cause: This is an internal error.

Action: Record the error messages that are returned and contact Oracle Support Services.

ORA-13189: recursive SQL parse failed

Cause: This is an internal error.

Action: Record the error messages that are returned and contact Oracle Support Services.

ORA-13190: recursive SQL fetch failed

Cause: This is an internal error.

Action: Record the error messages that are returned and contact Oracle Support Services.

ORA-13191: failed to read SDO_ORDCNT value

Cause: This is an internal error.

Action: Record the error messages that are returned and contact Oracle Support Services.

ORA-13192: failed to read number of element rows

Cause: This is an internal error.

Action: Record the error messages that are returned and contact Oracle Support Services.

ORA-13193: failed to allocate space for geometry

Cause: There was insufficient memory to read the geometry from the database.

Action: Validate the geometry. Record the error messages that are returned and contact Oracle Support Services.

ORA-13194: failed to decode supercell

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13195: failed to generate maximum tile value

Cause: This is an internal error.

Action: Record the error messages that are returned and contact Oracle Support Services.

ORA-13196: failed to compute supercell for element string.string.string

Cause: The system was unable to compute the minimum bounding HHCODE or supercell for the geometry.

Action: Another error might accompany this error. Correct the accompanying error. Also, validate the geometry for correctness.

ORA-13197: element string.string.string is out of range

Cause: Tessellation did not generate any tiles for this element. This error could be caused if the geometry definition puts the geometry outside the domain defined in the layer_SDODIM table.

Action: Verify that the geometry is valid and within the defined domain.

ORA-13198: Spatial error: string

Cause: Internal error in some Oracle Spatial stored procedure.

Action: Record the sequence of procedure calls or events that preceded this error, and contact Oracle Support Services if the error message text does not clearly specify the cause of the error.

ORA-13199: string

Cause: This is an internal error.

Action: Contact Oracle Support Services.

ORA-13200: internal error [string] in spatial indexing.

Cause: This is an internal error.

Action: Contact Oracle Support Services with the exact error text.

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X
  • Click to share on Facebook (Opens in new window) Facebook

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.



View Fatih ACAR's profile on LinkedIn

Categories

  • Databases (329)
    • MsSQL Server (18)
      • Administration (16)
      • Errors and Solutions (4)
      • SQL (2)
    • MySQL (5)
      • Administration (4)
      • Backup And Recovery (1)
      • Errors and Solutions (1)
    • Oracle (290)
      • Administration (79)
      • Backup And Recovery (29)
      • Errors and Solutions (195)
      • Procedure (10)
      • SQL (32)
    • PostgreSQL (16)
      • Administration (15)
      • Errors and Solutions (3)
      • SQL (2)
    • Redis (1)
  • Microsotf Dynamics CRM (1)
  • Operating Systems (47)
    • Linux & Unix (34)
    • Windows (13)
  • Programing (5)
    • Python (5)
  • SAP (15)
    • Errors and Solutions (4)
    • SAP Basis (12)
  • Security (8)
    • Database Security (6)
    • Information Security (1)
    • System Security (4)
  • VMware (4)

Recent Posts

  • Redis 7 Sentinel Infrastructure Installation
  • Oracle Database 19c Multi Data Guard and DML Redirect, Switchover-Failover Operations on Oracle Linux 8
  • Oracle Database 23ai Free Installation Steps on Oracle Linux 9
  • Oracle Database 19c Active Data Guard Installation and DML Redirect, Switchover-Failover Operations on Oracle Linux 8
  • Oracle Database 19c Installation and 19.22 RU Patch Apply on Oracle Linux 8

Resources

  • Oracle
  • PostgreSQL

Blogroll

  • Gökhan Atıl
  • H. Koray Gündüz
  • Hakan Talip Öztürk
  • Zekeriya Beşiroğlu

Web Pages

  • BT Çözümleri

Tag Cloud

Administration Backup and Recovery Cluster Systems Database Administration Database Security Linux Linux Administration MsSQL Server MsSQL Server Error and Solutions MySQL MySQL Administration ORA-00018 ORA-00020 Oracle Oracle 12c Oracle 19c Oracle Administration Oracle Backup and Restore Oracle Data Guard Oracle Data Guard Failover Oracle Data Guard Switchover Oracle Error Solutions Oracle Linux Oracle Rman Backup Oracle Security Oracle SQL Query PostgreSQL PostgreSQL Administration PostgreSQL High Availability PostgreSQL Hot Standby Python SAP Basis Sap Errors and Solutions Sap System Administration SQL SQL Server Administration SQL Server Availability Group Stored Procedure System Administration System Security VMware VMware Administration Windows Windows Batch Script Windows Server

Social

  • View facar1987’s profile on Twitter
  • View facar’s profile on LinkedIn

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 17 other subscribers
©2026 Fatih Acar's blog | Built using WordPress and Responsive Blogily theme by Superb