Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: On Solaris 2.6 and the 2Gb export file limit

Re: On Solaris 2.6 and the 2Gb export file limit

From: Jesper <gollum_at_image.dk>
Date: Tue, 18 Jan 2000 17:30:18 GMT
Message-ID: <3884a242.8491650@news.image.dk>


On Tue, 18 Jan 2000 09:38:40 +0100, Doktor <doktor_at_post.pl> wrote:

>sharon_bleich wrote:
>>
>> You need to export while compressing the file to a pipe. It's not a
>> Solaris issue, it's an export utility issue.
>>
>
>Or export to the tape ...

...or even simpler: Use the "stdout" file descriptor in exp:

$ exp userid=system/manager file=stdout ... | compress >exp.dmp.Z

Unfortunately "stdin" cannot be used with import, so you will need to use the named pipe, ie.:

$ mknod pipe p
$ zcat exp.dmp.Z > pipe &
$ imp userid=system/manager file=pipe ...

/Jesper Received on Tue Jan 18 2000 - 11:30:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US