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

OWNER	OBJECT_NAME	OBJECT_TYPE
SCOTT	TEST	PROCEDURE

 

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.