Share |

IMP-00003: ORACLE error %lu encountered

You are trying to import an Oracle export file, but an Oracle error was encountered.
Lookup the "real" Oracle error as indicated in the error message and make corrective actions.
eg:
C:\Temp>imp userid=imp1/imp1 file=expSYSTEM1.dmp fromuser=system touser=imp1

Import: Release 11.2.0.1.0

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

Export file created by EXPORT:V11.02.00 via conventional path

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

import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export client uses WE8MSWIN1252 character set (possible charset conversion)
IMP-00017: following statement failed with ORACLE error 2304:
 "CREATE TYPE "REPCAT$_OBJECT_NULL_VECTOR" TIMESTAMP '2010-04-02:13:20:12' OI"
 "D 'DE89BCC579464D7F8FAE02F2D22CC373'          AS OBJECT"
 "("
 "  -- type owner, name, hashcode for the type represented by null_vector"
 "  type_owner      VARCHAR2(30),"
 "  type_name       VARCHAR2(30),"
 "  type_hashcode   RAW(17),"
 "  -- null_vector for a particular object instance"
 "  -- ROBJ REVISIT: should only contain the null image, and not version#"
 "  null_vector     RAW(2000)"
 ")"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 6550:
 "BEGIN   SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ORA112','IBMPC/W"
 "IN_NT-8.1.0'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
. . importing table                  "DEF$_AQCALL"          0 rows imported
IMP-00017: following statement failed with ORACLE error 6550:
 "BEGIN   SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ORA112','IBMPC/W"
 "IN_NT-8.1.0'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
IMP-00009: abnormal end of export file
Import terminated successfully with warnings.
 Related Oracle Errors  IMP-00009: abnormal end of export file
IMP-00017: following statement failed with ORACLE error %lu:
ORA-02304: invalid object identifier literal
ORA-06550: line %s, column %s:\\n%s
 Was this information helpful?  Yes No
If it was not helpful, please take some time to explain why. This is not to ask questions, you can do so in the forum.

Welcome to our forum for Oracle error: IMP-00003 Add your own message



At the moment there are no forum messages. You can add your own question.

Add your message

 Please provide your personal info 



 Please ask your message as briefly and clear as possible 

 Spam Protection 
Validation Code: t3p454sopnzmsshjy


Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.


Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.


Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.