oracle数据表的备份与还原

备份:
create table sh_user_role_backup_20191219 as select * from sh_user_role
create table sh_org_type_backup_20191219 as select * from sh_org_type
还原:
INSERT INTO sh_user_role SELECT * FROM sh_user_role_20191219
INSERT INTO sh_org_type SELECT * FROM sh_org_type_20191219

posted @ 2019-12-19 15:27  子非鱼灬亦非我  阅读(149)  评论(0编辑  收藏  举报