Skip to Main Content
Forums

SQL & PL/SQL

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!

Track table changes at Schema Level

cpMay 4 2010 — edited May 5 2010
Hi,

I have 40 tables in a schema and correponding 40 history tables in the same schema. If any row is being deleted (or updated) in the parent table, i want to insert the data in history tables.

Do i need to write 40 separate trigger for this or do i have any option to write a single trigger on the schema so that the changes on the parent table can be inserted in history table.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2010
Added on May 4 2010
6 comments
1,363 views