Re: select 10000 rows from Oracle in shortest way

On Mon, 23 Jan 2006 21:31:17 GMT, HansF <News.Hans@xxxxxxxxx> wrote,
quoted or indirectly quoted someone who said :

>Generally agree if using the same rdbms. But export from Oracle, import
>to MySQL?

The export format will likely be some flavour of CSV. IF you are
lucky, identical. If not, you could cook up a converter using
http://mindprod.com/products1.html#CSV

The key is to avoid the commit/rollback logic on each record.

This sticks in my mind from a RFP I was involved in to purchase a new
mainframe for my employer BC Hydro. We required a benchmark that at
one point involved a database load. The Univac (now Unisys people)
were inexperienced and did not realise this load problem.. The
database load took about 24 hours. The pro-IBM forces at BC Hydro
refused to let them have another shot at it, avoiding the
commit/rollback logic.

--
Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.
.