Displayed below are the messages of the selected thread.

Thread Status: Closed

From: Kirk Williams 05-Sep-01 05:21
Subject: Re: Out of space on export

RDBMS Version: 7.3.4
Operating System and Version: Solaris 2.6
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.):
Product Version:

Re: Out of space on export

I am exporting a 7.3.4 database to a Solaris file system that is marked as accepting large files(> 2Gb). However, it is failing at exactly 2Gb. Anyone know if this is the correct behavior? I suspect not. Any hints would be appreciated.

Thanx in advance,

 

From: Rakesh Tripathi 06-Sep-01 14:14
Subject: Re : Re: Out of space on export

I don't suspect that there is anything wrong with Export. You may look out for various other possible reasons, viz. availability of space on the Solaris file system where export is carried out or restriction on the Solaris user through which you are logged in for taking export

Rgds,

Rakesh Tripathi

 

From: Arvind Iyengar 06-Sep-01 18:06
Subject: Re : Re: Out of space on export

I believe that the 7.3.4 Oracle utilities like export, import and SQL Loader had a restriction of 2 GB files that they could work with.
There are a few options that you can try if the export file you are writing is getting to be larger than 2 GB. The one I have used in the past is to pipe the export to the compress/uncompress commands to create a smaller file. The commands for that are something like this:

Export
## Create a pipe using:
mknod /tmp/exp_pipe p
## Start compress in the background to receive data from the pipe
compress < /tmp/exp_pipe > export.dmp.Z &
## Start export to write to the pipe
exp file=/tmp/exp_pipe <other options>

Import
## Create a pipe using:
mknod /tmp/imp_pipe p
## Start uncompress in the background to send data to the pipe
uncompress < export.dmp.Z > /tmp/imp_pipe &
## Start import to read from the pipe
imp file=/tmp/imp_pipe <other options>

Its been a while since I have used this, so please try out the export and import on a test system to make sure you can read what you write out.

Also, there are other options like 'split' to break the file into multiple chunks of less that 2 GB. Maybe someone can post the syntax for that.

Hope this helps.