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<http://asktom.oracle.com/%7Etkyte/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.
>
