恢复删除的表
CREATE OR REPLACE PROCEDURE recicle is
t_name varchar2(32);
sq varchar2(500);
cursor cur is
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin where type=\’TABLE\’ and ts_name=\’USERS\’;
BEGIN
for x in cur loop
t_name :=x.original_name;
sq :=\’flashback table \’||t_name||\’ to before drop\’;
execute immediate sq;
end loop;
end ;
版权声明：本文为coder-axin原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。