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- 备份单表结构和单表数据
标签: