Oracle快速备份表

1.备份表结构:

create table 新表名 as select * from 旧表名 where 1=2; 
例如: create table mdm_gw_codebak20210922 as select * from mdm_gw_code where 1=2;

2.备份表数据:

insert into 新表名 select * from 旧表名; 
​​​​​​​例如: insert into mdm_gw_codebak20210922 select * from mdm_gw_code;