Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Tools > Re: BCP out too...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 4 Topic 2737 of 2833
Post > Topic >>

Re: BCP out tool to ex****t large table

by Michael Austin <maustin@[EMAIL PROTECTED] > Apr 23, 2008 at 08:57 PM

DA Morgan wrote:
> news.free.fr wrote:
>> Hello,
>> I am trying to find an oracle tool to ex****t 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
> 
> Ex****t 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.
 




 4 Posts in Topic:
BCP out tool to export large table
"news.free.fr"   2008-04-18 16:23:57 
Re: BCP out tool to export large table
DA Morgan <damorgan@[E  2008-04-18 09:21:20 
Re: BCP out tool to export large table
Michael Austin <mausti  2008-04-23 20:57:43 
Re: BCP out tool to export large table
Frank van Bortel <fran  2008-04-18 19:37:36 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 20:17:07 CST 2008.