今天吓的头疼,似乎是感冒了。本以为是在PPR环境做的操作,做完以后,定睛一看,WC,是PROD环境,吓的我热汗直流。下班后开始找恢复方法,终于找到了。头疼欲裂,真的是吓出病了。
删除SQL如下:
–delete * FROM witmsup_WORK where WSUPREQNO=’CL180600006’;
–delete * from WITMSUP where WSUPREQNO=’CL180600006’;
–commit;
恢复SQL如下:
–INSERT INTO WITMSUP SELECT * FROM witmsup AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL ‘300’ MINUTE) where WSUPREQNO=’CL180600006’;
–INSERT INTO witmsup_WORK SELECT * FROM witmsup_WORK AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL ‘270’ MINUTE) where WSUPREQNO=’CL180600006’;
–COMMIT;
另外:
ORACLE中用select into from 不可以,抛异常ORA-00905: missing keyword
所以用-INSERT INTO * SELECT….
这里只讲了我的特殊场景的特殊写法。具体用法有大量知识可参考。不必惊慌。