The default is ENABLE VALIDATE.
SQL>
SQL> -- create demo table
SQL> create table myTable(
2 id NUMBER(2),
3 value NUMBER(6,2)
4 )
5 /
Table created.
SQL>
SQL> ALTER TABLE myTable
2 ADD CONSTRAINT uq UNIQUE (id) DISABLE;
Table altered.
SQL>
SQL> ALTER TABLE myTable
2 DISABLE CONSTRAINT uq;
Table altered.
SQL>
SQL> Null? Type
SQL> ALTER TABLE myTable
2 ENABLE NOVALIDATE CONSTRAINT uq;
Table altered.
SQL>
SQL> drop table myTable
2 /
Table dropped.
SQL>