compressing exports

From: Kent Palm <kpalm_at_doc.qualcomm.com>
Date: Wed, 17 Feb 1993 18:41:23 GMT
Message-ID: <kpalm.729974483_at_doc>

Well, I ran into a problem when trying to import an export which I had compressed. The command procedure and errors are shown below. It looked like the background job (doing the uncompress) just wasn't in synch with the import. The fix was easy though. First, I uncompressed the file to disk, then the import ran without fail.

ImportTable()
{
uncompress -c < ${DUMPFILE} > ${COMPRESSPIPE} &

imp system/passwd       \
  commit=Y		\
  file=${COMPRESSPIPE}  \
  buffer=40960          \
  indexes=Y             \
  grants=Y              \
  rows=Y                \
  fromuser=${OWNER}	\

TABLES=\( ${TABLES} \) >> import_${OWNER}.log 2>&1 return
}

Import: Version 6.0.33.2.3 - Production on Thu Feb 4 23:20:24 1993

Copyright (c) Oracle Corporation 1979, 1989. All rights reserved.

Connected to: ORACLE RDBMS V6.0.33.2.3, transaction processing option - Production PL/SQL V1.0.33.1.1 - Production

Export file created by EXPORT:V06.00.33

Warning: the objects were exported by USER1, not by you

. importing SYSTEM's objects into SYSTEM IMP-00017: following statement failed with ORACLE error 972:   "GRANT RESOURCE ON "EXPORT:V06.00.33 DUSER1 RENTIRE 1024 " IMP-00008: unrecognized statement in the export file:   DUSER1
IMP-00008: unrecognized statement in the export file:   RENTIRE
IMP-00008: unrecognized statement in the export file:   1024
IMP-00008: unrecognized statement in the export file: Received on Wed Feb 17 1993 - 19:41:23 CET