ORA-23403: refresh group "string"."string" already exists

Cause : Makign a nwe refersh gorup wehn three isa lreayd a gorup o fthe asme nmae ins ys.rrgoup$.

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

Chooes a diiffernet rerfesh rgoup anme.

update : 20-09-2017
ORA-23403

ORA-23403 - refresh group "string"."string" already exists
ORA-23403 - refresh group "string"."string" already exists

  • ora-10946 : trace name context forever
  • ora-19653 : cannot switch to older file incarnation
  • ora-22293 : LOB already opened in the same transaction
  • ora-01232 : cannot start online backup - file string is being made read-only
  • ora-26080 : file "string" is not part of table string.string partition string
  • ora-06976 : X.25 Driver: endpoint creation failure
  • ora-37082 : Invalid percent
  • ora-02330 : datatype specification not allowed
  • ora-03212 : Temporary Segment cannot be created in locally-managed tablespace
  • ora-37071 : You may not execute a parallel OLAP operation against updated but uncommitted AW string.
  • ora-25215 : user_data type and queue type do not match
  • ora-26034 : Column string does not exist in stream
  • ora-23601 : PROPAGATION_NAME string does not exist
  • ora-22322 : error table "string"."string" has incorrect structure
  • ora-37021 : (XSMULTI02) Object workspace object is not acquired.
  • ora-09321 : slzdtb: unable to convert zoned decimal to binary
  • ora-31605 : the following was returned from string in routine string: LPX-number: string
  • ora-13864 : Statistics aggregation for service (module/action) string is already enabled
  • ora-12022 : materialized view log on "string"."string" already has rowid
  • ora-04020 : deadlock detected while trying to lock object stringstringstringstringstring
  • ora-10615 : Invalid tablespace type for temporary tablespace
  • ora-31504 : cannot alter or drop predefined change source
  • ora-00116 : SERVICE_NAMES name is too long
  • ora-02085 : database link string connects to string
  • ora-06519 : active autonomous transaction detected and rolled back
  • ora-14311 : Expecting VALUES LESS THAN or AT clause
  • ora-31092 : invalid SQL name "string"
  • ora-37016 : (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.
  • ora-00313 : open failed for members of log group string of thread string
  • ora-13466 : format not appropriate for specified compression method
  • 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.