-
Exporting to Multiple dump files in Oracle 7
Is there a way in Oracle 7 by which we can export into multiple files. My problem here is that i have tables in a schema of 6GB size.Now i want to export them and make sure that the dump file size does not increase the 2 GB limit.
Any Suggestions
Thanks
Sam
-
No. exp to a named pipe that does compress. Search this site for several thousand examples.
Jeff Hunter
-
The code given below I used extensively in Oracle 7.
The credit must go to Deverajan Sundaravardan.
PHP Code:
# January 16, 1998
# Exporting a Database That's More Than 2GB When Compressed
# This Tip of the Week entry comes from Devarajan Sundaravaradan,
# a Senior Consultant for Leading Edge Systems, Inc. in Edison, New Jersey.
#
# Also, consider mkfifo command in HP, instead of mknod command.
#
# In HP-UX, there is a 2GB limit on file sizes of 2GB.
# Many of us have reached this limit when exporting files and
# the most common solution is to do a filesystem compression of the
# export dump using named pipes and then store the compressed file.
# But what if the compressed file itself passes the 2GB limit?
# There is solution to this, too.
# --------- Export Section
# Create new Named pipes.
mknod -p /dev/split_pipe
# You can use the existing named pipe itself, instead of creating new.
mknod -p /dev/compress_pipe
======================================================
# Create a shell script under a file, named Split_export.sh
=======================================================
# -b1000m indicates to split command to split the input file into
# every 1000 MB size.
# As it splits, the split command will suffix aa, ab, ac, ad ... upto zz
# to the file name specified.
# The export file name is expfile.
nohup split -b1000m < /dev/split_pipe > /DumpDir/expfile &
nohup compress < /dev/compress_pipe > /dev/split_pipe &
exp username/password full=y file=/dev/compress_pipe and other parameters for export.
==========================================================
# After saving the above three commands in split_export.sh,
# execute the following.
=========================================================
chmod a+x split_export.sh
nohup split_export.sh > /tmp/split_export.log 1>&2 &
=============================================================
After a few minutes you should see files in the export dump directory.
===========================================================
------------------ IMPORT Section
========================================================
# Create a shell script with the following command
# under the file name split_import.sh.
# After creating provide execution permission to this script as follows:
=========================================================
Chmod a+x split_import.sh
# The import script assumes in this example that the
# above export script created 2 split files
# called expfileaa and expfileab. The order of the file for the
# cat command is very important.
nohup cat /dumpdir/expfileaa /dumpdir/expfileab > /dev/split_pipe &
# sleep 3 seconds
Sleep 3
nohup uncompress < /dev/split_pipe > /dev/compress_pipe &
# Sleep at this point is very important as some time is needed
# to uncompress the file and send it to the pipe.
sleep 60
imp username/password file=/dev/compress_pipe and other parameters for export.
nohup split_import.sh > /tmp/split_import.log 1>&2 &
=====================================================
Wait for the import to finish.
=====================================================
Tamil
-
You can't use...
FILE=D:\EXPORT\YO_MOMMA_1.DMP
FILE=D:\EXPORT\YO_MOMMA_2.DMP
FILE=D:\EXPORT\YO_MOMMA_3.DMP
FILE=D:\EXPORT\YO_MOMMA_4.DMP
filesize=1900M
in version 7?
I remember when this place was cool.
-
Re: Exporting to Multiple dump files in Oracle 7
Originally posted by samx18
Is there a way in Oracle 7 by which we can export into multiple files. My problem here is that i have tables in a schema of 6GB size.Now i want to export them and make sure that the dump file size does not increase the 2 GB limit.
Any Suggestions
Thanks
Sam
Enable large files in your Unix environment.
I remember when this place was cool.
-
Originally posted by Mr.Hanky
You can't use...
FILE=D:\EXPORT\YO_MOMMA_1.DMP
FILE=D:\EXPORT\YO_MOMMA_2.DMP
FILE=D:\EXPORT\YO_MOMMA_3.DMP
FILE=D:\EXPORT\YO_MOMMA_4.DMP
filesize=1900M
in version 7?
Ah, grasshopper, you're showing your lack of experience.
Jeff Hunter
-
I came on board in version 8, that is why I asked.
I remember when this place was cool.
-
exp user/pwd files=(d:\1.dmp,d:\2.dmp..) filesize= 2G
-
Originally posted by Halo
exp user/pwd files=(d:\1.dmp,d:\2.dmp..) filesize= 2G
And you are a "Moderator"?
Read the post sparky.
I remember when this place was cool.
-
BTW, who the heck uses Oracle 7 these days. Are we going back to stone age? For crying out loud 8i has been desupported.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|