Oracle Error ORA-42295: schema synonym name conflicts with another user, role or schema synonym name

Oracle Error Message

ORA-42295: schema synonym name conflicts with another user, role or schema synonym name

Reason for the Error

There was already a user, role or schema synonym with that name.

Solution

Specify a different schema synonym name or use CREATE OR REPLACE SCHEMA SYNONYM.