PLS-00103 IMP-00003 ORACLE error 6550 encountered (Doc ID 438180.1)

Last updated on OCTOBER 15, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3
This problem can occur on any platform.

Symptoms

Trying to import using IMPDP reports following errors

IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_scheduler.create_job('"GATHERSTATS6870261"',"
"job_type=>'PLSQL_BLOCK', job_action=>"
"'"
"begin"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 4, column 1:
PLS-00103: Encountered the symbol "
begin
COMMIT; END;
" when expecting one of the following:

( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character.)

Cause

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