Re: Export a 3 gigabyte database

From: <rprabha_at_my-dejanews.com>
Date: Mon, 01 Feb 1999 02:10:10 GMT
Message-ID: <7932du$sc8$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
>
>

Tim

You can try following Unix solution. To create the special file :
1. Login as superuser (or as oracle, if system permits it) and

create the special pipe file as follows :

At unix dollar prompt do the following . mkfifo exp_pipe.dmp
chmod +rw exp_pipe.dmp

2. Create the shell script file exp_cmp.sh

cat exp_pipe.dmp | compress > my_export_file.dmp.Z & exp system/pass file=exp_pipe.dmp
3. Run the script file to get desired result.

Hope this helps ..
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:10:10 CST