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 : 25-04-2017

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

  • ora-22982 : cannot create sub-view under this view
  • ora-19019 : Invalid context passed to DBMS_XMLGEN.GETXML
  • ora-13767 : End snapshot ID must be greater than or equal to begin snapsho ID.
  • ora-37071 : You may not execute a parallel OLAP operation against updated but uncommitted AW string.
  • ora-30089 : missing or invalid
  • ora-09835 : addCallback: callback port is already in a set.
  • ora-00070 : command string is not valid
  • ora-01332 : internal Logminer Dictionary error
  • ora-19108 : WHITESPACE keyword expected
  • ora-14186 : number of sub-partitions of LOCAL index must equal that of the underlying table
  • ora-28551 : pass-through SQL: SQL parse error
  • ora-23394 : duplicate propagator
  • ora-19924 : there are no row with id string
  • ora-16013 : log string sequence# string does not need archiving
  • ora-16154 : suspect attribute: string
  • ora-13206 : internal error [string] while creating the spatial index
  • ora-27487 : invalid object privilege for a string
  • ora-09983 : skxfidsht: Error shutting down SDI channel
  • ora-14153 : only one of STORE IN or clause may be specified
  • ora-30002 : SYS_CONNECT_BY_PATH function is not allowed here
  • ora-01881 : timezone region id number is invalid
  • ora-23333 : column string is already part of a column group
  • ora-00216 : control file could not be resized for migration from 8.0.2
  • ora-14251 : Specified subpartition does not exist
  • ora-16703 : cannot set property while the database is enabled
  • ora-03261 : the tablespace string has only one file
  • ora-29289 : directory access denied
  • ora-00161 : transaction branch length string is illegal (maximum allowed string)
  • ora-14037 : partition bound of partition "string" is too high
  • ora-22864 : cannot ALTER or DROP LOB indexes
  • 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.