I am setting up some tables to hold a backup copy of some data. What is the syntax for inserting data from that backup copy back into the original table which avoids REDO?
I'll basically just be doing the following:
create table myTable_bck as select * from myTable;
truncate table myTable;
insert /*+ NOLOGGING*/ into myTable
select * from myTable_bck;
I found NOLOGGING, but I think that only applies to CREATE TABLE and ALTER TABLE statements. I found documentation on Direct-Path inserts using the /*+ APPEND */ hint, and the documentation described using a logging vs a non-logging approach, but didn't clearly mention how to manage that part.