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;