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 -> Re: Making certain records in table non-deleteable

Re: Making certain records in table non-deleteable

From: Doktor <doktor_at_post.pl>
Date: Wed, 01 Sep 1999 09:29:00 +0200
Message-ID: <37CCD5BC.C53F77DD@post.pl> 





> > I have a table which will contain many records; however, several records


> > in this table help to drive the PL/SQL and should never, ever be deleted


> > or altered. How can I make these records permanent? What is the best


> > way?


> 


> Probably the easiest way is to use a trigger that cancels the delete if


> certain conditions are met.





If this table exists "alone" in separate tablespace, you can set this
tablespace in read-only mode.
Received on Wed Sep 01 1999 - 02:29:00 CDT












Original text of this message













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