in reply to Getting from Oracle to become a text file

You can also do this through Oracle's SQL*Plus -- connect to D001 as develop/developerPW and run the following SQL script:

SET FEEDBACK OFF SET PAGESIZE 0 SELECT batch_line FROM admin.batch_lines SPOOL batch_test.txt / SPOOL OFF