Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

History log of all SQLs of a particular schema

Status
Not open for further replies.
rk68

rk68

Programmer
Jul 15, 2003
171
IN
Hi,
I need to pull out log file for all the SQLs executed from 6th April - 13th April for a specific schema & table.
I tried using DBA_HIST_ACTIVE_SESS_HISTORY / DBA_HIST_SQLTEXT but didn't find any data related to that table.

The reason I require this log is a particular field was updated by some user. Want to check to when did this happen & which user has done it. We know it has happened between 6th & 13th April.

TIA,
Raj
 
Sort by date Sort by votes
Did you find any known updates by known user to any other tables / fields?


---- Andy

There is a great need for a sarcasm font.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
427
carp
carp
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
450
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
223
Livia8
Livia8
torturedmind
  • Locked
  • Question
Week of the year
Replies
0
Views
99
torturedmind
torturedmind
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
209
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top