topic Re: importing a split export file in Operating System - HP-UX

importing a split export file

Derek Baxter_1 — Thu, 01 May 2003 14:53:59 GMT

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

Re: importing a split export file

Brian Crabtree — Thu, 01 May 2003 21:09:12 GMT

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

Re: importing a split export file

malay boy — Thu, 01 May 2003 23:16:19 GMT

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

Re: importing a split export file

Indira Aramandla — Fri, 02 May 2003 04:57:59 GMT

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 &

Re: importing a split export file

Derek Baxter_1 — Fri, 02 May 2003 20:24:14 GMT

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