Home » RDBMS Server » Server Utilities » Can find my change from digging archive log with logmnr
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
Previous Topic: SQLLDR
Next Topic: expdp -export error when using data pump- need help
Goto Forum:
  


Current Time: Sat Dec 10 18:33:55 CST 2016

Total time taken to generate the page: 0.13006 seconds