Home » SQL & PL/SQL » SQL & PL/SQL » Table Name Identification (oracle 10g windows XP)
Table Name Identification [message #347060] Wed, 10 September 2008 09:46 Go to next message
jagadeeshg
Messages: 14
Registered: December 2007
Location: BLR
Junior Member

I want to know is there any way to find the table names that
were participated in a transaction( I mean between one commit and commit) for a particular session?
Re: Table Name Identification [message #347077 is a reply to message #347060] Wed, 10 September 2008 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65150
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way.

Regards
Michel
Re: Table Name Identification [message #347117 is a reply to message #347060] Wed, 10 September 2008 15:47 Go to previous message
Bill B
Messages: 1663
Registered: December 2004
Senior Member
Have auditing turned on in the database or use logminer to trace the session, though logminer wouldn't detect selects.
Previous Topic: Summing of record values based on certain condition
Next Topic: CHECK constraint not working ?
Goto Forum:
  


Current Time: Mon Aug 21 14:53:30 CDT 2017

Total time taken to generate the page: 0.04821 seconds