執(zhí)行閃回語句: Sql代碼 flashback table emp to timestamp to_timestamp('20120709195000','YYYYMMDDHH24:MI:SS');
2/閃回回收站: Java代碼 SQL>show recyclebin; SQL>drop table emp; SQL>show recyclebin; ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME EMP BIN$b+XkkO1RS5K10uKo9BfmuA==$0 TABLE 2012-11-07:15:30:47
SQL>flashback table emp to before drop;或 SQL>flashback table "BIN$b+XkkO1RS5K10uKo9BfmuA==$0" to before drop;
