[oracle db] ORA-00955: name is already used by an existing object

SELECT * FROM all_objects WHERE object_name = ‘<검색할 이름>’;

 

-> 현재 사용중인지 검색

 

drop table <>;

 

-> drop으로 삭제

 

 

select 'DROP ' || object_type || ' "' || owner || '"."' || object_name || '";' from all_objects where owner = 'INSTC' and object_type <> 'PACKAGE BODY' and object_name in ('TB_CLIENT_LOG') order by owner, object_type, object_name;