最初由 wzy25 发布
[B]1.如果你用9i，用flashback可以处理，但是时间要快
2.备份恢复，重新把那个表导出来，import进取 [/B]
Flash back query won't help to get rows from dropped table. It is useless in this case.
Andhe is using 816.
What kind of backup are u using? Or simple dump, just imp that table.
If rman or os backup, restore to another node and do point in time recovery, and recover to that time and import that table again.
To fine out the timestamp that the table was dropped, as ttdb said, use logmnr.
