Simple sql command statement for backing up tables in Oracle

  • 2021-07-18 09:15:27
  • OfStack

 
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; 

Related articles: