Flashback | SysDBA

Recovering a deleted (with drop) Table using the FlashBack feature

drop table emp1;

1	drop table emp1;

show parameter RECYCLEBIN;

1	show parameter RECYCLEBIN;

show recyclebin;

1	show recyclebin;

SELECT object_name as recycle_name, original_name, type FROM recyclebin;

1	SELECT object_name as recycle_name, original_name, type FROM recyclebin;

FLASHBACK TABLE "BIN$nxCN9kMKwvzgQKjAhA0Cxg==$0" TO BEFORE DROP;

1	FLASHBACK TABLE "BIN$nxCN9kMKwvzgQKjAhA0Cxg==$0" TO BEFORE DROP;

FLASHBACK TABLE HR.INT_ADMIN_EMP TO BEFORE DROP;

1	FLASHBACK TABLE HR.INT_ADMIN_EMP TO BEFORE DROP;

FLASHBACK TABLE "BIN$nxCN9kMKwvzgQKjAhA0Cxg==$0" TO BEFORE DROP RENAME TO hr.int2_admin_emp;

1	FLASHBACK TABLE "BIN$nxCN9kMKwvzgQKjAhA0Cxg==$0" TO BEFORE DROP RENAME TO hr.int2_admin_emp;