| Kaiz |
Posted: Mar 06, 2008 01:12:19 AM |
Total Post: 104
Joined: Sep, 2007
|
Dear Friends...
Is it possible to bring back the deleted/truncated Table...
With Regards... |
|
|
Mohammed Taj |
| Posted: Mar 06, 2008 07:56:05 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Yes, possible.
how? then provide us oracle version?
hint: use flashback feature(10g)
|
|
|
|
|
shantanu |
| Posted: Mar 06, 2008 02:23:42 PM | |
|
Total Post: 42
Joined: May, 2007
|
Flashback feature reinstates the dropped table. Following is the syntax :
SQL> flashback table tablename before drop;
But when you want to drop table permanently without having flashback feature to recover it, use purge:
SQL> drop table tablename purge;
|
|
|
|
|
Kaiz |
| Posted: Mar 07, 2008 01:19:20 AM | |
|
Total Post: 104
Joined: Sep, 2007
|
Thanks
In 9i Versrion is it possible...
Regards...
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |