Posts

Showing posts from June, 2013

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

Problem:

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

Solution:

Verificar que tipo de object esta a utilizar el nombre:
   select * from all_objects where object_name = 'XXX';

Si el object existing no es necesario se puede realizar el drop:
   drop "tipo_de_objecto" "nombre_del_object";