查看某个时段的数据
select * from 表名 as of timestamp to_timestamp('2020-01-01','yyy-mm-dd')
查看一小时前的数据
select * from 表名 as of timestamp sysdate - 1/24
回闪
flashback table 表名 to timestamp to_timestamp('2020-01-01','yyy-mm-dd')
回闪报错ORA-01809?
alter table 表名 enable row movement
删除同义词
DROP [PUBLIC] SYNONYM [schema.]sysnonym_name
DROP SYNONYM USER.表名