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



Share this article :

Symptom

You are creating a table in the Oracle but you are getting below error.

create table aracici;
ERROR at line 1:
ORA-00955: name is already used by an existing object

Solution

You are getting the error because the respective database object (table, index, view, synonym or cluster) are already existed.

So, you need to enter a different name (should be the safest way) or you can drop/modify the database object so that you can re-use it again.

Tags:

Related posts

Oracle Shutdown Command Modes
V$ARCHIVE_GAP: Archive Gaps on Standby Database
ORA-00904: invalid identifier
ORA-28002: the password will expire within x days
© 2018 ITsiti. All Rights Reserved
Powered by KEEM