Home » RDBMS Server » Server Utilities » Export file limit exceeded core dumped
Export file limit exceeded core dumped [message #70580] Wed, 03 July 2002 00:35 Go to next message
Vishweshwara Bhat
Messages: 6
Registered: June 2002
Junior Member
Hi,
I have one problem , while taking the export of a database, got error message as file limit exceeded core dumped i.e the file size of the export file is more than 2GB. EXP utility is not writing to the file of more than 2GB size. The OS is unixware 7.1 which is supporting the large filesize of more than 2GB. The Oracle rdbms version we use is 8.0.5. Please clarify how to take the export backup in this situation.

Vishweshwara bhat
Re: Export file limit exceeded core dumped [message #70583 is a reply to message #70580] Wed, 03 July 2002 07:16 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
this may help you.
1. Exporting directly to tape 
   
VOLSIZE should be < tape capacity 
% exp userid=system/manager full=y file=/dev/rmt/0m volsize=145M 
After EXP has written <VOLSIZE> to the tape, it will prompt for next:
Please mount the next volume and hit <ret> when you are done.

2. Exporting to tape via unix named pipes

Note: 'dd' for tape devices may need 'bs=8k' or  similar depending on tape
% mknod /tmp/exp_pipe p		            # Make the pipe
% dd if=/tmp/exp_pipe of=<tape device> &    # Write from pipe to tape
% exp file=/tmp/exp_pipe <other options>    # Export to the pipe  

3. Creating a compressed export file
% mknod /tmp/exp_pipe p                     # Make the pipe
% compress < /tmp/exp_pipe > export.dmp.Z & # Background compress
 exp file=/tmp/exp_pipe <other options>    # Export to the pipe
 
4. Export to several files
(Note: Not all platforms support the split "-b" option used here)
% mknod /tmp/exp_pipe p		           # Make the pipe
% cd /fs_with_25gig_freespace		   # Make sure disk has space
% split -b2047m < /tmp/exp_pipe &	      # Split input to 2Gb chunks
% exp user/passwd file=/tmp/exp_pipe full=y  # Export to the pipe
  
This will split the export into several files called 'xaa', 'xab', 'xac' all of size 2047Mb. These can be fed back into import thus:
% mknod /tmp/imp_pipe p                      # Make the pipe
% cd /fs_with_25gig_freespace		      
% cat xaa xab xac > /tmp/imp_pipe &	      # Put files into the pipe
% imp user/passwd file=/tmp/imp_pipe	      # And import

The 'man' page for split shows options to generate more meaningful file names.
 
WARNING: Some versions of 'split' are very poor performance wise.

5. Export >2GB
  Use the split example above 
  OR
  Export to a NAMED PIPE and use unix 'cat' or 'dd'
  to  copy from this to 
  a large file. The 'cat' or 'dd' command must
  support  64 bit write and
  read offsets. Use the reverse for import. 
Previous Topic: Importing Problem
Next Topic: SQl Loader :524 Error
Goto Forum:
  


Current Time: Tue May 07 14:12:40 CDT 2024