RE: dump to CSV (comma-separated values) file format

  • From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 19 Oct 2006 10:26:04 -0700

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
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
        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.
                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.

Other related posts: