Home » RDBMS Server » Backup & Recovery » oracle (11gR1)
oracle [message #457192] Fri, 21 May 2010 12:51 Go to next message
kalpataru
Messages: 69
Registered: January 2010
Location: INDIA
Member
hi all,
i have table employee of 50 records.
by mistakely i have deleted 10 records which very important to me.i have deleted in time 4.00 p.m(20-may-2010).
i have no any backup files of that table.

how can i restore deleted 10 records to my table .

any idea is there.
please help me and tell me the restore process(detail command).
Re: oracle [message #457195 is a reply to message #457192] Fri, 21 May 2010 12:57 Go to previous message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Options:
1/ Flashback query
2/ Log Miner

(Both are searchable in Oracle documentation for details and examples.)

Regards
Michel
Previous Topic: oracle 10g + ASM + block change tracking
Next Topic: rman tablespace restore
Goto Forum:
  


Current Time: Sat Aug 30 21:15:45 CDT 2014

Total time taken to generate the page: 0.10992 seconds