Oracle中备份表的简单sql命令语句

复制代码 代码如下:

create table bmpforest.e_pkg_atpcfg_bac as select * from bmpforest.e_pkg_atpcfg where 1=2

insert into e_pkg_atpcfg_bac select * from e_pkg_atpcfg;