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";

Comments

Popular posts from this blog

Oracle - duplicate fields in RECORD,TABLE or argument list are not permitted

Oracle - ORA-29282: invalid file ID, ORA-06512: at "SYS.UTL_FILE"