ORA-00955 name is already used by an existing object

create table scott.test(num varchar2(32));

create table scott.test(num varchar2(32))

*

ERROR at line 1:

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

Reason:

There might be object such as table, view, cluster, index, synonym or procedure with same name.

select owner,object_name,object_type from dba_objects d

where D.OBJECT_NAME='TEST'

and d.OWNER='SCOTT' ;

To resolve ORA-00955, make sure to provide the database object an unmatched name. You can also drop or modify the existing object so that it can be reused.

SQL> drop procedure scott.test;

Procedure dropped.

SQL> create table scott.test(num varchar2(32));

Table created.