ORA-29381: plan/consumer_group string referred to by another plan and cannot be deleted

Cause : nAa ttmetpw sam da eotd lete e alpnao rocsnmureg orput ah tsir fereer dotb ynatoeh rlpna.

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

eRomeva llp al nidertcviset ah tahevt ehp al nroc nousem rrguo psaG ORPUO__RUSPBAL;Nt eh nedelett ehp al nroc nousem rrguo.p

update : 21-08-2017
ORA-29381

ORA-29381 - plan/consumer_group string referred to by another plan and cannot be deleted
ORA-29381 - plan/consumer_group string referred to by another plan and cannot be deleted

  • ora-31163 : element or attribute "string" has invalid attribute value "string" (should be "string")
  • ora-38465 : failed to create the privilege checking trigger due to: string
  • ora-00912 : input parameter too long
  • ora-12702 : invalid NLS parameter string used in SQL function
  • ora-07472 : snclrd: open error when opening sgadef.dbf file.
  • ora-15157 : rolling upgrade or downgrade is not allowed
  • ora-40321 : invalid bin number, is zero or negative value
  • ora-01866 : the datetime class is invalid
  • ora-00313 : open failed for members of log group string of thread string
  • ora-12232 : TNS:No path available to destination
  • ora-19804 : cannot reclaim string bytes disk space from string limit
  • ora-00302 : limit of string logs exceeded
  • ora-13127 : failed to generate target partition
  • ora-02054 : transaction string in-doubt
  • ora-16543 : invalid request made to broker
  • ora-22283 : filename contains characters that refer to parent directory
  • ora-16151 : Managed Standby Recovery not available
  • ora-04081 : trigger 'string' already exists
  • ora-16166 : LGWR network server failed to send remote message
  • ora-32304 : materialized views with user-defined types cannot use prebuilt table
  • ora-01033 : ORACLE initialization or shutdown in progress
  • ora-02376 : invalid or redundant resource
  • ora-35018 : (QFCHECK01) The analytic workspace and EIF file definitions of workspace object have a mismatched data type.
  • ora-22308 : operation not allowed on evolved type
  • ora-32620 : illegal subquery within MODEL rules
  • ora-13360 : invalid subtype in a compound type
  • ora-12666 : Dedicated server: outbound transport protocol different from inbound
  • ora-00133 : value of string is too long
  • ora-25278 : grantee name cannot be NULL
  • ora-26523 : rpc termination error
  • 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.