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: 64139
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: 1484
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: Creating Dynamic Variables
Next Topic: SQL*plus command
Goto Forum:
  


Current Time: Thu Dec 08 16:07:48 CST 2016

Total time taken to generate the page: 0.11369 seconds