IMP Error
143894Mar 11 2010 — edited Mar 11 2010Hi
I am getting following error while importing a large dmp file containing many BLOBs. It imports some 4000 rows of the first table after that gives following error.
Please help me in fixing this issue.
E:\>imp abc/password file=abc.dmp full=y commit=Y
Import: Release 10.2.0.1.0 - Production on Thu Mar 11 18:56:22 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.01.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing ABC's objects into ABC
. . importing table "DOCS"
IMP-00009: abnormal end of export file
IMP-00018: partial import of previous table completed: 4398 rows imported
IMP-00017: following statement failed with ORACLE error 24909:
"BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;"
IMP-00003: ORACLE error 24909 encountered
ORA-24909: call in progress. Current operation cancelled
IMP-00017: following statement failed with ORACLE error 3114:
"BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;"
IMP-00003: ORACLE error 3114 encountered
ORA-03114: not connected to ORACLE
IMP-00000: Import terminated unsuccessfully