ORA-13047: unable to determine ordinate count from table _SDOLAYER

Cause : An SOD_GEO Mfunciton wsa unalbe tod eterimne teh numebr ofo rdintaes fro theS DO lyaer .

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

Veriyf tha tthe lSDOLYAER tbale hsa a vlaid vlaue fro thec olum nSDO_RODCNT .Thenr etryt he oepratino.

update : 29-04-2017
ORA-13047

ORA-13047 - unable to determine ordinate count from table _SDOLAYER
ORA-13047 - unable to determine ordinate count from table _SDOLAYER

  • ora-26689 : column datatype mismatch in LCR
  • ora-38497 : Expression Filter index does not exist
  • ora-08121 : Number of indexes need to be maintained offline exceeds limit for DML
  • ora-14187 : partitioning method for LOCAL index is inconsistent with that of the underlying table
  • ora-32129 : cannot get information about this column
  • ora-14409 : inserted partition key is outside specified subpartition
  • ora-38732 : Expected file size string does not match string.
  • ora-13861 : Statistics aggregation for client identifier string is already enabled
  • ora-08103 : object no longer exists
  • ora-31160 : max substitution group size string exceeded by "string" (string) for head element "string" (string)
  • ora-13628 : Insufficient privileges to access the task belonging to the specified user
  • ora-24007 : invalid value string, MAX_RETRIES should be non-negative integer
  • ora-30460 : 'string.string' cannot be refreshed because it is marked UNUSABLE
  • ora-01327 : failed to exclusively lock system dictionary as required by build
  • ora-36986 : (XSRELGID05) Relation workspace object must be dimensioned by workspace object.
  • ora-24059 : invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string
  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-24315 : illegal attribute type
  • ora-02225 : only EXECUTE and DEBUG privileges are valid for procedures
  • ora-03135 : connection lost contact
  • ora-30462 : unsupported operator: string
  • ora-19625 : error identifying file string
  • ora-30186 : '' must be followed by four hexdecimal characters or another ''
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • ora-07227 : rtneco: unable to set noecho mode.
  • ora-04046 : results of compilation are too large to support
  • ora-19268 : XQ0048 - namespace string does not match target namespace string
  • ora-28041 : Authentication protocol internal error
  • ora-14029 : GLOBAL partitioned index must be prefixed
  • ora-27468 : "string.string" is locked by another process
  • 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.