Re: Exporting > 2 GB Table
Date: 1995/04/27
Message-ID: <798975497snx_at_kbigate.stgt.sub.org>#1/1
gendron_at_cam.org writes in article <gendron-2604951017280001_at_gendron.hip.cam.org>:
>
> All,
>
> On HP-UX, there is a limitation of 2 GB on the size of a single O/S
> file. We need to export a table which is 3 GB in size.
>
If the table occupies 3 GB on your database, there is a possibility that your export-file uses less space - depending on the type of data stored, PCTFREE / PCTUSED parameters...
But there is also a possibility that it occupies _more_ space ...
> Could anyone who has ideas as to how we can handle this situation please
> send me a short description of a method to use.
IMHO you have two options:
- EXPORT / Import to / from tape (assuming you have a device which can handle this size
- Use "on the fly" compression. Example:
mknod expdat.dmp
cat expdat.dmp | compress >exportfile.compress &
exp uid/pwd file=expdat.dmp
>
> Please reply by mail and,
> Thank you very much for any response,
>
> --
> Francois G. Gendron Internet : gendron_at_cam.org
> Conseiller Principal Telephone: (514) 942-6287
> Champagne, Parent & Associes Inc. Montreal, Quebec
>
Willys Mail FidoNet 2:2474/117 2:2474/118 willyk_at_kbigate.stgt.sub.org VFC ISDN/X.75-> No Request from 06.00 to 08.00 <-
Received on Thu Apr 27 1995 - 00:00:00 CEST