Re: Export a 3 gigabyte database

From: <rprabha_at_my-dejanews.com>
Date: Mon, 01 Feb 1999 02:15:18 GMT
Message-ID: <7932ni$sfm$1@nnrp1.dejanews.com>

In article <791t87$mmm$1_at_news.ctimail.com>, "Timothy Leung" <tleung_at_ctimail.com> wrote:
> I am trying to export the Oracle 7.3.4 entire database from Sun Solaris OS.
> Since the file system does not allow a file larger than 2 Gigabytes. Is
> there any way to split the export file? Further, I have the same problem on
> NT also.
>
> Thanks in advance!
> Tim
> Hi Tim

> Tim

you could also try the following : login as superuser and create the pipe by typing following at unix dollar prompt.

mknod exp_pipe.dmp p
chmod +rw exp_pipe.dmp

Inside the shell script type following commands

cat exp_pipe.dmp | compress > my_export_file.Z & exp system/pass file=exp_pipe.dmp log=my_exp.log

Rajeev

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Jan 31 1999 - 20:15:18 CST