RE: Exporting large tables

Scott,

aren't we the lucky ones or what? Life is far too easy with a good OS...this OS keeps us from the streets and out of the bar..but I am not too happy with the last...

We managed the export of >2Gb tables by using raw disk for the export as well. Didn't know it was possible, but as you see it can never hurt trying. One of our Unix guys came up with the idea, and to our surprise it worked. The next step is to move the raw disk to the other system using DD to tape. I hope the import works with raw disks as well...we keep on trying. I let you know.

Like my mom said, I better finish school to get a good job rather than being a DBA...

Greetings, Richard Klavers.

> ----------
> Van: Scott Shafer[SMTP:scott.shafer_at_ildmail.com]
> Antwoord naar: ORACLE-L_at_fatcity.com
> Verzonden: donderdag 25 mei 2000 19:19
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: 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 -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, May 25, 2000 8:11 AM
>
>
> > 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).
>
> --
> Author: Scott Shafer
> INET: scott.shafer_at_ildmail.com
>
> 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
Received on Fri May 26 2000 - 00:49:28 CDT