How to fix the Oracle error ORA-23333: column string is already part of a column group?

In this post, you’ll learn more about the Oracle ErrorORA-23333: column string is already part of a column group with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-23333: column string is already part of a column group

Reason for the Error ORA-23333: column string is already part of a column group

Attempted to add a column to a column group when the column was already a member of a column group.

How to fix the Error ORA-23333: column string is already part of a column group ?

You can fix this error in Oracle by following the below steps

Drop the column from its existing column group before trying to add it to another.