Learn the motive and how to unravel the ORA-01430 error message in Oracle.
When you come upon an ORA-01430 error, the following error message will appear:
ORA-01430: column being brought already exists in table
You tried to add a column to a table, but the column identify already exists in that table.
The option(s) to resolve this Oracle error are:
Rewrite your ALTER TABLE command to create a column with a special name. Each column name have to be special within a table.
For example, if you had a table called suppliers described as follows:
CREATE TABLE suppliers ( supplier_id number not null, supplier_name varchar2(50) not null, city varchar2(30), state varchar2(2), zip_code varchar2(10) );
And you executed the following ALTER TABLE command:
ALTER TABLE suppliers ADD supplier_name varchar2(50);
You would receive the following error message:
The column referred to as supplier_name already exists. Each column name in your table ought to be unique.