Re: Exporting large tables

Rich, I'm on DG as well. I had to compress exports (using the compress through a pipe) in several iterations of so many tables each to move a 60+ GB database. You can't use split on DG as the DG implementation of split only works with ascii text files. We are truly cursed with this piece o' garbage OS...

Scott Shafer
San Antonio, TX

• Original Message ----- From: "Klavers, Richard" <R.Klavers_at_arbeidsbureau.nl> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, May 25, 2000 8:11 AM Subject: Exporting large tables

> Hi,
>
> I am trying to export a very large table, more than 2Gb, on a 7.3.4 DB on
a
> Data General Unix machine.
> The export is being written to a filesystem on another machine via a NFS
> mount. The filesystem is 32Gb in size.
> When the exportfile reaches 2Gb, the export terminates.
> How can i safely export my large tables without being terminated when the
> 2Gb filesize is reached?
> I can't do a backup/restore action of the datafiles, because the new DB is
> on raw disks.
>
> Thanx in advance.
>
> Greetings, Richard Klavers.
>
>
> --
> Author: Klavers, Richard
> INET: R.Klavers_at_arbeidsbureau.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu May 25 2000 - 11:14:31 CDT