ORA-01430: column being added already exists in table

ORA-01430: column being added already exists in table

Oracle PL/SQL error message: ORA-01430: column being added already exists in table.

Cause:

You execute an ALTER TABLE ADD statement with a column that is already in the table. All column names must be unique within a table.

Solution:

Change the column name to be unique, then re-execute the statement.

Example:

CREATE TABLE TEST3(
ID NUMBER NOT NULL, 
NAME VARCHAR2(250)
) ;
Insert into TEST3 (ID, NAME) values (1,'STRING 1');
Insert into TEST3 (ID, NAME) values (2,'STRING 2');
Insert into TEST3 (ID, NAME) values (3, null);

ALTER TABLE TEST3 ADD NAME VARCHAR2(250);

Output:

table TEST3 created.
1 rows inserted.
1 rows inserted.
1 rows inserted.
ORA-01430: column being added already exists in table




Correct:

ALTER TABLE TEST3 ADD DESCRIPTION VARCHAR2(250);

Output:

table TEST3 altered.