Home » RDBMS Server » Server Administration » About the time in FlashBack
About the time in FlashBack [message #170844] Fri, 05 May 2006 08:37 Go to next message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
hi,

In Flashback query how to know the time of deletion of records.
Whether to use logminer for that or any other method?

Thanks in Advance
Salih

Report message to a moderator

Re: About the time in FlashBack [message #170984 is a reply to message #170844] Sun, 07 May 2006 03:40 Go to previous message
lazycat
Messages: 57
Registered: November 2005
Member
you can estimate the time

if not


you can flash back a table after it drop

select * from dba_recyclebin where object='**' and drop_time=



another way is logminer

you can do it

Report message to a moderator

Previous Topic: ORA error 7445
Next Topic: network drive
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 15:11:56 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.