RE: Export of very big table

On Thu, 28 Dec 2000, you wrote:
> Hello and good-morning (It is for me!)
>
> I am using Rachel's scripts now too. The difference could be in the omission
> of the 'direct' parameter while exporting. Usually we use it, but they are
> not in Rachel's script.
> I cannot see if it works yet, for I exported 19.000.000 rows yesterday and
> started to import them at 16:00. Now it's 7:30 (Here in Holland) and it only
> imported 7.000.000 rows up till now.... (15h30m 7.000.000 => 42h import time
> :o(

Have you dropped your indexes (if possible) prior to the import? The import will occur many times faster if no index maintenance is needed. Also, you may want to have analyze=n in the parfile (analyzing a large table may add hours to the import time).

Cheers,
GC

-- 
"The opposite of a correct statement is a false statement. But the opposite 
of a profound truth may well be another profound truth." 
                                    --Niels Bohr