Re: Reorganisation of a large database table

Just do it to disk via a pipe.

1. 'mknod exp_pipe'
2. point you export at the pipe: 'file=exp_pipe' in you export parameter file.
3. Start the export in the background (i.e., end it with an '&')
4. Start another job to read the pipe to a compressed file: 'compress <exp_pipe >myfile.dmp.Z

MotoX.

Sigrid Staudte wrote in message <359BDAD5.157F5B51_at_sachsenlb.de>...
>Hallo,
>
>at first thanks for help in news and mail.
>But I have not yet solve the proplem with reorganize of the very large
>table. The exportfile created by the oracle export utility is larger
>than 2 GByte (probably 6 GByte), but 2GByte is the limit of filesize,
>which can handled under sun solaris 2.5.
>The oracle support sais the only way to create such a large export file
>is to export to a tapedrive, but I haven`t experiences with exporting to
>an tape. Is it correct to specify the exportfile at the following way:
>(rmt is the mountpoint for the tapedrive)
>
>file..< /dev/rmt/0hbn/{filename} volsize={max. size at the tape in
>byte}
>
>Who can help me ??? :-)
>
>Regards...
>
>Sigrid
Received on Fri Jul 03 1998 - 00:00:00 CDT