More time to retrieve data from DB

Hi All,

It takes around one hour to retrieve 3 lakhs data from DB. I feel this can be still more reduced, please help me in improvising the below code, to get it retrieve faster, atleast 30 to 45 minutes.

sqlplus -s ${OCAU_DB_UNAME}/${OCAU_DB_UPSWD}@${OCAU_DB_NAME} > /apps/data/filedata.txt 2> /apps/log/FileErrorlog.txt << EOF
set head off 
SET pagesize 0
SET LINESIZE 500
SET LONGCHUNKSIZE 500
SET LONG 320000000
SET RECSEP OFF
set SERVEROUTPUT off ECHO off
SET FEEDBACK OFF
whenever OSERROR EXIT 9
whenever SQLERROR EXIT sql.SQLCODE
SELECT FILEDATA FROM OCAU.FILEUPLOAD_OU WHERE FILESTATUS = 'T' AND FILETYPE = 'ACC' ORDER BY CREATEDATE ASC 
/
exit;
EOF 

[FONT=Courier New][SIZE=4]I guess LONGCHUNKSIZE and LONG makes the trick? Please suggest solution for this

dont you have any index created for the FILESTATUS & FILETYPE ?

Sorry i forget to mention, FILEDATA column is the CLOB data. So 3 lakh records which i said before number of lines in this CLOB data not the number of rows in DB (it is just 9 rows). But still indexing may give betterment?

---------- Post updated at 12:24 PM ---------- Previous update was at 10:02 AM ----------

Any suggestions friends. Need to solve fast.

Not much knowledge on LOB datatypes. If possible drop the order by clause and try it, would save some time.

I have dropped order by but no improvement.. any other suggestion?