November 8 2013

oracle flashback table

–alter system set recyclebin=off;
–alter system set recyclebin=on;
–打开和关闭回收站 默认开的
SELECT * FROM RECYCLEBIN
DROP TABLE test1

FLASHBACK TABLE TEST1 TO BEFORE DROP rename TO test8

FLASHBACK TABLE “BIN$PFYqEmm8S1O047Wty9HMGg==$0” TO BEFORE DROP

SELECT * FROM test8



Copyright 2019. All rights reserved.

Posted 2013年11月8日 by ucjmh in category "oracle

Leave a Reply

Your email address will not be published. Required fields are marked *