Re: When does Triggers get dropped ?

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Tue, 24 May 2016 23:05:48 -0600
Message-ID: <574532AC.6010404_at_gmail.com>

Drop table A and the trigger will also be dropped.

The fact that the trigger inserts into table B makes the code invalid when table B is dropped, but it does not eliminate the firing condition. Only dropping table A would eliminate the firing condition and leave the trigger as an orphan if it was not automatically dropped..

But the trigger does not 'belong to' table B. Simply recreating table B with referenced columns will allow the trigger to be validated. This is just like any other PL/SQL object dependency.

/Hans

On 24/05/2016 5:58 PM, Bala wrote:
> Gurus,
>
> When does Oracle Triggers get dropped ?
>
> 1) Trigger on Table A inserts to Table B on a trigger condition
> 2) Table B is Dropped, Trigger still exists with status "Invalid"
>
> Oracle 12c , Solaris.
>
> Question : Is there any scenario of automatic Drop of Triggers ? (
> Would Dropping Table A make it possible ?)
>
> Thank you in advance for any insight.
>
> --
> Bala Rao

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 25 2016 - 07:05:48 CEST