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 : 25-09-2017

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

  • ora-01126 : database must be mounted in this instance and not open in any instance
  • ora-36341 : (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template)
  • ora-02391 : exceeded simultaneous SESSIONS_PER_USER limit
  • ora-14259 : table is not partitioned by Hash method
  • ora-25222 : enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
  • ora-24067 : exceeded maximum number of subscribers for queue string
  • ora-37104 : (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-28662 : IOT index and overflow segments must share the same LOGGING attribute
  • ora-29824 : operator is invalid
  • ora-27418 : syntax error in repeat interval or calendar
  • ora-09714 : Two Task interface: cannot obtain puname
  • ora-15056 : additional error message
  • ora-19033 : schema specified in the XML document does not match the schema parameter
  • ora-30178 : duplicate flag used in a format specification
  • ora-02475 : maximum cluster chain block count of string has been exceeded
  • ora-25327 : Array size is invalid
  • ora-24328 : illegal attribute value
  • ora-36999 : (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specified when creating any non-surrogate grouping id.
  • ora-02766 : Invalid maximum of request descriptors
  • ora-28527 : Heterogeneous Services datatype mapping error
  • ora-06504 : PL/SQL: Return types of Result Set variables or query do not match
  • ora-19714 : length for generated name longer than string
  • ora-16172 : archive logs detected beyond Terminal End-Of-Redo
  • ora-30738 : object "string" does not exist in schema "string"
  • ora-28232 : invalid input length for obfuscation toolkit
  • ora-12618 : TNS:versions are incompatible
  • ora-13239 : sdo_dimensionality not specified during n-d R-tree creation
  • ora-02264 : name already used by an existing constraint
  • ora-30550 : index depends on a package/function spec/body which is not valid
  • 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.