Copy Data from one table to another table

Hi All,

I need some clarification on copying the data from one table to another table, The plan is to move the 90 days data from current table to new table. want to understand is there any way to copy the data faster, any sample script that i can use to transfer the data faster. need to set up the archival solution.

table name : TABLE_X_NEO_MESSAGES this conatins CLOB column.

task : copying the 90 days data to new table TABLE_X_NEO_MESSAGE_NEW

no of rows

30 days : 3480501

60 days : 6560661

90 days: 9683868 -- this is the volume we are planning to move to new table.