How to resolve ORA-01471 Error Message in Oracle database

Isaac
Posted by By Isaac 1 year Ago 1 Min Read

Learn the cause and how to unravel the ORA-01471 error message in Oracle.

Description

When you come upon an ORA-01471 error, the following error message will appear:

ORA-01471: cannot create a synonym with the same title as object

Cause

You tried to create a personal synonym with the equal identify as the object that it is referencing.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Select a synonym title for the private synonym that has not been already used by using some other object.

For example, if you had a desk known as suppliers described as follows:

CREATE TABLE suppliers
( supplier_name varchar2(50),
  city varchar2(35)
);

Then executed the following statement:

CREATE SYNONYM suppliers
FOR suppliers;

You would receive the following error message:

You ought to correct this by way of deciding on a unique title for the synonym that has no longer already been used with the aid of any other object. For example:

CREATE SYNONYM suppliers_synonym
FOR suppliers;