ORA-14129: INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints

Cause : Matcihng UINQUE ocnstriants ni bot htabl eare neable dand avlidaetd bu tINCLDUING NIDEXE Sis nto speicfiedi n ALETR TALBE EXHCANGEP ARTIITON|SBUPARTTIION ocmman.d

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

Disalbe currentl yenabeld macthingU NIQU Econsrtaint son btoh talbes o rensuer tha tINCLDUING NIDEXE Soptino is sued.

update : 23-05-2017
ORA-14129

ORA-14129 - INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints
ORA-14129 - INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints

  • ora-38464 : expression set is not empty.
  • ora-30085 : syntax error was found in overlaps predicate
  • ora-13842 : no SELECT privilege on DBA_SQL_PROFILES
  • ora-28590 : agent control utility: illegal or badly formed command
  • ora-10564 : tablespace string
  • ora-02403 : plan table does not have correct format
  • ora-29656 : Invalid option for USING
  • ora-06320 : IPA: Remote maximum number of connections exceeded
  • ora-32314 : REFRESH FAST of "string"."string" unsupported after deletes/updates
  • ora-02284 : duplicate INCREMENT BY specifications
  • ora-36634 : (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.
  • ora-31198 : Mismatch in number of bytes transferred due to non-binary mode
  • ora-06955 : Number of database servers exceed limit
  • ora-01618 : redo thread string is not enabled - cannot mount
  • ora-19711 : cannot use reNormalizeAllFileNames while database is open
  • ora-23621 : Operation corresponding to script string is in progress.
  • ora-07286 : sksagdi: cannot obtain device information.
  • ora-26018 : Column string in table string does not exist
  • ora-08265 : create_ora_addr: cannot open nameserver
  • ora-14028 : missing AT or VALUES keyword
  • ora-07234 : slemcw: fseek error.
  • ora-13042 : invalid SDO_LEVEL and SDO_NUMTILES combination
  • ora-38740 : Usable blocks value string is not valid.
  • ora-01230 : cannot make read only - file string is offline
  • ora-06576 : not a valid function or procedure name
  • ora-34726 : (NLSCHARSET06) CAUTION: String truncated during character set conversion from string to string
  • ora-28363 : buffer provided not large enough for output
  • ora-12601 : TNS:information flags check failed
  • ora-01679 : database must be mounted EXCLUSIVE and not open to activate
  • ora-25001 : cannot create this trigger type on views
  • 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.