Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.5 to 126.96.36.199 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 28-MAR-2013***
Importing data with Datapump impdp could result in exceptions similar to the following:
Failing SQL is:
ALTER PROCEDURE "K"."AUD#BP" COMPILE PLSQL_OPTIMIZE_LEVEL= 2 PLSQL_CODE_TYPE= INTERPRETED PLSQL_DEBUG= FALSE PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2011-03-03 18:53:17'
The problem also reproduces with a valid CATPROC component. The procedures can be manually compiled in SQL*Plus.
Possibly a recent upgrade can trigger the problem.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms