Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help with large export on Solaris
Thanks Sybrand, I'll start the job tonight.
I found a couple of scripts to pipe the export thru OS compression, but I'll play with those more when I have time
GS
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:iharbu8nmocqvip9mmomk3um9kacblu2sk_at_4ax.com...
> On Wed, 17 Apr 2002 15:22:48 GMT, "Glen A Stromquist"
> <gstromquist_at_nospamyahoo.com> wrote:
>
> >I have a 17 gig Db (8.1.5) on a Sun box I'm trying to export, there is
about
> >9 gig free space where I want to put it. Since most of my other exports
are
> >about 37% of the size of the database, I thought I'd have enough room by
> >specifying 4 2gig .dmp files when exporting.
> >
> >Trouble is I'm now getting a segmentation error before it gets through
the
> >first .dmp file, there is no error# reported or anything else in the log
> >file.
> >
> >I'm wondering if I might be better off to try a compressed export, which
I
> >think there are some scripts floating around out there to do this.
> >
> >I'm also running the export from OEM, but can I point the location of the
> >.dmp file(s) on my local NT machine that I'm running OEM on? Or would I
have
> >to do a share on the local drive, map it from the SUN box etc...
> >
> >Just wondering what the best approach is for this.
> >
> >thanks in advance
> >
> >
>
>
> The segmentation error seems to be specific to 8.1.5 and can be
> avoided by choosing a smaller filesize parameter. 1G works perfectly
> fine. Ran into this myself last week (YES, I have a customer with
> desupported software)
>
> --
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Apr 17 2002 - 16:59:11 CDT