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 : 22-09-2017
ORA-23332

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

  • ora-21500 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-12229 : TNS:Interchange has no more free connections
  • ora-22835 : Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string)
  • ora-07261 : spdde: kill error, unable to send signal to process.
  • ora-12702 : invalid NLS parameter string used in SQL function
  • ora-01466 : unable to read data - table definition has changed
  • ora-09753 : spwat: invalid process number.
  • ora-12004 : REFRESH FAST cannot be used for materialized view "string"."string"
  • ora-29838 : insufficient privileges to execute the operator(s)
  • ora-09817 : Write to audit file failed.
  • ora-39213 : Metadata processing is not available
  • 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-16561 : cannot remove an active instance
  • ora-28221 : REPLACE not specified
  • ora-23319 : parameter value string is not appropriate
  • ora-32814 : propagation schedule string does not exist
  • ora-33338 : (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.
  • ora-14072 : fixed table may not be truncated
  • ora-08115 : can not online create/rebuild this index type
  • ora-06255 : NETNTT: cannot read pid of remote process
  • ora-01079 : ORACLE database was not properly created, operation aborted
  • ora-12685 : Native service required remotely but disabled locally
  • ora-19106 : invalid XQueryX: expected string - got string
  • ora-26709 : Streams RFS restart
  • ora-31690 : Process name buffer size must be specified and must be greater than 0.
  • ora-24397 : error occured while trying to free connections
  • ora-31451 : invalid value string for capture_values, expecting: OLD, NEW, or BOTH
  • ora-13763 : illegal ranking attribute "string"
  • ora-07759 : slemtr: invalid destination
  • ora-03261 : the tablespace string has only one file
  • 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.