Run job gives ORA-06550
11.2.0.2
Hi,
I have created this maintenance job:
BEGINSYS.DBMS_SCHEDULER.CREATE_JOB(job_name => 'MAINTENANCE.MAINTENANCE_TABLES',start_date => TO_TIMESTAMP_TZ('2013/03/05 10:25:57.619190 Europe/Vienna','yyyy/mm/dd hh24:mi:ss.ff tzr'),repeat_interval => NULL,end_date => NULL,job_class => 'DEFAULT_JOB_CLASS',job_type => 'PLSQL_BLOCK',job_action => 'beginexecute immediate ''alter table neotest.nmsdelivery shrink space compact'';execute immediate ''alter table neotest.nmsdelivery shrink space'';execute immediate ''alter table neotest.nmsdeliverystat shrink space compact'';execute immediate ''alter table neotest.nmsdeliverystat shrink space'';execute immediate ''alter table neotest.xtkworkflow shrink space compact'';execute immediate ''alter table neotest.xtkworkflow shrink space'';execute immediate ''alter table neotest.xtkworkflowevent shrink space compact'';execute immediate ''alter table neotest.xtkworkflowevent shrink space'';execute immediate ''alter table neotest.xtkworkflowjob shrink space compact'';execute immediate ''alter table neotest.xtkworkflowjob shrink space'';execute immediate ''alter table neotest.xtkworkflowlog shrink space compact'';execute immediate ''alter table neotest.xtkworkflowlog shrink space'';execute immediate ''alter table neotest.xtkworkflowtask shrink space compact'';execute immediate ''alter table neotest.xtkworkflowtask shrink space'';execute immediate ''alter table neotest.xtkjoblog shrink space compact'';execute immediate0