How to fix the Oracle error ORA-47220: Label string for Identity string.string under OLS Policy string already defined?

In this post, you’ll learn more about the Oracle ErrorORA-47220: Label string for Identity string.string under OLS Policy string already defined with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-47220: Label string for Identity string.string under OLS Policy string already defined

Reason for the Error ORA-47220: Label string for Identity string.string under OLS Policy string already defined

The object with this name exists already

How to fix the Error ORA-47220: Label string for Identity string.string under OLS Policy string already defined ?

You can fix this error in Oracle by following the below steps

Choose a unique object name and retry the operation