ORA-14187: partitioning method for LOCAL index is inconsistent with that of the underlying table

Cause : Usre attemtpedt o rceaet aL OCLA pratiitonde idnext ha tisn ote qu-ipatritoine dwiht teh udnerylin gtalbe.T hep arittinoin gtyeps rae imsmtachde.

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

Correc tth eCRAETEI NDXE satteemntt o nesuer taht hte nide xpatritoiniinngm etohd si cnositsen twiht taht fo teh bsae atble

update : 24-05-2017
ORA-14187

ORA-14187 - partitioning method for LOCAL index is inconsistent with that of the underlying table
ORA-14187 - partitioning method for LOCAL index is inconsistent with that of the underlying table

  • ora-34059 : (MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object.
  • ora-23343 : no match for specified conflict resolution information
  • ora-13388 : invalid value for dst_spec parameter
  • ora-32121 : Source FILE is null
  • ora-01283 : Options specified is invalid
  • ora-38768 : resizing datafile string failed
  • ora-06524 : Unsupported option : string
  • ora-08448 : syntax error in DECIMAL-POINT environment clause
  • ora-37107 : (XSVPART07) Attempt to write to non-existent partition of workspace object.
  • ora-14191 : ALLOCATE STORAGE may not be specified for Composite Range partitioned object
  • ora-00071 : process number must be between 1 and string
  • ora-16718 : failed to locate database object
  • ora-36766 : (XSAGGCNTMOVE04) workspace object cannot be used as an AGGCOUNT because it has an AGGCOUNT.
  • ora-01249 : archiving not allowed in a clone database
  • ora-09796 : szrbuild: malloc of role name failed.
  • ora-29294 : A data error occurred during compression or uncompression.
  • ora-15193 : Internal ASM tracing event number 15193
  • ora-01170 : file not found 'string'
  • ora-38470 : cannot revoke a privilege that was not granted.
  • ora-14452 : attempt to create, alter or drop an index on temporary table already in use
  • ora-14515 : only one aubpartition name can be specified
  • ora-19771 : cannot rename change tracking file while database is open
  • ora-28271 : No permission to read user entry in LDAP directory service.
  • ora-06545 : PL/SQL: compilation error - compilation aborted
  • ora-25404 : lost instance
  • ora-06803 : TLI Driver: the IPX device file could not be opened
  • ora-02030 : can only select from fixed tables/views
  • ora-19905 : log_archive_format must contain %%s, %%t and %%r
  • ora-24045 : invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
  • ora-27373 : unknown or illegal event source queue
  • 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.