Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Read-Only Table : DISABLE VALIDATE ?
ALTER TABLE myemp MODIFY CONSTRAINT pk_myemp
DISABLE VALIDATE;
SQL> INSERT INTO myemp (empno) VALUES (21);
ORA-25128: No insert/update/delete on table with constraint (klabu.PK_myemp) disabled and validated
thanks
-- 10gR2Received on Sun Nov 05 2006 - 02:53:01 CST
![]() |
![]() |