From: "Nicolas Bronke" <newsgroup@trinity.de>
Newsgroups: comp.databases.oracle.server
Subject: Truncate table and Triggers
Date: Mon, 1 Jan 2001 22:09:23 +0100
Organization: T-Online
Lines: 12
Message-ID: <92qrjs$aku$07$1@news.t-online.com>
Reply-To: "Nicolas Bronke" <newsgroup@trinity.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: news.t-online.com 978383292 07 10910 waMheqTShYQ5Y 010101 21:08:12
X-Complaints-To: abuse@t-online.com
X-Sender: 06995298101-0001@t-dialin.net
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300


I placed a delete trigger on a table to unpermit delete operations under a
special condition.

Now I fpund out, that truncate table ommit this rules. Everything is erased
nevertheless from the rules.

Perhaps it is logically, but how can I avoid this situation?

regards
Nicolas