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!

Storing Deleted records in another table

zzzzzzzApr 6 2017 — edited Apr 6 2017

Hi All,

We are working with 11.2.0.2.0 DB.

Our requirement is to store the deleted records in another table. I am trying to do the same using an trigger.

Is there a better way to keep the copy of deleted records ? I tried searching FGA, but could not understand whether it is possible or not to copy the deleted records into another table.

Thanks in advance for your suggestions.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2017
Added on Apr 6 2017
23 comments
1,285 views