ORA-00955: name is already being used by existing object

I got ” ORA-00955: name is already being used by existing object ” error in Oracle.

 

ORA-00955: name is already being used by existing object

 

Details of error are as follows.

ORA-00955 name is already used by an existing object

Cause: An attempt was made to create a database object (such as a table, view, cluster, 
index, or synonym) that already exists. A user's database objects must have distinct names. 

Action: Enter a unique name for the database object or modify or drop the existing
 object so it can be reused.

 

 

name is already being used by existing object

This ORA-00955 errors are related with the objects which is an attempt was made to create a database object (such as a table, view, cluster, index, or synonym) that already exists. A user’s database objects must have distinct names.

To solve this error, change the object name you have used or if you can drop the existing ( old ) object, you can drop it and create the new object again.

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

See more