Constraint

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

by Ed Chen
December 1, 2022March 16, 2023

ORA-01981 Tried to revoke object privileges from an user, but it failed with ORA-01981. SQL> revoke all on HR.EMPLOYEES from OE revoke all on HR.EMPLOYEES… Read More »

How Oracle Rename Constraint

by Ed Chen
October 19, 2022November 17, 2022

ALTER TABLE RENAME CONSTRAINT To rename a constraint, we need to do it through ALTER TABLE. Let's see a constraint. SQL> show user USER is… Read More »