Re: BCP out tool to export large table
Date: Fri, 18 Apr 2008 09:21:20 -0700
Message-ID: <1208535679.869966_at_bubbleator.drizzle.com>
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?
-- 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