Hi , Yep maybe I remember wrong.. but I remember reading about this elegant trick quite a long time ago. As Jonathan's book was actually the first Oracle book I wanted that much that I bought to myself, I concluded from there. (Not that I didn't want to buy other books, but a student in Estonia at that time couldn't afford buying less than excellent books, especially considering the continuously raising beer price back then). Tanel. ----- Original Message ----- From: Jared Still To: tanel.poder.003@xxxxxxx Cc: ORACLE-L Sent: Thursday, January 19, 2006 11:43 AM Subject: Re: Read Only Tables On 1/18/06, Tanel Põder <tanel.poder.003@xxxxxxx> wrote: > The technique of using a disabled constraint to effectively make a table > read-only is not entirely new. I definitely recall reading of this > technique in a book published at least a few years ago. The idea of If I recall correctly, that was in Jonathan Lewises Oracle 8i book... Tanel. I've spent a few minutes looking for it, but can't find it. That does not of course mean it is not there. That little search was a thoroughly interesting and satisfying diversion. Practicle Oracle8i (Lewis) and Scaling Oracle (Morle) must be the two most useful and underappreciated Oracle books. I have two copies of the best Oracle books, one for home, and one for work. These two books are in that set. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist