Re: Faster imports

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Wed, 19 Jan 2000 12:11:03 +0000
Message-ID: <g7qqsBAXnah4EwWB@ahardy.demon.co.uk>

In article <lZ+FOMmp8RdHB7AHFJ00p7=icIbC_at_4ax.com>, Paul Moore <paul.moore_at_uk.origin-it.com> writes
>Can anybody suggest any ways of speeding up an import of a user or
>table on Oracle (7.3.3.4, 8.0.5, or 8.1.5, i'm interested in all of
>them!)
>
>Specifically, we have a very large database containing tables of sizes
>up to 4G. Exporting is not a great problem (direct path export, buffer
>size = lots, etc etc), but imports take ages. As far as I can see,
>there is no way of running import in direct path mode, or anything
>similar - even if we are loading data into a (pre-created but empty)
>table.

Any chance that you could use flat files and then the sqlload 'direct' option?

Andy
--
Andy Hardy. PGP key available on request

Received on Wed Jan 19 2000 - 06:11:03 CST