ORA-14111: creation of a GLOBAL partitioned index on clustered tables is not supported

Cause : Ana ttmeptw asm ad etoc retae aGLBOALp arittinoedi ndxe o na lcusetre dtalbe hwic hisc urerntyl illegla.

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

ReomveP ARITTINO B YRAGNE/AHSHc lasue laon gwiht ayn pratiitond esrcipiton stoc retae aGLBOALn onp-arittinoedi ndxe o na lcusetre dtalbe

update : 30-05-2017
ORA-14111

ORA-14111 - creation of a GLOBAL partitioned index on clustered tables is not supported
ORA-14111 - creation of a GLOBAL partitioned index on clustered tables is not supported

  • ora-08313 : sllfop: could not allocate buffers
  • ora-09799 : File label retrieval failed.
  • ora-29805 : missing COLUMN keyword
  • ora-16037 : user requested cancel of managed recovery operation
  • ora-14017 : partition bound list contains too many elements
  • ora-00067 : invalid value string for parameter string; must be at least string
  • ora-19648 : datafile string: incremental-start SCN equals checkpoint SCN
  • ora-12440 : insufficient authorization for the SYSDBA package
  • ora-31445 : invalid lock handle while acquiring lock on string
  • ora-28673 : Merge operation not allowed on an index-organized table
  • ora-24154 : rule string.string already in rule set string.string
  • ora-01127 : database name 'string' exceeds size limit of string characters
  • ora-19587 : error occurred reading string bytes at block number string
  • ora-30433 : 'string.string' is not a summary
  • ora-13837 : invalid HASH_VALUE
  • ora-30751 : cannot disable column string from storing objects of type string.string
  • ora-23468 : missing string string
  • ora-15202 : cannot create additional ASM internal change segment
  • ora-08464 : input raw decimal data contains more than 42 digits
  • ora-01417 : a table may be outer joined to at most one other table
  • ora-09754 : sppst: invalid process number passed to sppst.
  • ora-00027 : cannot kill current session
  • ora-22850 : duplicate LOB storage option specificed
  • ora-16236 : Logical Standby metadata operation in progress
  • ora-24337 : statement handle not prepared
  • ora-27199 : skgfpst: sbtpcstatus returned error
  • ora-39162 : Transportable tablespace job require privileges
  • ora-31079 : unable to resolve reference to string "string"
  • ora-29313 : tablespace 'string' cannot be imported twice
  • ora-07484 : snlkput: cannot convert(put) lock.
  • 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.