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


Other related posts: