Oracle Database Discussions

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!

impdp failing with error in 11g

799923Oct 4 2011 — edited Oct 4 2011

I have taken schema export in 10g database using expdp and then trying to import using impdp in 11g database.

its failing with below error, any idea..?

ORA-12012: error on auto execute of job 28
ORA-04067: not executed, package body "PORTAL.WWV_CONTEXT" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "PORTAL.WWV_CONTEXT"
ORA-06512: at line 1
*** SESSION ID:(24.268) 2011-10-02 05:24:24.391
*** SERVICE NAME:(SYS$USERS) 2011-10-02 05:24:24.391

*** 2011-10-02 05:24:24.391
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("PORTAL"."WWCTX_SSO_SESSION$"."SUBSCRIBER_ID")
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWCTX_SSO", line 1554
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("PORTAL"."WWCTX_SSO_SESSION$"."SUBSCRIBER_ID")
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWCTX_SSO", line 1554
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("PORTAL"."WWCTX_SSO_SESSION$"."SUBSCRIBER_ID")
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWCTX_SSO", line 1554
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("PORTAL"."WWCTX_SSO_SESSION$"."SUBSCRIBER_ID")
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "PORTAL.WWCTX_SSO", line 1554
ORA-06502: PL/SQL: numeric or value error
ORA-01400: cannot insert NULL into ("PORTAL"

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2011

Added on Oct 4 2011

#general-database-discussions

1 comment

571 views