ORA-23467: flavor lacks object "string"."string"

Cause : Teh lfaovrd ose onti nlcued htes pceiife dojbetc hwihc si ebign rdoppe.d

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

Cehc ktahtt h esepcfiide bojceti sc orretc.

update : 24-04-2017

ORA-23467 - flavor lacks object "string"."string"
ORA-23467 - flavor lacks object "string"."string"

  • ora-09767 : osnmfs: bad return code from msg_send.
  • ora-22605 : FDO handle [string] is not initialized
  • ora-23601 : PROPAGATION_NAME string does not exist
  • ora-16636 : Fast-Start Failover target standby in error state, cannot stop observer
  • ora-27545 : Fail to prepare buffer for remote update
  • ora-14021 : MAXVALUE must be specified for all columns
  • ora-07702 : unrecognized device type in archive text
  • ora-32814 : propagation schedule string does not exist
  • ora-32408 : materialized view log on "string"."string" already has new values
  • ora-12527 : TNS:listener: all instances are in restricted mode or blocking new connections
  • ora-12443 : policy not applied to some tables in schema
  • ora-06403 : Unable to allocate memory.
  • ora-00018 : maximum number of sessions exceeded
  • ora-29860 : cannot truncate a table with domain indexes marked LOADING
  • ora-02463 : Duplicate HASH IS option specified
  • ora-22990 : LOB locators cannot span transactions
  • ora-23612 : unable to find tablespace "string"
  • ora-02704 : osndopop: fork failed
  • ora-37135 : (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-22615 : attribute is not a collection
  • ora-01148 : cannot refresh file size for datafile string
  • ora-02453 : duplicate HASH IS specification
  • ora-25307 : Enqueue rate too high, flow control enabled
  • ora-06742 : TLI Driver: cannot alloc t_bind
  • ora-31506 : duplicate subscription name string
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-02198 : ONLINE/OFFLINE option already specified
  • ora-24850 : failed to startup shared subsystem
  • ora-27435 : chain job terminated abnormally
  • ora-14329 : domain index [sub]partitions cannot be renamed in this clause
  • 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.