shame on me for not coming to the list with a question to "answer" a question, but although I haven't gotten around to testing it, I believe external tables are writable...seems you could create the external table and do a CTAS ? I need to go look into that ... ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Stefan Knecht Sent: Thursday, October 19, 2006 10:22 AM To: Roger.Xu@xxxxxxxxxxx Cc: oracle-l Subject: Re: dump to CSV (comma-separated values) file format http://asktom.oracle.com/~tkyte/flat/index.html Stefan On 10/19/06, Roger Xu < Roger.Xu@xxxxxxxxxxx> wrote: Hi List, I remember in the past someone shared a script which dumps tables to CSV files. If anybody has it and is willing to share, I do not have to write it myself. Thanks, Laziest DBA in the world This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System.