To do an out of place restore of the data, perform. a CTAS (CREATE TABLE AS SELECT … AS OF …) using the Flashback Query SQL "AS OF …" clause. For example, to create a copy of the table as of a specific time:
CREATE TABLE old_emp AS SELECT * FROM employees AS OF TIMESTAMP '2002-02-05 14:15:00'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15116811/viewspace-600470/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle 10.2的文档
下一篇：
EWebEditor 支持IE7和IE8
请登录后发表评论
登录
全部评论
