| Deepak |
Posted: Sep 02, 2005 02:48:02 AM |
Total Post: 10
Joined: Mar, 2005
|
Hi, all (specially VIGYAN )
i am in a great problm, some one has deleted 4 records from my database and i want them back right now. pls tell me how to know that who did this and how to recover them.
Plsssssssssss do it fast.
HOPING for my best |
|
|
 Vigyan |
| Posted: Sep 05, 2005 09:14:24 PM |  |
|
Total Post: 386
Joined: May, 2001
|
Hi Deepak,
It will not be possible to recover data until you have some sort of backup. Also without auditing enabled, I dont wont be able to see who deleted the data. From Oracle 9i onward, you can use Flashback Database for this kind of situation.
Good Luck.
Vigyan
|
|
|
|
|
| Deepak |
| Posted: Sep 06, 2005 06:18:10 AM | |
|
Total Post: 10
Joined: Mar, 2005
|
Thankx Vigyan for ur reply. Tell me how to use fleshback database. and how it works.
|
|
|
|
|
| Arulselvaraj |
| Posted: Jan 01, 2006 02:34:55 PM | |
|
Total Post: 15
Joined: Dec, 2005
|
Please see the following articles posted on this site.
FLASHBACK in Oracle 10g database (FLASHBACK QUERY)
This article explain FLASHBACK QUERY capabilities of the oracle 10g database.
by - Arjun Raja 12/24/2005
FLASHBACK in Oracle 10g database (FLASHBACK TABLE)
This article explain FLASHBACK TABLE capabilities of the oracle 10g database.
by - Arjun Raja 12/24/2005
FLASHBACK in Oracle 10g database (FLASHBACK DATABASE)
This article explain FLASHBACK DATABASE capabilities of the oracle 10g database.
by - Arjun Raja 12/24/2005
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
