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

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Thu, 19 Oct 2006 10:26:04 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD001C3328A@ex2.ms.polyserve.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stefan Knecht

	Sent: Thursday, October 19, 2006 10:22 AM
	To: Roger.Xu_at_dp7upbg.com
	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_at_dp7upbg.com> 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.                 

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 19 2006 - 12:26:04 CDT