Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: from x86 -> alpha

Re: from x86 -> alpha

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Tue, 19 Jan 1999 19:35:40 GMT
Message-ID: <g85p2.535$5W2.96575@client.news.psi.net>


Hi,

    Since you seem to be stuck with export/import be sure to try the DIRECT=Y option. If it will work for you it is much faster than the default conventional path. To give you an idea I got the following results this morning:

    Default (DIRECT=N) 13 minutes 34 seconds

    DIRECT=Y                      3 minutes 17 seconds

Environmental factors:

    Oracle 8.0.5 on Red Hat Linux 5.2
    200 MHz Pentium II 96MB RAM 6.2GB Disk

    The export file is just about 200MB in size

Not being a fan of export/import (primarily due to performance considerations) I was impressed.

regards

Jerry

mgyuri wrote in message <7804ai$qea_at_helka.iif.hu>...
>Alan !
>:) I am not in position to drop NT boxes, and digital alpha is fine.
>copy did not work, so I have to choose exp/imp, even there are millions of
>rows.
>
>Alan Way wrote in message ...
>>
>
>>The fastest way of moving? Why NT then?
>>
>>Copying is probably not a good idea. Use export/import instead if
>>practicable.
>>
>>Sacs
>>
>>
>
>
Received on Tue Jan 19 1999 - 13:35:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US