ORA-23464: flavor lacks column string of "string"."string"

Cause : The flavor includes some columns of an object group but not all the required columns.

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

Change the flavor definition to include all required columns.

update : 28-07-2017
ORA-23464

ORA-23464 - flavor lacks column string of "string"."string"
ORA-23464 - flavor lacks column string of "string"."string"

  • ora-19564 : error occurred writing string bytes at block number string
  • ora-12713 : Character data loss in NCHAR/CHAR conversion
  • ora-22621 : error transfering an object from the agent
  • ora-19628 : invalid SCN range
  • ora-30364 : this level has the same set of columns as another
  • ora-31401 : change source string is not an existing change source
  • ora-25015 : cannot perform DML on this nested table view column
  • ora-06572 : Function string has out arguments
  • ora-16588 : no more internal buffers
  • ora-00254 : error in archive control string 'string'
  • ora-19045 : character set id specified for XMLSerialize not valid
  • ora-13705 : There was a instance shutdown/startup between the snapshots in the range [string, string].
  • ora-02233 : invalid CLOSE mode
  • ora-19265 : XQ0045 - invalid or unknown prefix string in function declaration
  • ora-30351 : query rewrite does not currently support this expression
  • ora-31453 : invalid value string for parameter, expecting: Y, N, or NULL
  • ora-01769 : duplicate CLUSTER option specifications
  • ora-07251 : spcre: semget error, could not allocate any semaphores.
  • ora-10566 : Test recovery has used all the memory it can use
  • ora-13915 : Critical byte based free space threshold value is greater than warning threshold value.
  • ora-16564 : lookup failed, syntax error at string
  • ora-00082 : memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring
  • ora-07268 : szguns: getpwuid error.
  • ora-01551 : extended rollback segment, pinned blocks released
  • ora-00055 : maximum number of DML locks exceeded
  • ora-32802 : value for string must be string
  • ora-26078 : file "string" is not part of database being loaded
  • ora-09293 : sksasmo: unable to send message to console
  • ora-30431 : refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string
  • ora-30452 : cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)
  • 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.