Oracle- 备份单表结构和单表数据
标签：
Oracle- 备份单表结构和单表数据
创建一份表结构
create table BASE_GOODSPAYMENT_SETTING_BAK as select * from BASE_GOODSPAYMENT_SETTING ;
--将数据插入到备份表中
insert into BASE_GOODSPAYMENT_SETTING_BAK select * from BASE_GOODSPAYMENT_SETTING;