ORA-21614: constraint violation for attribute number [string]

Cause : Constraints on the attribute were violated

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

Correct the value (of the attribute) so that it satisfies constraints

update : 30-04-2017
ORA-21614

ORA-21614 - constraint violation for attribute number [string]
ORA-21614 - constraint violation for attribute number [string]

  • ora-07200 : slsid: oracle_sid not set.
  • ora-36212 : (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.
  • ora-19244 : XQ0024 - invalid attribute node in element constructor
  • ora-31070 : Invalid database user ID string
  • ora-28279 : Error reading ldap_directory_access init parameter.
  • ora-29383 : all leaves of top-plan string must be consumer groups
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-01311 : Illegal invocation of the mine_value function
  • ora-30959 : The indexed column is not stored in CLOB.
  • ora-14602 : SUBPARTITION TEMPLATE is legal only for a composite partitioned table
  • ora-02332 : cannot create index on attributes of this column
  • ora-01904 : DATAFILE keyword expected
  • ora-32504 : expecting one of string, string, string, or string but found string
  • ora-19951 : cannot modify control file until DBNEWID is completed
  • ora-36840 : (XSLMGEN10) Cube string.string!string has no measures
  • ora-01151 : use media recovery to recover block, restore backup if needed
  • ora-39702 : database not open for UPGRADE or DOWNGRADE
  • ora-36635 : (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
  • ora-12210 : TNS:error in finding Navigator data
  • ora-30033 : Undo tablespace cannot be specified as default user tablespace
  • ora-22907 : invalid CAST to a type that is not a nested table or VARRAY
  • ora-32761 : Turn off Temp LOB Ref Count Feature
  • ora-06400 : NETCMN: No default host string specified
  • ora-02174 : Missing required thread number
  • ora-19116 : too many xmlspace declarations
  • ora-13625 : %s is an invalid advisor object type.
  • ora-26099 : direct path context is already prepared
  • ora-36956 : (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.
  • ora-30555 : global index partitioning key is an expression
  • ora-25269 : cant specify sognature with get signature option
  • 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.