Oracle8 import failure

From: Yat-Fan <fan.ho_at_alumni.ust.hk>
Date: Sat, 9 Jan 1999 11:25:09 +0800
Message-ID: <776htg$am9@ustsu10.ust.hk>

Hello all,

I have a export dump file (~2G) from
Oracle 8.0.04 Enterprise version on NT
and tries to import into Oracle 8.0.04
workgroup version on NT. However, the
importing fails. After the import utility is done with importing tables:

++++++++++++++++++++++++++++
...


. . importing table       "TXN_EXCEPTION_LOG_0507"          0 rows imported


. importing SYSTEM's objects into SYSTEM

. importing DBSNMP's objects into DBSNMP
. importing SYSTEM's objects into SYSTEM
. importing KCERRP_SA's objects into KCERRP_SA
IMP-00017: following statement failed with ORACLE error 3113:  "GRANT DELETE ON "CSC_TYPE_VW_DC" TO "KCERRP_USER""

IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00000: Import terminated unsuccessfully

IMP-00021: operating system error - error code (dec 2, hex 0x2) ...

++++++++++++++++++++++++++++++++++++++

I tried different exports (like only
export definitions etc...), but the
failure point is still the same.

Any suggestion to proceed for a successful import?

Many many thanks.

It's best if replies can also be copied to my account fan.ho_at_alumni.ust.hk

Rgds.,
fan.
(Yat-Fan HO, KCRC, Hong Kong) Received on Fri Jan 08 1999 - 21:25:09 CST