IMPDP Fails With PLS-00103 When Importing Chain Step
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
When trying to import a dump file containing a scheduler chain, and with an evaluation interval specified for a chain step, the following error is raised:
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
ORA-39083: Object type PROCOBJ failed to create with error:
ORA-06550: line 2, column 69:
PLS-00103: Encountered the symbol "00" when expecting one of the following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec between || member submultiset
The symbol ", was inserted before "00" to continue.
Failing sql is:
dbms_scheduler.create_chain('"MY_CHAIN"', evaluation_interval=>+000 00:01:00, comments=>NULL
An evaluation interval has been specified for a particular chain step.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms