Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: export db problem
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 Sun Feb 11 2001 - 21:33:54 CST
![]() |
![]() |