Home » SQL & PL/SQL » SQL & PL/SQL » DML operation on a table (12C)
DML operation on a table [message #678775] Fri, 10 January 2020 00:27 Go to next message
deepakdot
Messages: 51
Registered: July 2015
Member
I want to find out all the table list , on which some INSERT / UPDATE / DELETE occur.

Here is the scenario. we are getting hundreds of scripts which contain INSERT / UPDATE / DELETE. lets say to 50 tables. I want to know which are those 50 tables affected with the script. we might have 200 tables in the database, But I am interested to know only these 50 tables.

I can create 200 triggers for each table, If any DML operation happen on any table, I can insert to a temp table, with the table name. But creating trigger for 200 tables may not be a good idea. Any other easy way we can find out those 50 tables ? I can execute all these scritps in a schema and then want to capture these 50 tables. .

Deepak
Re: DML operation on a table [message #678777 is a reply to message #678775] Fri, 10 January 2020 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

AUDIT, traditional or unified depending on what you exactly want.

Re: DML operation on a table [message #678778 is a reply to message #678777] Fri, 10 January 2020 05:12 Go to previous message
deepakdot
Messages: 51
Registered: July 2015
Member
Thanks Michel. This will help.
Previous Topic: ORA-03001 while using bulk collect
Next Topic: Hierarchy Queries
Goto Forum:
  


Current Time: Tue Sep 22 10:37:20 CDT 2020