Re: BCP out tool to export large table
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Wed, 23 Apr 2008 20:57:43 -0500
Message-ID: <8MRPj.5556$iK6.218_at_nlpi069.nbdc.sbc.com>
>> Hello,
>> I am trying to find an oracle tool to export the content of a 20
>> million records (on 22 col that contain number, varchar, float data
>> type) much like a bcp tool would do for sybase or sql.
>> So far I tried oracle sql developper which did not proved to be
>> fast/efficient.
>> Sqlldr only loads data into table.
>> sqlplus with a spool option is too slow for tables of that size.
>>
>> Does anyone would know a simple oracle tool that could help me?
>> I am working under 10G environment on a windows XP client machine.
>> Server is 10.2.0.1.
>>
>> thanks
Date: Wed, 23 Apr 2008 20:57:43 -0500
Message-ID: <8MRPj.5556$iK6.218_at_nlpi069.nbdc.sbc.com>
DA Morgan wrote:
> news.free.fr wrote:
>> Hello,
>> I am trying to find an oracle tool to export the content of a 20
>> million records (on 22 col that contain number, varchar, float data
>> type) much like a bcp tool would do for sybase or sql.
>> So far I tried oracle sql developper which did not proved to be
>> fast/efficient.
>> Sqlldr only loads data into table.
>> sqlplus with a spool option is too slow for tables of that size.
>>
>> Does anyone would know a simple oracle tool that could help me?
>> I am working under 10G environment on a windows XP client machine.
>> Server is 10.2.0.1.
>>
>> thanks
> > Export for what purpose? > > If to put in another Oracle database there is one answer ... if to put > into another company's product then name it. > > It makes a difference. > > PS: Why are you working on totally unpatched software?
and on ---gaaaggg--- windows - and being on windows it doesn't matter what tool you use - it will be slow. Received on Thu Apr 24 2008 - 03:57:43 CEST