I used this sequence of commands :

set verify off;
set term off; //also with set termout off tried both seperately
set linesize 6000;
set feedback off;
set pagesize 0;
set echo off;
set sqlprompt '';
set trimspool on;
set termout off;
spool out_C1.txt

It STILL displays the rows ... I don't want sql*plus scroll 1/2 million records. Basically, I want to spool the records to a text file ... Is this the right way?

Thanks