Dear All,
I am trying to import a data dump from 10.1.0.5 to 10.2.0.1
While doing that I am getting the following error messages
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_scheduler.create_job('"JOB_UOP_PW_DOC_NUM"',"
"job_type=>'PLSQL_BLOCK', job_action=>"
"'Declare "
"v_cursor number;"
"v_dropString varchar2(100);"
"v_createString varchar2(200);"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 4, column 1:
PLS-00103: Encountered the symbol "Declare
v_cursor number;
v_dropString varchar2(100);
v_createSt" 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 alterna
IMP-00091: Above error occurred on the following function and object: CREATE JOB_UOP_PW_DOC_NUM. Remaining PL/SQL blocks for this object will be skipped.
Import terminated successfully with warnings.
Can anyone help me to resolve this error message?
Thanks in advance.
Aruna