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

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

Oracle PL/SQL error message: ORA-00955: name is already used by an existing object.

Cause:

An attempt was made to create a database object (table, view, cluster, index, or synonym) that already exists.

Solution:

Check the database object name and enter a unique name or modify or drop the existing object so it can be reused.

Example:

CREATE INDEX first_name_idx ON students (first_name);

Output:

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

Correct:

DROP INDEX first_name_idx; 
CREATE INDEX first_name_idx ON students (first_name);

Output:

index FIRST_NAME_IDX dropped.
index FIRST_NAME_IDX created.