Oracle export table to ascii

From: R.A. Joemman <raoul.joemman_at_wanadoo.nl>
Date: 23 Sep 2003 04:13:34 -0700
Message-ID: <e4e5e80f.0309230313.56ad0e49_at_posting.google.com>


Hi,

I try to export a table from sqlplus to a ascii file like this:

select col1 || ';' || col2 || ';' || ..... || ';' || colN from mytable ;

When the table is not so wide, the above query is not so large and the export is succesfull.
But when the table is wide, the query becomes over 1024 characters and I get the following error

ORA-00923: FROM keyword not found where expected

How do I export those wide tables?

Best regards
Raoul Received on Tue Sep 23 2003 - 13:13:34 CEST

Original text of this message