Oracle Error ORA-44739: Cannot drop the last group.

Oracle Error Message

ORA-44739: Cannot drop the last group.

Reason for the Error

An attempt was made to drop the last group in the index.

Solution

Use the DROP INDEX statement instead.