ORA-23459: flavor string must contain "string"

Cause : The flavor must contain the given object, column, or attribute.

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

Either choose a different database flavor or ensure the object, column, or attribute is available.

update : 26-09-2017

ORA-23459 - flavor string must contain "string"
ORA-23459 - flavor string must contain "string"

  • ora-38432 : EVALUATE operator only allowed on an expression column
  • ora-12546 : TNS:permission denied
  • ora-16058 : standby database instance is not mounted
  • ora-37133 : (XSCCOMP08) You cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the CLEAR AGGREGATES command to reenable write access.
  • ora-31669 : Worker process string violated startup protocol.
  • ora-16023 : system string destination cannot be the same as session string destination
  • ora-16088 : archive log has not been completely archived
  • ora-01158 : database string already mounted
  • ora-25200 : invalid value string, QUEUE_NAME should be [SCHEMA.]NAME
  • ora-02846 : Unkillable server
  • ora-02465 : Inappropriate use of the HASH IS option
  • ora-12319 : database (link name string) is already open
  • ora-26663 : error queue for apply process string must be empty
  • ora-31427 : publication string already subscribed
  • ora-39105 : Master process string failed during startup. Master error:
  • ora-12491 : DBHIGH value does not dominate DBLOW
  • ora-16608 : one or more databases have warnings
  • ora-37040 : (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
  • ora-03233 : unable to extend table string.string subpartition string by string in tablespace string
  • ora-13511 : invalid INTERVAL string, must be in the range (string, string)
  • ora-12054 : cannot set the ON COMMIT refresh attribute for the materialized view
  • ora-28002 : the password will expire within string days
  • ora-31431 : all source tables must belong to the synchronous change set
  • ora-22800 : invalid user-defined type
  • ora-01931 : cannot grant string to a role
  • ora-10706 : Print out information about global enqueue manipulation
  • ora-13786 : missing SQL text of statement object "string" for tuning task "string"
  • ora-25015 : cannot perform DML on this nested table view column
  • ora-37006 : (AWLISTALL04) number writers
  • ora-03292 : Table to be truncated is part of a cluster
  • 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.