title: Need to copy a the contents of a very large table in Oracle 11G
body: <p>We have a database that stores billions of rows a day.   It is a 11G oracle database with RAC enable for same site HA and active dataguard for cross site.   We had to change the block size from 16k to 8k.  As this is not an online change we had to rename the table with months of data and create a new table.  Now we need to get the data from the original table into the new one.</p>
  
  <p>Direct path inserts will lock the table, and regular inserts are causing lots of RAC waits.   Wonder if anyone has any best practices to move a ton of data from one table to another without stopping other processes from writing data to the new table (rapidly)</p>