Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: export db problem
just tested the 8.1.7 exp to multiple files - worked great. I generated 5 dmp files of 2G each. Then proceeded to export to a filesystem set to handle large files (HP UX 11.0/ LSI array) and created a 9+gb export file without pipe thru compress...works great.
"Spencer" <spencerp_at_swbell.net> wrote in message
news:rQIh6.54$cC2.152095_at_nnrp3.sbc.net...
> maximum size of dmp file from export is 2GB. this is a limit of
> the exp utility. there are several workarounds to the problem.
>
> one approach is to redirect the output of exp to a pipe (rather
> than a file) and reading the pipe from another utility that does
> not have the 2GB limit. with this approach, you will also need
> to implement a similar workaround to deal with the 2GB limit
> of the imp utility.
>
> another approach is to export smaller pieces of the database
> (e.g. by owner) such that each .dmp file will be under the 2GB
> limit.
>
> in the latest releases (oracle 8.1.x), new functionality has been
> introduced in exp to help deal with the 2GB limit.
>
> "Steve" <schen_at_prodigy.net> wrote in message
> news:967b5p$fma$1_at_newssvr05-en0.news.prodigy.com...
> > Thank you for the help. Do you know if it can be set up as 4G in size
(in
> > Unix)?
> >
> >
> >
> > Andreas Schlager <aschlager_at_eunet.at> wrote in message
> > news:Jsjh6.17$do.3658_at_nreader1.kpnqwest.net...
> > > "Steve" <schen_at_prodigy.net> wrote in
> > > <9626ed$5bfa$1_at_newssvr05-en0.news.prodigy.com>:
> > >
> > > >I have problem exporting a 4G V7.3 db. I put it run in cron on
> > > >weekend, but it ended up with 500M bmp file then stopped with
internal
> > > >error.
> > >
> > > Hi Steve,
> > >
> > > if you are working on some kind of unix, check the max.
filesize-parameter,
> > > that says how big files a user can create. I think this is different
in
> > > each unix-derivate.
> > >
> > > Andy.
> >
> >
> >
>
>
Received on Mon Feb 12 2001 - 15:21:21 CST