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

i tried create table:

create table departments (   departments_id number primary key,   departments_name varchar2(30),    departments_block_number number );

but got error:

create table departments
*
error @ line 1:
ora-00955: name used existing object

this error occurs when try create new object name used other object in schema.

select * all_objects object_name = upper('departments') , owner = upper('your_schema')

now can see object created in schema name departments

you can resolve issue renaming table or drop existing object if no more in use.

Premier