Re: import - abnormal end of export file

Hi,

Did you follow those steps!!
.

# As root make a directory "/dev/oracle"

      mkdir /dev/oracle

#
# Give write permissions to Oracle
#

     chmod 666 /dev/oracle

# make a pipe (I had to do this as root)

     mknod /dev/oracle/expdat.dmp p

# start compressing the output from the pipe in the # background

     compress < /dev/oracle/expdat.dmp > expdat.dmp.Z &

# wait a while

     sleep 30

# start the export (write export file to pipe)
# (On my rdbms I have defined os_authent_prefix="" and
# have created user oracle identified externally)

     exp / file=/dev/oracle/expdat.dmp full=y compress=y log=exp.log

# This will produce a compressed file in the form of # expdat.dmp.Z in your current working directory

# To run an import based on this compressed file

     imp / file=/dev/oracle/expdat.dmp full=y log=imp.log &

     uncompress < expdat.dmp.Z > /dev/oracle/expdat.dmp

<jcoliv_at_my-deja.com> wrote in message news:890ttb$u6c$1_at_nnrp1.deja.com...
> Does anybody know if this error is related to the 2GB file size limit
> for import?
> It's a 5GB .Z file, and I am using pipe to import it.
> Thanks.
>
> IMP-00009: abnormal end of export file
> Import terminated successfully with warnings.
> [1] + Done compress -cd <exp_agdime.dmp.Z>
> pipefile.p &
> $ oerr imp 00009
> 00009, 00000, "abnormal end of export file"
> // *Cause: The export file is probably from an aborted Export session.
> // *Action: If so, retry the export and import. Otherwise, report this
> as an
> // Import bug and submit the export file that caused this
> error to
> // customer support.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Feb 23 2000 - 09:55:45 CST