When does Triggers get dropped ?
From: Bala <oratips_at_gmail.com>
Date: Tue, 24 May 2016 19:58:13 -0400
Message-ID: <CAF5SaXuv713oZ+yNOp9n3GereZ3GJ8sNVs4vZ78phPhYnCuLjQ_at_mail.gmail.com>
Gurus,
Date: Tue, 24 May 2016 19:58:13 -0400
Message-ID: <CAF5SaXuv713oZ+yNOp9n3GereZ3GJ8sNVs4vZ78phPhYnCuLjQ_at_mail.gmail.com>
Gurus,
When does Oracle Triggers get dropped ?
- Trigger on Table A inserts to Table B on a trigger condition
- 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 - 01:58:13 CEST