Re: BCP out tool to export large table

From: Frank van Bortel <>
Date: Fri, 18 Apr 2008 19:37:36 +0200
Message-ID: <c3af1$4808dc60$524b5c40$> 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
> thanks
What is the prupose you need all data in human readable format? Will EXP not do (especially with DIRECT=Y option)? Received on Fri Apr 18 2008 - 19:37:36 CEST

Original text of this message