1、备份
create table product_20230419 as select * from product;
2、查询一下
select * from product_20230419;
select * from product;
select count() from product_20230419;
select count() from product;
3、还原
delete from product;
insert into product select * from product_20230419;
4、如果原表进行了一些改动 但是不能删除数据进行还原
update product u1 SET u1.name = (select u2.name from product_20230419 u2 where u1.fid =u2.fid)
oracle对表进行备份并还原
最新推荐文章于 2024-07-09 15:23:34 发布