Oracle Database Errors or Warnings from Error ORA-23328 to ORA-23337

SQLServerF1

ORA-23328: mview base table “string”.”string” differs from master table “string”.”string”
Cause: When creating a materialized view through repcat, the materialized view base table name did not match a replicated table name at the master.
Action: Change the materialized view ddl to use the same base table as the replicated table name at the master.
ORA-23329: successful user-provided ddl but no materialized view “string”.”string”
Cause: The DDL provided by the user to create a materialized view was executed without error, but materialized view does not exist.
Action: Manually back-out the DDL, and reregister with matching ddl and materialized view.
ORA-23330: column group string already exists
Cause: The column group was already registered in the object group.
Action: Use a column group name not yet registered in the replicated object group.

ORA-23331: column group string does not exist
Cause: The given column group is either null, misspelled or not registered.
Action: Use a registered column group.
ORA-23332: group string is in use; cannot drop
Cause: The given column group or priority group is being used to resolve conflicts.
Action: 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.
ORA-23333: column string is already part of a column group
Cause: Attempted to add a column to a column group when the column was already a member of a column group.
Action: Drop the column from its existing column group before trying to add it to another.

ORA-23334: column string does not exist in table or column group
Cause: The given column is either null, misspelled or is not part of the given table or column group.
Action: Use a column that is a member of the table or column group.
ORA-23335: priority group string already exists
Cause: The priority group was already registered in the object group.
Action: Use a column group name not yet registered in the object group.
ORA-23336: priority group string does not exist
Cause: The priority group was already registered in the object group.
Action: Use a priority group name not yet registered in the object group.
ORA-23337: priority or value not in priority group string
Cause: The specified value or priority has not been registered as part of the priority group.
Action: Either specify a different value or priority that is already part of the priority group, or add the value to the priority group.

Above are list of Oracle Database Errors or Warnings from Error ORA-23328 to ORA-23337 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *