You cannot delete the root login policy, or one that is currently
assigned to a user.
Prerequisites
The MANAGE ANY LOGIN POLICY system privilege.
Task- Verify that no users are currently assigned the login policy to be
dropped.
- Execute:
DROP LOGIN POLICY policy_name