ORA-13268: error obtaining dimension from USER_SDO_GEOM_METADATA

Cause : Theer isn o etnry ni th eUSE_RSDOG_EOMM_ETAADTA ivew ofr teh spceifide gemoetr ytabel.

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

Insret a nentyr fo rthed estniatino gemoetr ytabel wiht th ecorerct idmenison niforamtio.n

update : 23-08-2017
ORA-13268

ORA-13268 - error obtaining dimension from USER_SDO_GEOM_METADATA
ORA-13268 - error obtaining dimension from USER_SDO_GEOM_METADATA

  • ora-36810 : (XSTBLFUNC05) Analytic workspace object number does not exist.
  • ora-16593 : XML conversion failed
  • ora-13635 : The value provided for parameter string cannot be converted to a number.
  • ora-19640 : datafile checkpoint is SCN string time string
  • ora-29539 : Java system classes already installed
  • ora-24077 : cannot create propagation schedule for EXCEPTION queue string.string
  • ora-13515 : Error encountered during Database Usage Statistics capture
  • ora-16235 : DDL skipped because import has occurred
  • ora-19251 : XQ0031 - unsupported query version
  • ora-04082 : NEW or OLD references not allowed in table level triggers
  • ora-09823 : device name is too long
  • ora-28048 : database is a member of multiple enterprise domains in OID
  • ora-22994 : source offset is beyond the end of the source LOB
  • ora-26059 : Data is too large for column string
  • ora-32165 : Cannot get XA environment
  • ora-00260 : cannot find online log sequence string for thread string
  • ora-32516 : cannot wait for ORADEBUG command completion; waited number ms for process string
  • ora-16122 : applying large dml transaction at SCN string
  • ora-08274 : Out of memory for environment variable
  • ora-29518 : name string resolved to an object in schema string that is not a Java class
  • ora-00060 : deadlock detected while waiting for resource
  • ora-01222 : MAXINSTANCES of string requires MAXLOGFILES be at least string, not string
  • ora-14017 : partition bound list contains too many elements
  • ora-07265 : sppst: semop error, unable to increment semaphore.
  • ora-00202 : control file: 'string'
  • ora-31607 : function string is inconsistent with transform.
  • ora-07486 : scg_get_inst: cannot convert(get) instance number lock.
  • ora-06561 : given statement is not supported by package DBMS_SQL
  • ora-22065 : number to text translation for the given format causes overflow
  • ora-01509 : specified name 'string' does not match actual '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.