How to get the exact cause for the error - ORA-00955: name is already used by an existing object?

Question

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

There are so many statements and so many objects already. Then, how do you find out which object (table, column, sequence, view etc) caused this error to occur ?

I tried these links, but could not solve the problem -

• http://www.techonthenet.com/oracle/errors/ora00955.php
• http://www.dba-oracle.com/t_ora_00955_name_already_used_by_existing_object.htm

Answer 1

If you're running a script in SQL*Plus, you could SET ECHO ON and then spool the output to a file for later analysis.