Re: BCP out tool to export large table
Date: Fri, 18 Apr 2008 09:21:20 -0700
> 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
> 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
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?
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Apr 18 2008 - 18:21:20 CEST