Oracle Error ORA-44742: Cannot alter columns of a table that is shared by other group(s).

Oracle Error Message

ORA-44742: Cannot alter columns of a table that is shared by other group(s).

Reason for the Error

An attempt was made to add columns to, modify columns of, or drop columns from a table shared by other group(s).

Solution

First drop group(s) with shared table(s) from this group and then proceed with this operation.