If you have a dump/export of the data, you could re-import the table and data with the import (imp) or the Data Pump import (impdp) utility. Information on importing and exporting can be found here.
If the deletion occurred relatively recently, you could use Flashback Query to recover the data.
SQL> INSERT INTO EMP_TMP
(SELECT * FROM EMP AS OF TIMESTAMP ('14-FEB-11 10:00:00','DD-MON-YY HH24: MI: SS');
Here is a nice link about the feature. The length of the availability of the data will depend on your UNDO_RETENTION parameter as it essentially uses the undo information to create the snapshot of the data as it existed at that point in time.
发布评论
评论（3）
这是什么版本的 Oracle？如果它是 10G 或以上，您可以将其从回收站取回。例如，
或者，如果您只是删除了数据，则可以使用闪回查询取回数据。
What version of Oracle is this? If it's 10G or above you can bring it back from the recyclebin. For example,
Alternately, if you simply deleted the data you can get the data back using Flashback Query.
如果您删除表，您可以在回收站中找到。
If you drop table you can find in recycle bin.
如果您转储/导出数据，则可以使用导入 (imp) 或数据泵导入 (impdp) 实用程序重新导入表和数据。有关导入和导出的信息可以在此处找到。
如果删除发生在最近，您可以使用闪回查询来恢复数据。
这是一个很好的 链接。数据的可用性长度将取决于 UNDO_RETENTION 参数，因为它本质上使用撤消信息来创建数据在该时间点存在的快照。
If you have a dump/export of the data, you could re-import the table and data with the import (imp) or the Data Pump import (impdp) utility. Information on importing and exporting can be found here.
If the deletion occurred relatively recently, you could use Flashback Query to recover the data.
Here is a nice link about the feature. The length of the availability of the data will depend on your UNDO_RETENTION parameter as it essentially uses the undo information to create the snapshot of the data as it existed at that point in time.