Backup Strategy - myeid4all/OracleReference GitHub Wiki

create table BACKUP_TABLE parallel as select /*+ parallel */ from MY_TABLE where [archival criteria]

OR

alter session enable parallel dml; insert /*+ append parallel / into BACKUP_TABLE select /+ parallel */ from MY_TABLE where [archival criteria]