ORA-23374: object group "string"."string" already exists

Cause : The given database already replicates the given object group. A materialized view repgroup cannot be created at a given site where a master repgroup with the same name already exists.

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

Choose a different group or a different database.

update : 28-05-2017
ORA-23374

ORA-23374 - object group "string"."string" already exists
ORA-23374 - object group "string"."string" already exists

  • ora-31219 : DBMS_LDAP: PL/SQL - Invalid LDAP notypes.
  • ora-19751 : could not create the change tracking file
  • ora-15048 : ASM internal files cannot be deleted
  • ora-06777 : TLI Driver: error reading parms
  • ora-13699 : Advisor feature is not currently implemented.
  • ora-00028 : your session has been killed
  • ora-15053 : diskgroup "string" contains existing files
  • ora-16198 : Timeout incurred on internal channel during remote archival
  • ora-07256 : sptrap: cannot set up signal handler to catch exceptions.
  • ora-36206 : (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.
  • ora-00222 : operation would reuse name of a currently mounted control file
  • ora-25243 : CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string
  • ora-12010 : cannot create materialized view log on table owned by SYS
  • ora-29741 : IMR active for some, but not all members of cluster
  • ora-30750 : cannot enable column string to store objects of type string.string
  • ora-26530 : unable to build materialized view refresh control list
  • ora-31696 : unable to export/import string using client specified string method
  • ora-09805 : conversion of category number to string failed.
  • ora-01565 : error in identifying file 'string'
  • ora-09961 : Unable to restore termination signal handler
  • ora-01690 : sort area size too small
  • ora-27078 : unable to determine limit for open files
  • ora-22612 : TDS does not describe a collection TDS
  • ora-39502 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-28583 : remote references are not permitted during agent callbacks
  • ora-32117 : Source LOB is null
  • ora-07707 : error in archive text: need tape label name
  • ora-14162 : subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-03135 : connection lost contact
  • ora-30512 : cannot modify string.string more than once in a transaction
  • 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.