Re: Fastest way to ASCII file or other ideas?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 04 May 2007 08:32:12 -0700
Message-ID: <1178292729.112298@bubbleator.drizzle.com>

g.wang wrote:

> Fastunload from CA can extract data from tables very fast, it by pass 
> database server, and scan the data file block directly. It can produce text 
> format or Oracle dump format.
> 
> George Wang
> "DA Morgan" <damorgan_at_psoug.org> wrote in message 
> news:1178228912.774420_at_bubbleator.drizzle.com...

>> joel garry wrote:
>>
>>> Sometimes the simplest way is the fastest way. I bet many people
>>> would be interested in what you find in speed difference between
>>> sqlplus and pro-c and perl. I suspect there won't be much, but
>>> haven't tested in this century.
>>> jg
>> I'm in agreement in that I suspect there won't be much difference
>> but haven't tested it in a very long time.
>>
>> SELECTing is not going to be faster no matter what tool you use.
>> And writing isn't going to be faster either. So where is the
>> speed difference from C or perl? Formatting perhaps.
>>
>> I'd be interested in why/how pipes would be affected by an auditing
>> requirement.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org

Please don't top post.

Unless I had a totally vanilla, every table is a heap table, database I'd be nervous. The chances of CA recognizing LOBs? IOTs? GTTs? Partitioning? Hash clusters? Do you know?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri May 04 2007 - 10:32:12 CDT