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. |