Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Read-Only Table : DISABLE VALIDATE ?

Read-Only Table : DISABLE VALIDATE ?

From: klabu <noone_at_gmail_dot_com>
Date: Sun, 5 Nov 2006 03:53:01 -0500
Message-ID: <12kr9jep73mjef1@corp.supernews.com>


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


  1. WHY "DISABLE VALIDATE" must disallow I/U/D on the table ?
  2. Is this a "proper" way to make a table READ-ONLY ? what caveats ?

thanks

-- 
10gR2 
Received on Sun Nov 05 2006 - 02:53:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US