insert into tablerestore select * from tablerestore as of timestamp to_Date('2014-8-8 15:00:00','yyyy-mm-dd hh24:mi:ss')

参数解释：tablerestore 要恢复数据的表

后面的时间是恢复截止到某个点的数据