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 : 18-08-2017

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

  • ora-10261 : Limit the size of the PGA heap
  • ora-00601 : cleanup lock conflict
  • ora-12902 : default temporary tablespace must be SYSTEM or of TEMPORARY type
  • ora-01143 : cannot disable media recovery - file string needs media recovery
  • ora-19880 : Corrupted space header for datafile string, block string backup aborted
  • ora-31495 : error in synchronous change table on "string"."string"
  • ora-01932 : ADMIN option not granted for role 'string'
  • ora-32125 : Attribute type is not appropriate
  • ora-02167 : LOGFILE clause specified more than once
  • ora-23303 : application raised generic exception during deferred RPC
  • ora-04087 : cannot change the value of ROWID reference variable
  • ora-02344 : cannot revoke execute on a type with table dependents
  • ora-00956 : missing or invalid auditing option
  • ora-39096 : invalid input value string for parameter string
  • ora-26676 : Table 'string.string' has string columns in the LCR and string columns in the replicated site
  • ora-14453 : attempt to use a LOB of a temporary table, whose data has alreadybeen purged
  • ora-16525 : the Data Guard broker is not yet available
  • ora-14080 : partition cannot be split along the specified high bound
  • ora-12161 : TNS:internal error: partial data received
  • ora-16767 : SQL Apply unexpectedly online
  • ora-14191 : ALLOCATE STORAGE may not be specified for Composite Range partitioned object
  • ora-06263 : NETNTT: out of memory in pi_connect
  • ora-06555 : this name is currently reserved for use by user SYS
  • ora-07511 : sscggtl: $enq unexpected return for master termination lock
  • ora-12076 : invalid threshold value
  • ora-31045 : Cannot store more than string extras outside the root XML node
  • ora-19563 : %s header validation failed for file string
  • ora-24062 : Subscriber table string inconsistent with queue table string
  • ora-30929 : ORDER SIBLINGS BY clause not allowed here
  • ora-04931 : unable to set initial sequence number value
  • 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.