Oracle单表备份

1. 备份

create table [备份名] as select * from [表名];

2. 恢复

truncate table org_group;

insert into org_group select * from [备份名] ;

posted @ 2020-01-08 13:11  幸福在靠近  阅读(161)  评论(0编辑  收藏  举报