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

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

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.'
Re: use scn number [message #200022 is a reply to message #199450] Fri, 27 October 2006 07:49 Go to previous message
Messages: 121
Registered: August 2006
Senior Member
you can use logminer to find more details on what you are looking for.

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

Current Time: Sun Jul 23 10:19:50 CDT 2017

Total time taken to generate the page: 0.10013 seconds