You can't alter the criteria for a constraint in Oracle Database. To change it you must drop and recreate the constraint. Learn how to do this process online for check constraints, not null, unique constraints, primary keys, and foreign keys.