Oracle Error ORA-44741: Cannot drop a group whose tables are shared by other group(s).

Oracle Error Message

ORA-44741: Cannot drop a group whose tables are shared by other group(s).

Reason for the Error

An attempt was made to drop a group whose tables are shared by other group(s).

Solution

First drop group(s) with shared table(s) from this group.