Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Schema level Database triggers

641395Mar 20 2009 — edited Jun 4 2013

Hi all,
I want write a DML trigger for all the tables in a schema. Is there a way to write it in schema level. There are a large number i.e. 4000 tables are there in the schema and it will be very tiring to wirte same trigger for 4000 times. I am using Oracle 10g. A helpful suggestion will be highly appreciated.

Thanks and regards

Sukanta

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 2 2013

Added on Mar 20 2009

#general-database-discussions

14 comments

11,457 views