Thanks for the question, Tamilselvi .
Asked: February 03, 2020 - 2:50 pm UTC
Last updated: February 04, 2020 - 1:51 pm UTC
Version: 12c
Viewed 1000+ times
You Asked
Hi Tom,
We have 200+millions of records in our table, we have to retrieve all the records into text file without impacting the performance. I tried using DBMS_parallel_execute but this doesn’t have return type. Is there a way to get all Millions of records into txt file with out using Parallel in our query?
and Chris said...
Run the query in SQL*Plus/SQLcl in parallel, spooling the output.
e.g.
set feed off
set echo off
set pages 0
spool out.txt
select /*+ parallel */... from ...
spool off
Is this answer out of date? If it is, please let us know via a Comment