Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: export/import many files over 2GB limit

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

From: Peter Sylvester <peters_nospam_please_at_mitre.org>
Date: Thu, 12 Jun 2003 09:05:29 -0400
Message-ID: <bc9tqp$lon$1@newslocal.mitre.org>


You can use the FILESIZE (or VOLSIZE for tape) parameters during the export to create a series of files less than 2GB each.

--Peter

Ralf Bender wrote:
> 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:
> /etc/mknod pipename p
> compress < pipename > newfilename.Z &
> exp <username>/<password> file=pipename
> rm -f pipename
>
> But how to with oracle parameter file a
>
Received on Thu Jun 12 2003 - 08:05:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US