Re: UNIX 2 gig size limit.

On Wed, 22 Dec 1999 14:25:44 -0800, Robert Briley <rbriley_at_cp.net> wrote:

>You can get around the oracle export limit or 2 gig by creating a named
>pipe and exporting to it while dumping the data in the pipe to a tape or
>other device. This should allow you to export up to 4 gig on a 2.6
>Solaris machine. Note that in order to import the data again you will
>need to do the same thing and that you are well advised to confirm your
>exports by importing them before you declare success.

I use this way to get around >2GB.
If you need even more space, then beside putting dat into th pige and gzip/compress from there, add a spit command in the end to split into multiple files, containing compressed data.

For import, just go the opposite direction.

Oracle metasite have letters explaing this.

/Bent

>
>Regards
>-R
>
>Tom Karelin wrote:
>
>> Gurus, I need to run export which creates dump file larger then 2 Gig
>> allowed by Unix
>> Anyone has code to solve this problem.
>> Appreaciate your support.
>> I am on Solaris 2.6 Oracle 7.3.4.5
>> Michael
Received on Fri Dec 31 1999 - 03:06:10 CST