Search code examples
jakarta-eejpatriggersoracle11gjava-ee-6

Insert a deleted record in another schema

I want to know if there is any mechanism to perform as following : when I delete a record R1 from a table T1 in schema S1, I want to insert it to a corresponding table T1 in another schema S2. My project is in JavaEE and I also want to know if there is any solution in JPA to handle that or I should handle it using an ORACLE trigger?

Solution

  • Use Triggers to handle this operation.

    for further explanations, Google it, then you will get plenty of resources out there on different types of triggers.