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_at_post.pl>
Date: Wed, 01 Sep 1999 09:29:00 +0200
Message-ID: <37CCD5BC.C53F77DD_at_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
[Quoted] > 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 - 09:29:00 CEST