ORA-23457: invalid flavor ID string

Cause : The given flavor ID is invalid.

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

Make sure this flavor has been instantiated. If the flavor ID is outside the range (-2147483647, 2147483647), contact customer support.

update : 22-08-2017
ORA-23457

ORA-23457 - invalid flavor ID string
ORA-23457 - invalid flavor ID string

  • ora-29508 : query derived from USING clause did not select a value of type string
  • ora-07753 : slemcf: fseek before write failure
  • ora-24342 : unable to destroy a mutex
  • ora-02772 : Invalid maximum server idle time
  • ora-09801 : Unable to get user ID from connection
  • ora-31619 : invalid dump file "string"
  • ora-00237 : snapshot operation disallowed: control file newly created
  • ora-10389 : parallel query server interrupt (cleanup)
  • ora-32129 : cannot get information about this column
  • ora-13708 : Some snapshots in the range [string, string] were purged before the analysis was complete.
  • ora-00474 : SMON process terminated with error
  • ora-14290 : PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-13055 : Oracle object string does not exist in specified table
  • ora-39753 : unsupported use of subquery in PARTITIONED OUTER JOIN condition
  • ora-13415 : invalid or out of scope point specification
  • ora-32300 : cannot drop a secondary materialized view "string"."string"
  • ora-16551 : short string copied
  • ora-08456 : no sign in picture mask but SIGN clause in mask options
  • ora-38604 : FI including & excluding cursor item-id type must match input cursor item-id type
  • ora-19247 : XQ0027 - validation error
  • ora-32051 : mapping service not available
  • ora-06517 : PL/SQL: Probe error - string
  • ora-01204 : file number is string rather than string - wrong file
  • ora-02352 : file truncated error
  • ora-30086 : interval year-month result not allowed for datetime subtraction
  • ora-25446 : duplicate column value for table alias: string, column: string
  • ora-08317 : sllfsk: Error seeking in file.
  • ora-19268 : XQ0048 - namespace string does not match target namespace string
  • ora-16819 : Fast-Start Failover observer not started
  • ora-07403 : sfanfy: db_writers parameter not valid.
  • 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.