| parveez |
Posted: Dec 11, 2007 11:30:33 AM |
Total Post: 20
Joined: Aug, 2007
|
| Members i have deleted some data on my database and made a commit statement. Now i cannot give a rollback statement to get my previous datas. How can i retrieve those datas. Kindly help me out. |
|
|
 vikhardba |
| Posted: Dec 11, 2007 02:13:34 PM |  |
|
Total Post: 84
Joined: Apr, 2007
|
I understand that you need to retain deleted data but could you please be specific which data got deleted from database. For example, any object or query. If so, you can retrieve through flashback.
|
|
|
|
|
| Babu |
| Posted: Dec 12, 2007 01:11:21 AM | |
|
Total Post: 86
Joined: Oct, 2007
|
I want some more information.
May i know your database version?
|
|
|
|
|
| Mohammed Taj |
| Posted: Dec 12, 2007 09:36:25 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
You have to perform recovery for your deleted data.
if 10g look at flashback option.
search on documentation.http://tahiti.oracle.com
|
|
|
|
|
| parveez |
| Posted: Dec 14, 2007 10:23:39 AM | |
|
Total Post: 20
Joined: Aug, 2007
|
my oracle version is oracle 9i. I deleted some rows from a particular table and commited it. Now i want to retrieve those datas after some days which includes several shutdown of the server machine.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
