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 -> Q: export/import many files over 2GB limit

Q: export/import many files over 2GB limit

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Wed, 11 Jun 2003 14:46:11 +0200
Message-ID: <3ee72493$0$6786$9b4e6d93@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:
/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 Wed Jun 11 2003 - 07:46:11 CDT

Original text of this message

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