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: 185
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
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
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
you can use logminer to find more details on what you are looking for.

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


Current Time: Sat Dec 03 04:03:12 CST 2016

Total time taken to generate the page: 0.13973 seconds