Re: Large Table Migration to another m/c
Date: Sun, 20 Mar 1994 20:12:24 GMT
Message-ID: <1994Mar20.201224.11711_at_oracle.us.oracle.com>
In article <CMr3M8.Dx8_at_shakti.ncst.ernet.in> hemant_at_shakti.ncst.ernet.in (STOCKHOLDING CORPORATION OF INDIA LTD.) writes:
>
>We have a table having in excess of 20million rows. We expect that the
>export file will exceed 2GB.
>Our current implementation is Oracle 6.0.33 on DG/UX 5.4.2 on an Aviion. (M88K)
>Since the machine does not support files in excess of 2GB we shall not
>be able to export the table.
>
>To circumvent the problem, we are currently exporting the table to a
>pipe-file from which we are doing a compressed write to disk-file, whereby
>the disk file is about 400MB.
>
>However, we now want to move the table to another machine. We undestand
>that a file compressed on one OS and chip cannot be uncompressed on
>another Unix and chip (which will be the case).
>
>Could you please suggest alternatives ?
>
Shiraz Kanga
skanga_at_oracle.com
-- Shiraz Kanga (skanga_at_oracle.com) Tel: (415)506-5412 Fax: (415)506-7822 Analyst -- Desktop Netware Group - Worldwide Technical Support - 3OP11 Oracle Corporation 500 Oracle Pkwy, MS 659311, Redwood Shores CA 94065 "I work for Oracle - I speak and type (over here at least) for myself"Received on Sun Mar 20 1994 - 21:12:24 CET