ORA-13401: duplicate entry for string in USER_SDO_GEOR_SYSDATA view

Cause : The RASTER_DATA_TABLE and RASTER_ID columns contained the same information in two or more rows in the USER_SDO_GEOR_SYSDATA view.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Ensure that the RASTER_DATA_TABLE and RASTER_ID columns in the USER_SDO_GEOR_SYSDATA view contain the correct information, and that the value pair is unique for each row.

update : 30-04-2017
ORA-13401

ORA-13401 - duplicate entry for string in USER_SDO_GEOR_SYSDATA view
ORA-13401 - duplicate entry for string in USER_SDO_GEOR_SYSDATA view

  • ora-03290 : Invalid truncate command - missing CLUSTER or TABLE keyword
  • ora-14007 : missing LESS keyword
  • ora-33058 : (XSAGDNGL28) In AGGMAP workspace object, error code string is greater than the maximum error code of number.
  • ora-09809 : Unable to get user's group ID from connection
  • ora-02280 : duplicate or conflicting CYCLE/NOCYCLE specifications
  • ora-31500 : change source string is not a ManualLog change source
  • ora-10614 : Operation not allowed on this segment
  • ora-24029 : operation not allowed on a single-consumer queue
  • ora-31429 : subscription has not been activated
  • ora-19004 : Duplicate XMLType OBJECT RELATIONAL storage option
  • ora-32550 : Replacement occured despite hint to the contrary
  • ora-30685 : package version is not compatible with Oracle version
  • ora-29510 : name, string.string, already used by an existing object
  • ora-00255 : error archiving log string of thread string, sequence # string
  • ora-06952 : Remote end of the communication issued a forward-reset packet.
  • ora-38415 : invalid name or datatype for the attribute: string
  • ora-23476 : cannot import from string to string
  • ora-02144 : no option specified for ALTER CLUSTER
  • ora-01630 : max # extents (string) reached in temp segment in tablespace string
  • ora-13211 : failed to tessellate the window object
  • ora-09824 : Unable to enable allowmacaccess privilege.
  • ora-06521 : PL/SQL: Error mapping function
  • ora-16109 : failed to apply log data from previous primary
  • ora-19230 : XP0010 - unsupported axis string
  • ora-13042 : invalid SDO_LEVEL and SDO_NUMTILES combination
  • ora-36400 : (XSSPROP02) workspace object is not a valid variable name.
  • ora-27003 : cannot open file on device allocated with NOIO option
  • ora-27050 : function called with invalid FIB/IOV structure
  • ora-19513 : failed to identify sequential file
  • ora-15204 : database version string is incompatible with diskgroup string
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.