恢复被删除的table:
--select tablespace_name,RETENTION from dba_tablespaces where tablespace_name='UNDOTBS1';
show recyclebin
FLASHBACK TABLE TSTFORM100_SUB1 TO BEFORE DROP;
--alter table TSTFORM100_SUB1 --drop column changetype_newc
--rename to TSTFORM100_SUB1_1
恢复被误操作的数据:(flashback query)
--create table TSTFORM100_ABC AS
select * from TSTFORM100 as of timestamp to_timestamp('2014-09-28 15:00:19','yyyy-mm-dd hh24:mi:ss')