ORA-23458: inappropriate flavor string at string

Cause : The given flavor at the given database prevents the operation from succeeding.

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

Either change the database flavor or choose a different operation.

update : 25-04-2017

ORA-23458 - inappropriate flavor string at string
ORA-23458 - inappropriate flavor string at string

  • ora-12046 : cannot use trusted constraints for refreshing remote MV
  • ora-19764 : database id string does not match database id string in control file
  • ora-28664 : a partitioned table may not be coalesced as a whole
  • ora-31092 : invalid SQL name "string"
  • ora-32155 : Anydata not specified
  • ora-09200 : sfccf: error creating file
  • ora-08194 : Flashback Table operation is not allowed on materialized views
  • ora-33082 : (XSAGDNGL41) In AGGMAP workspace object, the non-dimensioned valueset workspace object must have a parent QDR in its VALUESET statement over the VALUESET's base dimension.
  • ora-38792 : encountered unknown flashback record from release string
  • ora-13032 : Invalid NULL SDO_GEOMETRY object
  • ora-12505 : TNS:listener does not currently know of SID given in connect descriptor
  • ora-03296 : cannot resize datafile - file string not found
  • ora-32815 : message system link string is referenced by a foreign queue
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-01326 : compatability of 9.0 or greater required to build into the logstream
  • ora-39091 : unable to determine logical standby and streams status
  • ora-08449 : invalid numeric symbol found in picture mask
  • ora-24272 : initialization value must be either F or T
  • ora-12551 : TNS:missing keyword
  • ora-12632 : Role fetch failed
  • ora-31658 : specifying a schema name requires a table name
  • ora-25283 : either agent's name or address needed for non-repudiation
  • ora-19226 : XP0006 - XQuery dynamic type mismatch: expected string got string
  • ora-01648 : log string is the current log of disabled instance string (thread string)
  • ora-36838 : (XSLMGEN08) Dimension string.string!string attribute string is missing a COLUMNNAME property value
  • ora-28278 : No domain policy registered for password based GLOBAL users.
  • ora-36841 : (XSLMGEN11) Dimension string.string!string was not found
  • ora-00083 : warning: possibly corrupt SGA mapped
  • ora-07757 : slemcc: invalid handle
  • ora-30965 : fragment does not fit into the VARCHAR2 VALUE column
  • 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.