BCP out tool to export large table
From: news.free.fr <grille11_at_yahoo.com>
Date: Fri, 18 Apr 2008 16:23:57 +0200
Message-ID: <4808ae4b$0$1030$426a74cc_at_news.free.fr>
Hello,
[Quoted] [Quoted] I am trying to find an oracle tool to export the content of a 20 million [Quoted] 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.
Date: Fri, 18 Apr 2008 16:23:57 +0200
Message-ID: <4808ae4b$0$1030$426a74cc_at_news.free.fr>
Hello,
[Quoted] [Quoted] I am trying to find an oracle tool to export the content of a 20 million [Quoted] 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 Received on Fri Apr 18 2008 - 16:23:57 CEST