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

Find Oracle Shutdown & Startup Time
How to Start & Stop Oracle iSQL*Plus
Certain files which need to be reinstalled by Oracle UI are being used
Steps to Patch Oracle 10.2.0.4.0 to 10.2.0.5.0
© 2017 ITsiti. All Rights Reserved
Powered by KEEM