In this post, you’ll learn more about the Oracle ErrorORA-23309: object string.string of type string exists with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-23309: object string.string of type string exists
Reason for the Error ORA-23309: object string.string of type string exists
An object in the same namespace exists, perhaps with a different type or shape, or the same object has already been registered as an repobject in another object group.
How to fix the Error ORA-23309: object string.string of type string exists ?
You can fix this error in Oracle by following the below steps
Remove the offending object with the SQL DROP command, unregister the offending object with dbms_repcat.drop_master_repobject(), or reinvoke the request using TRUE for a boolean parameter such as retry or use_existing_object.