Re: Export Oracle Data Error!

From: <le_fort_at_my-deja.com>
Date: Fri, 29 Dec 2000 11:20:36 GMT
Message-ID: <92hs22$4j4$1@nnrp1.deja.com>

Hi Paul,

perhaps you want to use pipes, for example : mknod /tmp/your_pipe p
gz < /tmp/your_pipe > your_dump.dmp.gz & exp ... FILE=/tmp/your_pipe ...

There should be plenty examples for this on various pages if you need further details. You might have a look at www.timonions.com/tlinks.html for links. I guess your problem is answered in a FAQ (merely a guess, 'cause I have seen it being asked often)

Hope that helped,
le_fort

In article <926cjc$ssm$1_at_news.ethome.net.tw>, "PaulWang" <wpaul_at_ethome.net.tw> wrote:
> Dear all.
> We use Oracle8i on HP server and we use the Export utility to export
oracle
> user data everyday, but we got error and fail to export the data when
the
> data exceed 2GB, how can we do? we use this as kinds of backup method
and
> import it sometimes to our testing server!
> Thanks in advance!
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 29 2000 - 05:20:36 CST