Re: Exporting > 2 GB Table

From: Willy Klotz <willyk_at_kbigate.stgt.sub.org>
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:

  1. EXPORT / Import to / from tape (assuming you have a device which can handle this size
  2. 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

Original text of this message