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 4 of 4 Topic 2737 of 2833
Post > Topic >>

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

by Frank van Bortel <frank.van.bortel@[EMAIL PROTECTED] > Apr 18, 2008 at 07:37 PM

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
> 
> 
What is the prupose you need all data in human readable format?
Will EXP not do (especially with DIRECT=Y option)?
 




 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 19:35:39 CST 2008.