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 : 25-06-2017

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

  • ora-06561 : given statement is not supported by package DBMS_SQL
  • ora-36708 : (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.
  • ora-30502 : system triggers cannot have INSERT, UPDATE, or DELETE as triggering events
  • ora-01646 : tablespace 'string' is not read only - cannot make read write
  • ora-15190 : Internal ASM testing event number 15190
  • ora-25950 : missing where clause in join index specification
  • ora-23422 : Oracle Server could not generate an unused job number
  • ora-19735 : wrong creation SCN - control file expects initial plugged-in datafile
  • ora-38707 : Media recovery is not enabled.
  • ora-29337 : tablespace 'string' has a non-standard block size (string)
  • ora-12424 : length exceeds binary label size
  • ora-07411 : slgfn: full path name too big for supplied buffer.
  • ora-31191 : Resource string is already checked out
  • ora-36816 : (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts.
  • ora-14409 : inserted partition key is outside specified subpartition
  • ora-13422 : invalid model coordinate parameter
  • ora-02188 : Cannot enable instance publicly
  • ora-02442 : Cannot drop nonexistent unique key
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-00264 : no recovery required
  • ora-21700 : object does not exist or is marked for delete
  • ora-06265 : NETNTT: break protocol error
  • ora-10382 : parallel query server interrupt (reset)
  • ora-24042 : no propagation schedule exists for QUEUE string and DESTINATION string
  • ora-12323 : unable to open database (link name string)
  • ora-30434 : refresh method must be one of FC?AN, not 'string'
  • ora-01150 : cannot prevent writes - file string has online backup set
  • ora-16163 : LGWR network server host attach error
  • ora-26694 : error while enqueueing into queue string.string
  • ora-19805 : recid string of string was deleted to reclaim disk space
  • 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.