RE: When does Triggers get dropped ?
Date: Wed, 25 May 2016 03:52:58 +0000
Message-ID: <2FE2AA1C5F8DEC478F58DF8DD32BA6370CECFF0A_at_HKWPIPXMB03C.zone1.scb.net>
Either
DROP TRIGGER
Or
DROP TABLE Explicitly issued by the DBA or DEVELOPER or some code written by either of them. Oracle wouldn’t “automatically” drop triggers.
Hemant K Chitale
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bala
Sent: Wednesday, May 25, 2016 7:58 AM
To: oracle-l
Subject: When does Triggers get dropped ?
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
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 25 2016 - 05:52:58 CEST