cancel
Showing results for 
Search instead for 
Did you mean: 

importing a split export file

SOLVED
Go to solution
Derek Baxter_1
Occasional Advisor

importing a split export file

I am trying to import a split exp. file that I have taken. I needed to split it because it was greater than 2gig and i am on 8.0.4. Can anyone help me on how to do this import. Thanks
4 REPLIES
Brian Crabtree
Honored Contributor
Solution

Re: importing a split export file

mknod cat_pipe p

cat expdumpaa expdumpab expdumpac > cat_pipe &

imp userid=user/pass file=cat_pipe full=y
-------------
This should import the file. If you compressed the file with the export, you will need to do the following:
-------------
mknod cat_pipe p
mkdir imp_pipe p

cat expdumpaa expdumpab expdumpac > cat_pipe &
gunzip < cat_pipe > imp_pipe &

imp userid=user/pass file=imp_pipe full=y
-------------

Hope this helps,

Brian
malay boy
Trusted Contributor

Re: importing a split export file

Hi,
what can you do is to export it to the tape using below command :

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= &
# Write from pipe to tape
% exp file=/tmp/exp_pipe
# Export to the pipe


and below are the command to import from the tape :

Importing from tape via unix named pipes ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
% mknod /tmp/imp_pipe p
# Make the pipe
% dd of=/tmp/imp_pipe if= &
# Write from tape to pipe
% imp file=/tmp/imp_pipe
# Import from the pipe

Good luck.
I plus this one from metalink.There are lot of arcticles in Metalink on 2G file.

regards
mB
There are three person in my team-Me ,myself and I.
Indira Aramandla
Honored Contributor

Re: importing a split export file

Hi,

You could do this way as well.
EXPORT:-
I guess you had exported into split files using the UNIX split and compress commands Example:-

mknod compress_pipe p
mknod split_pipe p

chmod g+w compress_pipe
chmod g+w split_pipe

Submitted the export using a parameter file
file=compress_pipe
tables=(table_name1, table_name2,???..) or owner=
buffer=1024000
log=exp_ ddmmyyy.log

Also run :
nohup split -b500m < split_pipe > glsp.dmp &
nohup compress < compress_pipe > split


IMPORT
Uncompressed the split file using the command :
nohup uncompress < split > compress_pipe &
Now create an import parameter file
file=compress_pipe
buffer=1024000
log=imp_ddmmyyy.log
fromuser= touser=

Submitt the import as:
nohup imp username/passwd parfile=import.par &



Never give up, Keep Trying
Derek Baxter_1
Occasional Advisor

Re: importing a split export file

Thanks Brian, It worked perfectly.
Malay and Indira, thanks also, I may try your way later just to check it out.