Re: Export a table in Unix > 2Gb.

You create a pipe, export to it, and compress the pipe output.

To Export:

1. mknod export_pipe p
2. (cat export_pipe | compress > myexportfile.dmp.Z &); exp system/manager file=export_pipe

To Import:

1. (zcat myexportfile.dmp.Z > export_pipe &); imp system/manager file=export_pipe

Of course, if you are on DEC Alpha, there is no 2 GFig file limit !!!

Alan V

Fernando Carrillo wrote in message <6gdien$q1d$1_at_ul3.satlink.com>...
>There is a Unix limitation where you can’t have a file greater than 2 GB,
>but when I want to make an export of only one table, and that export is
>greater than 2 GB, I have problems (the export aborts)
>Can anyone help me with this?
>( I’m working with Unix HP-UX 10.20 and Oracle 7.3 )
>
> Thanks
>
>
>
>
>
>
>
Received on Thu Apr 09 1998 - 12:23:56 CDT