Home » SQL & PL/SQL » SQL & PL/SQL » which table are updated
which table are updated [message #245516] Mon, 18 June 2007 00:14 Go to next message
meeta
Messages: 28
Registered: January 2000
Junior Member
Hi,
I want to knw that is there anyway by which we can find what tables in database are getting updated by a particular transaction except auditing.
Re: which table are updated [message #245518 is a reply to message #245516] Mon, 18 June 2007 00:17 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
By looking at the SQL issued.
Re: which table are updated [message #245519 is a reply to message #245518] Mon, 18 June 2007 00:19 Go to previous messageGo to next message
meeta
Messages: 28
Registered: January 2000
Junior Member
Hi , Thanks 4 ur reply but i am issuing transaction through front end not sql,than how to find which tables are getting updated throught that transaction
Re: which table are updated [message #245520 is a reply to message #245516] Mon, 18 June 2007 00:22 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Enable SQL_TRACE and process trace files using TKPROF.
Previous Topic: PLS-00306: wrong number or types of arguments in call
Next Topic: SQL : Connect BY PRIOR How to
Goto Forum:
  


Current Time: Thu Dec 08 12:33:59 CST 2016

Total time taken to generate the page: 0.13445 seconds