Oracle- 备份单表结构和单表数据
时间:2021-07-01 10:21:17
帮助过:1人阅读
创建一份表结构
create table BASE_GOODSPAYMENT_SETTING_BAK
as select * from BASE_GOODSPAYMENT_SETTING ;
--将数据插入到备份表中
insert into BASE_GOODSPAYMENT_SETTING_BAK
select * from BASE_GOODSPAYMENT_SETTING;
Oracle- 备份单表结构和单表数据
标签: