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 : 22-09-2017

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

  • ora-28659 : COMPRESS must be specified at object level first
  • ora-38754 : FLASHBACK DATABASE not started; required redo log is not available
  • ora-01268 : invalid TEMPFILE clause for alter of permanent TABLESPACE
  • ora-00051 : timeout occurred while waiting for a resource
  • ora-09215 : sfqio: error detected in IOCompletionRoutine
  • ora-13189 : recursive SQL parse failed
  • ora-01603 : illegal grouping size in clause "string" of string
  • ora-39214 : Data Pump does not support external tables with encrypted columns. string will not be exported
  • ora-00378 : buffer pools cannot be created as specified
  • ora-40251 : no support vectors were found
  • ora-12471 : Specified compartment or group is not authorized for user
  • ora-31037 : Invalid XML attribute name string
  • ora-33425 : (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.
  • ora-24319 : unable to allocate memory
  • ora-32143 : Environment not specified
  • ora-14159 : duplicate subpartition name
  • ora-16806 : supplemental logging is not turned on
  • ora-01581 : attempt to use rollback segment (string) new extent (string) which is being allocated
  • ora-01205 : not a data file - type number in header is string
  • ora-06548 : no more rows needed
  • ora-13428 : invalid modelCoordinateLocation
  • ora-08499 : Warning: picture mask options 'string' ignored by UTL_PG
  • ora-23404 : refresh group "string"."string" does not exist
  • ora-33018 : (XSAGDNGL08) In AGGMAP workspace object, the data type of workspace object must be TEXT, not string.
  • ora-12414 : internal LBAC error: string Error: string
  • ora-01771 : illegal option for a clustered table
  • ora-19722 : datafile string is an incorrect version
  • ora-01469 : PRIOR can only be followed by a column name
  • ora-38482 : no elementary attributes defined in the attribute set
  • ora-12721 : operation cannot execute when other sessions are active
  • 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.