Oracle Error ORA-38312: original name is used by an existing object

Oracle Error Message

ORA-38312: original name is used by an existing object

Reason for the Error

An attempt was made to recover an object preserving the original name, but that name is taken up by some other object.

Solution

use the RENAME clause to recover the object with a different name.