What is Best way to load million rows of SELECT query to another Table
Hi All,
We have data issue on one of the finance tables which needs to be fixed by comparing the results within 2 huge table and build the output to load into another table
The challenge is the output of SELECT query after comparing both tables will be very huge, so not sure what is the best method of generating the output and load into temporary table
I see following options may be possible, but need somebody recommendation with clear steps as this is little urgent.
1. Generate txt output of SQL Query and use SQL LOADER to load into temporary table
We have data issue on one of the finance tables which needs to be fixed by comparing the results within 2 huge table and build the output to load into another table
The challenge is the output of SELECT query after comparing both tables will be very huge, so not sure what is the best method of generating the output and load into temporary table
I see following options may be possible, but need somebody recommendation with clear steps as this is little urgent.
1. Generate txt output of SQL Query and use SQL LOADER to load into temporary table
0