-1

I have to maintain history into target table for each and every change made into source table.

enter image description here

James Z
  • 12,209
  • 10
  • 24
  • 44
Raunak
  • 13
  • 4
  • 1
    Your picture and description don't match the title off your question... You want to track data changes or table structure changes? – thatjeffsmith Jul 05 '21 at 10:24
  • @thatjeffsmith, I want to track the data changes in my source table. If there is an insert then new row should be inserted into my target table; If there is an update on existing record then new changes should be inserted as new record into target table as active flag = Y and old row should be marked as N – Raunak Jul 05 '21 at 10:47
  • Oracle has built in auditing.feature that does this for you, just turn it on – thatjeffsmith Jul 05 '21 at 12:03
  • 1
    Also, Oracle SQL developer is just the GUI tool for accessing the database. I would assume you want to track the change in the oracle database itself. Everyone will understand your question, but you really should be using the correct terms. – James Z Jul 05 '21 at 13:34

1 Answers1

0

Have you tried associating a Materialized View to your table to track?

You can use the Materialized view log. All changes will be saved there: materialized view

https://oracle-base.com/articles/misc/materialized-views

Rui Costa
  • 417
  • 2
  • 11