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.