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 > BCP out tool to...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 2737 of 2780
Post > Topic >>

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

by "news.free.fr" <grille11@[EMAIL PROTECTED] > Apr 18, 2008 at 04:23 PM

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
 




 4 Posts in Topic:
BCP out tool to ex****t large table
"news.free.fr"   2008-04-18 16:23:57 
Re: BCP out tool to ex****t large table
DA Morgan <damorgan@[E  2008-04-18 09:21:20 
Re: BCP out tool to ex****t large table
Michael Austin <mausti  2008-04-23 20:57:43 
Re: BCP out tool to ex****t 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
tan13V112 Thu Jul 24 5:55:33 CDT 2008.