ORA-23332: group string is in use; cannot drop

Cause : The given column group or priority group is being used to resolve conflicts.

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

Call dbms_repcat procedures drop_update_resolution, drop_delete_resolution, drop_unique_resolution so that the column group or priority group is no longer in use before dropping.

update : 26-05-2017

ORA-23332 - group string is in use; cannot drop
ORA-23332 - group string is in use; cannot drop

  • ora-32128 : setDataBuffer called after fetch has started
  • ora-02278 : duplicate or conflicting MAXVALUE/NOMAXVALUE specifications
  • ora-09879 : sstascre/sstasat: shmat error, unable to attach tas read page
  • ora-29388 : plan/consumer_group string is part of more than one top-plan
  • ora-01237 : cannot extend datafile string
  • ora-38104 : Columns referenced in the ON Clause cannot be updated: string
  • ora-30685 : package version is not compatible with Oracle version
  • ora-15101 : no action specified
  • ora-06957 : No SID is currently available
  • ora-02491 : missing required keyword ON or OFF in AUTOEXTEND clause
  • ora-38426 : attribute set assigned to an expression set may not be dropped
  • ora-26683 : invalid value for value_type
  • ora-38852 : cannot mark the current instance (redo thread) as disabled
  • ora-16031 : parameter string destination string exceeds string character limit
  • ora-29821 : specified primary operator does not exist
  • ora-23348 : cannot replicate procedure string; only IN parameters supported
  • ora-16653 : failed to reinstate database
  • ora-14269 : cannot exchange partition other than a Range or Hash partition
  • ora-29860 : cannot truncate a table with domain indexes marked LOADING
  • ora-00253 : character limit string exceeded by archive destination string string
  • ora-33064 : (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.
  • ora-12228 : TNS:protocol adapter not loadable
  • ora-01153 : an incompatible media recovery is active
  • ora-10925 : trace name context forever
  • ora-32052 : failed to start mapping service
  • ora-06707 : TLI Driver: connection failed
  • ora-12662 : proxy ticket retrieval failed
  • ora-03298 : cannot shrink datafile - file string is under hot backup
  • ora-09351 : Windows 32-bit Two-Task driver unable to allocate shared memory
  • ora-31631 : privileges are required
  • 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.