Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

errors on schema import/export

851881Jun 2 2011 — edited Jun 2 2011

Hi all,
I have a release 10.2.0.3.0.

I exported a schema with

exp user/password OWNER=PIN20 FILE=/opt/oracle/admin/dportal/export/PIN20_new.dmp log=/opt/oracle/admin/dportal/export/expPIN20.log

and now I try to import with

imp user/password FILE=/opt/oracle/admin/dportal/export/PIN20_new.dmp log=/opt/oracle/admin/dportal/export/impPIN20.log fromuser=PIN20 touser=PIN24

but I get the following errors:

IMP-00017: following statement failed with ORACLE error 1403:
+"BEGIN "+
+"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE_TABLE('IFW_SYNC',1,16392,3,0,0,'', SY"+
+"S.DBMS_AQ_IMP_INTERNAL.DBVER_10i, '01:00');"+
+"COMMIT; END;"+
IMP-00003: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_SYS_IMP_INTERNAL", line 509
ORA-06512: at "SYS.DBMS_AQ_IMP_INTERNAL", line 33
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 1403:
+"BEGIN "+
+"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('4465326A47233008E0430A44394"+
+"03008'),'IFW_SYNC','IFW_SYNC_QUEUE',0,5,6,0,0,'');"+
+"COMMIT; END;"+
IMP-00003: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_SYS_IMP_INTERNAL", line 641
ORA-06512: at "SYS.DBMS_AQ_IMP_INTERNAL", line 60
ORA-06512: at line 2
IMP-00091: Above error occurred on the following function and object: CREATE IFW_SYNC_QUEUE. Remaining PL/SQL blocks for this object will be skipped.
IMP-00017: following statement failed with ORACLE error 1403:
+"BEGIN "+
+"SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('4465326A47223008E0430A44394"+
+"03008'),'IFW_SYNC','AQ$_IFW_SYNC_E',1,0,0,0,0,'exception queue');"+
+"COMMIT; END;"+
IMP-00003: ORACLE error 1403 encountered
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_SYS_IMP_INTERNAL", line 641
ORA-06512: at "SYS.DBMS_AQ_IMP_INTERNAL", line 60
ORA-06512: at line 2
IMP-00091: Above error occurred on the following function and object: CREATE AQ$_IFW_SYNC_E. Remaining PL/SQL blocks for this object will be skipped.
About to enable constraints...
Import terminated successfully with warnings.

How can I solve the issue?

Thanks.