0

I want to track all the changes from the entire table of a database and insert the changes data/activity into the given table by creating a single trigger

CREATE TABLE sh_audit(
  new_name varchar2(30),
  old_name varchar2(30),
  user_name varchar2(30),
  entry_date varchar2(30),
  operation  varchar2(30)
)

..from entire table
SELECT tablename
FROM all_tables;
Shmiel
  • 1,201
  • 10
  • 25
DIPAK SHAH
  • 33
  • 1
  • 8
  • 1
    no you ave to make the trigger for all tables that need it – nbk Jun 27 '22 at 16:48
  • 1
    I suggest you consider [Oracle GoldenGate](https://docs.oracle.com/en/middleware/goldengate/index.html) if you want a log of all data changes on all tables. – Bill Karwin Jun 27 '22 at 17:09

0 Answers0