Oracle export file

[vpons]

I take oracle export and compress (gzip)on the fly. The export file is about 4.02G and when compressed on the fly, it reduces to about 117KB.

When I uncompress (gunzip) the export file, I get 2592KB.

My first concern is when I gunzip the file, why the size of the dmp file is not same as
when exported (4 GB).
When I use the uncompressed export file to do an import of the table, it never happens and I do not get any error too. The export is done by system (on prod) and imported by the user sloslive to user sloslive on the test server. The user (sloslive) on both systems (prod and test) are exact replica as the test server is built using backup of the prod.

Any help is appreciated.
Thanks

[PAVB]

1- If you compress it on-the-fly during export you want to uncopress it on-the-fly during import.

2- Since sloslive exists in both environments, use this account to both export and import.

[vpons]

Could you please let me know what I should have in my parfile? or how to do it on the command line?

This is what it looks like

buffer=100000
fromuser=sloslive
touser=sloslive
log=imp_hvh.log
file=bpcs.dmp (i gunzipped it first)
tables=hvh

Should I gzip it and then gunzip during import?

Thanks for your help

[PAVB]

As per your initial post you want to export-compress in a single step then...

you want to export-gzip it on the fly during export and,
gunzip-import it on the fly during import.

Please post the shell script you used to export-compress

[vpons]

cat $exp_home/${dbname}.dmp | /usr/contrib/bin/gzip > $exp_home/${dbname}.dmp.g
z & #compress on the fly
$ORACLE_HOME/bin/exp system/manager FILE=$exp_home/${dbname}.dmp FULL=Y DIRECT=
Y LOG=$BPCS_BACKUP_HOME/logs/${dbname}.log

[PAVB]

I can see no pipe in your script so I don't think you are doing it on-the-fly

I would do something like this...

/etc/mknod pipe.imp p
nohup $ORACLE_HOME/bin/exp system/manager file=pipe.imp log=$BPCS_BACKUP_HOME/logs/${dbname}.log direct=y full=y &
nohup /usr/contrib/bin/gzip < pipe.imp > $exp_home/${dbname}.dmp.gz &

to export-gzip it and the inverse to gunzip-import it.

[vpons]

Can you please explain what the following does?

I have to use an old export file. So how do I use that to import.

1. /etc/mknod pipe.imp p
2. nohup $ORACLE_HOME/bin/exp system/manager file=pipe.imp log=$BPCS_BACKUP_HOME/logs/${dbname}.log direct=y full=y &
3. nohup /usr/contrib/bin/gzip < pipe.imp > $exp_home/${dbname}.dmp.gz &

[PAVB]

You don't.

I do not think you have a valid export file.

What I give you is the script you want to execute if you want to have a valid dump file after an export/gzip on-the-fly process.