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