Home » RDBMS Server » Backup & Recovery » use scn number
use scn number [message #199450] Tue, 24 October 2006 07:15 Go to next message
oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi

can any one let me know how to find which user has deleteed the table with scn number and get it back

thanxs

Report message to a moderator

Re: use scn number [message #199521 is a reply to message #199450] Wed, 25 October 2006 00:20 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Oracle Ver?
if 10g. use Flashback Database option.'

Report message to a moderator

Re: use scn number [message #200022 is a reply to message #199450] Fri, 27 October 2006 07:49 Go to previous message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
you can use logminer to find more details on what you are looking for.

Sandeep

Report message to a moderator

Previous Topic: Automatic swtich over from primary to standby
Next Topic: Cannot recover CURRENT redo log
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 08 05:49:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.