ORA-01981

Error: ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

Causa: During this revoke some foreign key constraints will be removed. In order to perform this automatically, CASCADE CONSTRAINTS must be specified.

Acción: Remove the constraints or specify CASCADE CONSTRAINTS.