ORA-29383: all leaves of top-plan string must be consumer groups

Cause : nAa ttmetpw sam da eotc erta erom dofi yht epscefiei dot-plpnab tui tah sosemp alsna selvase.

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

oTi edtnfi yhwci hlpna sna/drop al nidertcvisen ee dotb eomidifde ,olkoa tla llpna shttah va eonp al nidertcvise .hTne ,laet rht eot-plpnas ohttaa lli stl aeev sra eocsnmureg orpu.s

update : 29-06-2017
ORA-29383

ORA-29383 - all leaves of top-plan string must be consumer groups
ORA-29383 - all leaves of top-plan string must be consumer groups

  • ora-27473 : argument string does not exist
  • ora-14026 : PARTITION and CLUSTER clauses are mutually exclusive
  • ora-13200 : internal error [string] in spatial indexing.
  • ora-30340 : illegal dimension name
  • ora-32803 : value for string cannot be altered
  • ora-13616 : The current user string has not been granted the ADVISOR privilege.
  • ora-38474 : attribute set may not have attributes of TABLE COLLECTION type.
  • ora-25293 : Lob attributes must be null for buffered operations
  • ora-02831 : Segment deallocation failed - empty segment list
  • ora-00401 : the value for parameter string is not supported by this release
  • ora-19266 : XQ0046 - invalid URI
  • ora-27069 : attempt to do I/O beyond the range of the file
  • ora-13834 : name of SQL profile to be cloned must be provided
  • ora-12606 : TNS: Application timeout occurred
  • ora-02495 : cannot resize file string, tablespace string is read only
  • ora-12061 : invalid ALTER MATERIALIZED VIEW option
  • ora-30061 : Internal Event for Savepoint Tracing
  • ora-31052 : Cannot delete ACL with other references
  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • ora-19761 : block size string is not valid for change tracking file
  • ora-22998 : CLOB or NCLOB in multibyte character set not supported
  • ora-38740 : Usable blocks value string is not valid.
  • ora-26736 : Data Pump error
  • ora-29381 : plan/consumer_group string referred to by another plan and cannot be deleted
  • ora-39091 : unable to determine logical standby and streams status
  • ora-00285 : TIME not given as a string constant
  • ora-02801 : Operations timed out
  • ora-31661 : there are no metadata transform values of type VARCHAR2
  • ora-27032 : failed to obtain file size limit
  • ora-13750 : User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.
  • 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.