gibboniser_at_gmail.com wrote:
> I'm not too worried about overwriting the datafiles - unless there's
> something important that I'm missing (which is quite probable!).
> Regarding commit=y, I'm not sure what constitutes a very large table -
> the largest in this particular database contains over 200000 rows, and
> there are several in the tens of thousands. I guess that isn't so
> massive :)
>
> I shall carry on tinkering!
>
> Thanks,
>
> Rob.
>
No, large as in multi-mullion. There's a chance you run out
of rollback space - it's all (table-wise, that is, not the
whole export) one transaction, and commit=y makes it lots of
small (every x records) transactions.
--
Regards,
Frank van Bortel
Received on Tue Mar 15 2005 - 06:40:34 CST
