-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > Well, COPY will give you the best performance. It's also fairly flexable > when it comes to formatting. It shouldn't be difficult to get Oracle's > export tool to generate data that COPY can load. With Oracle, everything is difficult. Their export utility does not have a way to dump things as a series of INSERT commands, nor as tab-delimited data. There are other tools/scripts around that can do this, but as a general rule, the word "difficult" is one of the more mild adjectives usually found in the same sentence as "Oracle utility". :) - -- Greg Sabino Mullane greg@xxxxxxxxxxxx PGP Key: 0x14964AC8 200509101614 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFDIz7IvJuQZxSWSsgRAthrAJ9YaHzRCcaixLJ+N6WyWVYmoxXpMgCcCz6T iVfCGIk7hASpQMawDEWzzaY= =jFH3 -----END PGP SIGNATURE-----