SQL>flashback table t1 to before drop;
闪回后,把删除的表,及索引都会恢复。
Flashback table statement reads the past images of the table from the undo segments and reconstructs the table rows using the flashback queries.
flashback TABLE语句从undo段读取表的过去的映像,并使用flashback查询重新构造该表的行。
When a transaction containing DML on a tracked table commits, this process stores the pre-image of the rows into the Flashback Data Archive.
当在被追踪的表上面发生了dml事务的时候,这个进程存储行的前镜像到闪回数据归档里面。
When a transaction containing DML on a tracked table commits, this process stores the pre-image of the rows into the Flashback Data Archive.
当在被追踪的表上面发生了dml事务的时候,这个进程存储行的前镜像到闪回数据归档里面。
应用推荐