Re: Dumping contents of a view to CSV file
Date: Thu, 27 Oct 2011 09:20:16 -0700
Message-ID: <CAGXkmitBVv6rKovc5Xbv3GdyCV3sZr_juv7Xs9zHe02q9DRUkA_at_mail.gmail.com>
Download a trial of WisdomForce FastReader http://www.wisdomforce.com/products-FastReader.html
It should do everything you need, including the ability to compress, split and parallelize the export.
On Wed, Oct 26, 2011 at 2:59 PM, Steve Wales <sjwales_at_comcast.net> wrote:
> Hello,
>
> I've been tasked with generating a CSV file with the contents of a view in
> an old database as an extra copy before the DB is decommissioned.
>
> I've done this in the past for smaller tables or views without issue.
>
> There are 80 million rows in the view, full row length is 5500 bytes (most
> probably shorter since the columns on the base tables are mostly varchar2).
>
> Doing the math on that, that's a maximum possible size of 440GB.
>
> I had seen a stored procedure on a website somewhere that read through a
> cursor and dumped the records out to a text file via utl_file.put. Anyone
> have a better method or is that my best option ? I've had some TEMP
> tablespace failures, I may just need to allocate a bunch of space in temp,
> kick it off one afternoon and let it run overnight.
>
> I've could shrink the overall output size of the file by running "trim" on
> the columns too.
>
> Any ideas appreciated.
>
> Environment: Oracle 9.2.0.7 on HP-UX 11.11
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 27 2011 - 11:20:16 CDT