{"id":2214,"date":"2016-09-14T10:01:09","date_gmt":"2016-09-14T07:01:09","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2214"},"modified":"2017-02-08T10:02:34","modified_gmt":"2017-02-08T07:02:34","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-13200-to-ora-13300","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-13200-to-ora-13300\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13200 to ORA-13300"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13200 to ORA-13300<\/strong><\/p>\n

\n
ORA-13200: internal error [string<\/i>] in spatial indexing.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This is an internal error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services with the exact error text.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13201: invalid parameters supplied in CREATE INDEX statement<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error was encountered while trying to parse the parameters clause for the spatial CREATE INDEX statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the Oracle Spatial documentation for the number, syntax, and semantics of expected parameters for spatial index creation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13202: failed to create or insert into the SDO_INDEX_METADATA table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error was encountered while trying to create the SDO_INDEX_METADATA table or insert data into it.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that the current user has CREATE TABLE privilege and that the user has sufficient quota in the default or specified tablespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13203: failed to read USER_SDO_GEOM_METADATA view<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error encountered while trying to read the USER_SDO_GEOM_METADATA view.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that USER_SDO_GEOM_METADATA has an entry for the current geometry table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13204: failed to create spatial index table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error was encountered while trying to create the index table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that user has CREATE TABLE privilege in the current schema and that the user has sufficient quota in the default or specified tablespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13205: internal error while parsing spatial parameters<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An internal error was encountered while parsing the spatial parameters.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that the parameters passed in the parameter string are all valid.<\/span><\/span>
\n<\/p>\n

\n
<\/a> ORA-13206: internal error [string<\/i>] while creating the spatial index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An internal error was encountered while creating the spatial index.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services with the exact error text.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13207: incorrect use of the [string<\/i>] operator<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error was encountered while evaluating the specified operator.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the parameters and the return type of the specified operator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13208: internal error while evaluating [string<\/i>] operator<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An internal error was encountered.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services with the exact error text.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13209: internal error while reading SDO_INDEX_METADATA table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An internal error was encountered while trying to read the SDO_INDEX_METADATA table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services. Note this and accompanying error numbers.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13210: error inserting data into the index table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error was encountered while trying to insert data into the index table. Likely causes are: – Insufficient quota in the current tablespace – User does not appropriate privileges<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the accompanying error messages.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13211: failed to tessellate the window object<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An internal error was encountered while trying to tessellate the window object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the geometric integrity of the window object using the VALIDATE_GEOMETRY_WITH_CONTEXT procedure.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13212: failed to compare tile with the window object<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The spatial relationship between a generated tile and the specified window object could not be determined.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is an internal error. Verify the geometry using the VALIDATE_GEOMETRY_WITH_CONTEXT procedure. If the procedure does not return any errors, note any accompanying errors and contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13213: failed to generate spatial index for window object<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Another error, indicating the real cause of the problem, should accompany this error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct any accompanying errors. If no accompanying error message appears, contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13214: failed to compute supercell for window object<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The system was unable to compute the minimum bounding tile or supercell for the geometry.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Another error might accompany this error. Correct the accompanying error. Also, validate the geometry for correctness.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13215: window object is out of range<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Tessellation did not generate any tiles for this geometry. This error could be caused if the geometry definition puts the geometry outside the domain defined in the USER_SDO_GEOM_METADATA view.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that the geometry is valid and within the defined domain.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13216: failed to update spatial index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Another error will accompany this message that will indicate the problem.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct any accompanying errors. If no accompanying error message appears, contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13217: invalid parameters supplied in ALTER INDEX statement<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error was encountered while trying to parse the parameters clause for the spatial ALTER INDEX statement.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the Oracle Spatial documentation for the number, syntax, and semantics of expected parameters for the spatial ALTER INDEX statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13218: max number of supported index tables reached for [string<\/i>] index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An add_index parameter was passed to ALTER INDEX when the number of existing index tables is already at maximum.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Delete one of the index tables before adding another index table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13219: failed to create spatial index table [string<\/i>]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error was encountered while trying to create the index table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0There is a table in the index’s schema with the specified name. The CREATE INDEX statement will try to create an index table with this name. Either rename this table or change the name of the index.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13220: failed to compare tile with the geometry<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The spatial relationship between a generated tile and the specified geometry could not be determined.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is an internal error. Validate the geometry using the VALIDATE_GEOMETRY_WITH_CONTEXT procedure. If the procedure does not return any errors, note any errors that accompany ORA-13220 and contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13221: unknown geometry type in the geometry object<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SDO_GTYPE attribute in the geometry object contains an invalid value<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Redefine the geometric type in the geometry table using one of the supported SDO_GTYPE values. See the Oracle Spatial documentation for an explanation of SDO_GTYPE and its possible values.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13222: failed to compute supercell for geometry in\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The system was unable to compute the minimum bounding tile or supercell for a geometry in the specified table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Another error might accompany this error. Correct the accompanying error. Also, validate the geometry for correctness.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13223: duplicate entry for\u00a0string<\/i>\u00a0in SDO_GEOM_METADATA<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There are duplicate entries for the given table and column value pair in the USER_SDO_GEOM_METADATA view.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that the specified table and geometry column names are correct. There should be only one entry per table, geometry column pair in the USER_SDO_GEOM_METADATA view.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A tolerance of zero or NULL was supplied for a layer in the USER_SDO_GEOM_METADATA view.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the tolerance specified to ensure that it is a positive value.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13225: specified index table name is too long for a spatial index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An index table name is specified which is longer than the supported length of the spatial index table name.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the supported size of the index table name and reduce the size of the index name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13226: interface not supported without a spatial index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The geometry table does not have a spatial index.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that the geometry table referenced in the spatial operator has a spatial index on it.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13227: SDO_LEVEL values for the two index tables do not match<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The SDO_LEVEL values for the two index tables used in the spatial join operator do not match.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that two compatible indexes are used for the spatial join operator. Quadtree indexes are compatible if they have the same SDO_LEVEL and SDO_NUMTILES values<\/span><\/span><\/p>\n

\n
<\/a> ORA-13228: spatial index create failed due to invalid type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a spatial index on a column of type other than SDO_GEOMETRY.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the index is created on a column of type SDO_GEOMETRY.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13230: failed to create temporary table [string<\/i>] during R-tree creation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified temporary table either already exists or there is not enough tablespace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Delete the table if it already exists and verify if the current user has CREATE TABLE privileges and has sufficient space in the default or specified tablespace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13231: failed to create index table [string<\/i>] during R-tree creation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified index table either already exists or there is not enough tablespace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Delete the table if it already exists and verify if the current user has CREATE TABLE privileges and has sufficient space in the default or specified tablespace. If that fails to correct the problem, contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13232: failed to allocate memory during R-tree creation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0This feature assumes a minimum of 64K memory for bulk creation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the index for a small subset of the data. Then, use transactional insert operations for the rest of the data.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13233: failed to create sequence number [string<\/i>] for R-tree<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified sequence number exists.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Delete the sequence object, or contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13234: failed to access R-tree-index table [string<\/i>]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The index table is either deleted or corrupted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rebuild the index or contact Oracle Support Services with accompanying error messages.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13236: internal error in R-tree processing: [string<\/i>]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An internal error occurred in R-tree processing.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services with the message text.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13237: internal error during R-tree concurrent updates: [string<\/i>]<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An inconsistency is encountered during concurrent updates, possibly due to the use of serializable isolation level.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the isolation level to “read committed” using the ALTER SESSION statement, or contact Oracle Support Services with the message text.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13239: sdo_dimensionality not specified during n-d R-tree creation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred in reading the dimensionality parameter<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the documentation for a valid range, and specify the dimensionality as a parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13240: specified dimensionality greater than that of the query mbr<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred because of too few values in the query minimum bounding rectangle (MBR).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Omit the dimensionality, or use the dimensionality of the query.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13241: specified dimensionality does not match that of the data<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An error occurred because the dimensionality specified in the CREATE INDEX statement does not match that of the data.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the statement to reflect the data dimensionality.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13243: specified operator is not supported for 3- or higher-dimensional R-tree<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Currently, an R-tree index with three or more index dimensions can be used only with the SDO_FILTER operator.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use the SDO_FILTER operator, and check the documentation for the querytype parameter for SDO_FILTER; or contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13249:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An internal error was encountered in the extensible spatial index component. The text of the message is obtained from some other server component.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services with the exact error text.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13250: insufficient privileges to modify metadata table entries<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The user requesting the operation does not have the appropriate privileges on the referenced tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that the specified feature and geometry table names are correct, and then verify that the current user has at least SELECT privilege on those tables.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13251: duplicate entry\u00a0string<\/i>\u00a0in metadata table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified entry already exists in the metadata table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that the specified feature and geometry table names are correct. A feature-geometry table association should be registered only once.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13260: layer table\u00a0string<\/i>\u00a0does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Data migration source table\u00a0layer<\/i>_SDOGEOM does not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the specified layer name is correct and that the corresponding spatial layer tables exist in the current schema.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13261: geometry table\u00a0string<\/i>\u00a0does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified geometry table does not exist in the current schema.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a table containing a column of type SDO_GEOMETRY and a column of type NUMBER for the GID values.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13262: geometry column\u00a0string<\/i>\u00a0does not exist in table\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified table does not have a column of type SDO_GEOMETRY.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Alter or re-create the table such that it includes a column of type SDO_GEOMETRY and a column of type NUMBER.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13263: column\u00a0string<\/i>\u00a0in table\u00a0string<\/i>\u00a0is not of type SDO_GEOMETRY<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The column intended for storing the geometry is not of type SDO_GEOMETRY.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Alter the column definition to be of type SDO_GEOMETRY.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13264: geometry identifier column\u00a0string<\/i>\u00a0does not exist in table\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified table does not contain a GID column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Confirm that the GID column name was correctly specified and that it exists in the specified table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13265: geometry identifier column\u00a0string<\/i>\u00a0in table\u00a0string<\/i>\u00a0is not of type NUMBER<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0GID column is not of type NUMBER.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Alter the table definition such that the column containing the geometry identifier (GID) is of type NUMBER.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13266: error inserting data into table\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An OCI error occurred, or the user has insufficient quota in the active tablespace, or the rollback segments are too small.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0There should be an accompanying error message that indicates the cause of the problem. Take appropriate action to correct the indicated problem.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13267: error reading data from layer table\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was an error reading the geometry data from the\u00a0layer<\/i>_SDOGEOM table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that\u00a0layer<\/i>_SDOGEOM and\u00a0layer<\/i>_SDODIM exist. If they do exist, run VALIDATE_LAYER_WITH_CONTEXT on the specified layer.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13268: error obtaining dimension from USER_SDO_GEOM_METADATA<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There is no entry in the USER_SDO_GEOM_METADATA view for the specified geometry table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Insert an entry for the destination geometry table with the correct dimension information.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13269: internal error [string<\/i>] encountered when processing geometry table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An internal error occurred.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services with the exact error message text.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13270: OCI error \\nstring<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An OCI error occurred while processing the layer or geometry tables.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Take the appropriate steps to correct the OCI-specific error.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13271: error allocating memory for geometry object<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Insufficient memory.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make more memory available to the current session\/process.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13272: geometric object\u00a0string<\/i>\u00a0in table\u00a0string<\/i>\u00a0is invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified object failed the geometric integrity checks performed by the validation function.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the Oracle Spatial documentation for information about the geometric integrity checks performed by VALIDATE_GEOMETRY_WITH_CONTEXT and correct the geometry definition if required.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13273: dimension metadata table\u00a0string<\/i>\u00a0does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The\u00a0layer<\/i>_SDODIM table does not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that the specified layer name is correct and that the\u00a0layer<\/i>_SDODIM table exists in the current schema.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13274: operator invoked with non-compatible SRIDs<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A spatial operator was invoked with a window geometry with an SRID but the layer has no SRID; or the window has no SRID but the layer has an SRID.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the layer and window both have an SRID or that they both do not have an SRID.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13275: spatial index creation failure on unsupported type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a spatial index on a column that was not of type SDO_GEOMETRY.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0A spatial index can only be created on a column of type SDO_GEOMETRY. Ensure that the indexed column is of type SDO_GEOMETRY.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13276: internal error [string<\/i>] in coordinate transformation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0OCI internal error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services with the exact error message text.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13278: failure to convert SRID to native format<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0OCI internal error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services with the exact error message text.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13281: failure in execution of SQL statement to retrieve WKT<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0OCI internal error, or SRID does not match a table entry.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that a valid SRID is being used.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13282: failure on initialization of coordinate transformation<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Parsing error on source or destination coordinate system WKT, or incompatible coordinate systems.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the validity of the WKT for table entries, and check if the requested transformation is valid.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13283: failure to get new geometry object for conversion in place<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0OCI internal error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services with the exact error message text.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13284: failure to copy geometry object for conversion in place<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0OCI internal error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services with the exact error message text.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13285: Geometry coordinate transformation error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A coordinate pair was out of valid range for a conversion\/projection.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check that data to be transformed is consistent with the desired conversion\/projection.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13287: can’t transform unknown gtype<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A geometry with a gtype of <= 0 was specified for transformation. Only a gtype >= 1 is allowed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the Oracle Spatial documentation for SDO_GTYPE values, and specify a value whose last digit is 1 or higher.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13288: point coordinate transformation error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An internal error occurred while transforming points.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the accompanying error messages.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13290: the specified unit is not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An Oracle Spatial function was called with an unknown UNIT value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check Spatial documentation for the supported units, and call the function with the correct UNIT parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13291: conversion error between the specified unit and standard unit<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Cannot convert the specified unit from\/to standard unit for linear distance, angle, or area.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the unit specification and respecify it.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13292: incorrect ARC_TOLERANCE specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When a SDO_BUFFER or SDO_AGGR_BUFFER function is called on a geodetic geometry, or SDO_ARC_DENSIFY is called, ARC_TOLERANCE must be specified, and it should not be less than the tolerance specified for the geometry.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the ARC_TOLERANCE specification and ensure that it is correct.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13293: cannot specify unit for geometry without a georeferenced SRID<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An Oracle Spatial function with a UNIT parameter was called on a geometry without a georeferenced SRID.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that spatial functions with UNIT parameters are only called on geometries with georeferenced SRIDs.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13294: cannot transform geometry containing circular arcs<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to transform a 3-point representation of a circular arc without distortion.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that a geometry does not contain circular arcs.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13295: geometry objects are in different coordinate systems<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An Oracle Spatial function was called with two geometries that have different SRIDs.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Transform geometry objects to be in the same coordinate system and call the spatial function.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13296: incorrect coordinate system specification<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Wrong numbers in WKT for Earth radius or flattening for the current SRID.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check WKT in the MDSYS.CS_SRS table for Earth radius and inverse flattening.<\/span><\/span><\/p>\n

\n
<\/a> ORA-13300: single point transform error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Low-level coordinate transformation error trap.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the accompanying error messages.<\/span><\/span><\/p>\n

\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13200 to ORA-13300 ORA-13200: internal error [string] in spatial indexing. Cause:\u00a0This is an internal error. Action:\u00a0Contact Oracle Support Services with the exact error text. ORA-13201: invalid parameters supplied in CREATE INDEX statement Cause:\u00a0An error was encountered while trying to parse the parameters clause for the spatial…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2214","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-zI","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2214"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2214\/revisions"}],"predecessor-version":[{"id":2215,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2214\/revisions\/2215"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2214"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}