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 ?