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: Reorganisation of a large database table

Re: Reorganisation of a large database table

From: <tuckers_at_ultranet.com>
Date: 1998/07/02
Message-ID: <359C523A.7376@ultranet.com>#1/1

Sigrid Staudte wrote:
>
> 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

You can export to a named-pipe and compress the pipe. Oracle support can E-mail you a script. Received on Thu Jul 02 1998 - 00:00:00 CDT

Original text of this message

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