Re: Q: export/import many files over 2GB limit

From: michael ngong <mngong_at_yahoo.com>
Date: 13 Jun 2003 10:51:14 -0700
Message-ID: <ecf365d5.0306130951.3e3abf58@posting.google.com>

Ralf Bender <ralf.bender_at_arcor.de> wrote in message news:<3ee72493$0$6786$9b4e6d93_at_newsread4.arcor-online.net>...
> Hi
>
> I'm using Oracle 8.1.7 on Linux.
>
> I want to export the full database, which has a size of 10 GB. Running
> export with parameter file to create files under the 2GB file limit
> works. But right now there not enough space to create all files.
>
> Is there a way to directly compress all created files? I found a way to
> do so with one file:

On target Insert pipename in place of export file in the parameter file and you should be fine

> /etc/mknod pipename p
> compress < pipename > newfilename.Z &
> exp <username>/<password> file=pipename
> rm -f pipename
>
> But how to with oracle parameter file

Michael Tubuo Ngong Received on Fri Jun 13 2003 - 12:51:14 CDT