| Can find my change from digging archive log with logmnr [message #195262] |
Wed, 27 September 2006 11:58 |
Jack_zhai
Messages: 12
Registered: February 2006
|
Junior Member |
|
|
Hi,
I made change to the database and switch the log right away. Then I added the log to the log list for logmnr. But I just can't find the last sql I executed. For the last sql which was a create table clause
create table for_logmnr(text char(9));
The search query is:
select * from V$LOGMNR_CONTENTS where username ='TIM';
Thanks
Jack
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
