Oracle constraint still applying after dropping it

The reason for this is that the index of this constraint was not deleted.
You just have to drop the index.
For more detail check this stackoverflow article