I am currently doing a export on a database using Oracle 8.0.5 on Solaris 8. I am using inline compression with the gzip utility. I am trying to test importing my data back into the database, but when I run my shell script the import process hangs. Here is my scipt for the inline compression for the export process, it works fine:

. /oracle/oracle_env.sh
#NLS_LANG=American_America.US7ASCII; export NLS_LANG

# First create a named pipe

mknod exp_pipe p
#change permssions on the pipe
chmod 777 exp_pipe

# export afegdb db

#Set export dump file name: MMDD

DX=`date +%m%d.exp.gz`; export DX

exp ecedi/******* full=Y compress=Y log=/oracle/backups/export.log file=exp_pipe|/usr/bin/gzip < exp_pipe > $DX

# EOF afegdb_export

Now to import the the database into a test database, I just modified the script and changed it to do import, Like so:

. /oracle/oracle_env.sh
#NLS_LANG=American_America.US7ASCII; export NLS_LANG

# First create a named pipe

mknod imp_pipe p
#change permssions on the pipe
chmod 777 imp_pipe

# export afegdb db

#Set export dump file name: MMDD

DX=/database/exports/1125.exp.gz; export DX

imp ecedi/******* full=Y compress=Y log=/oracle/backups/import.log file=imp_pipe|/usr/bin/gunzip < imp_pipe > $DX

# EOF afegdb_export

The export script is one that tamilselvan provided in one of his post.

I am trying find out if I am going down the right path to import the data or I totally off track here?//

I have tried to do an straight export, but my export keeps bombing out and giving me the following errors:

EXP-00002: error in writing to export file
EXP-00222:
System error message 27
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully

I checked the dmp file and it was over 2GB, but I checked my ulimit and it is set to unlimited, so I don't know what is happening there either. After checking for a solution all over, I am stumped at this point....I need help!! Any suggestions anyone. I apologize for the lenghty post here. thanks in advance.