0 Replies Latest reply: Nov 4, 2012 7:02 AM by user12144220 RSS

    Import job failes with ORA-01403: no data found ORA-06512: at "SYSMAN.MGMT

    user12144220
      Hello everyone,

      I need a help on importing data from a schema in server 1 to the same schema in server 2 via network link. I receive following error when I try to submit a job on Enterprise Manager:

                
      Import Submit Failed
           
      ORA-01403: no data found ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 5806 ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 7812 ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 8608 ORA-01403: no data found ORA-06512: at "SYSMAN.MGMT_JOBS", line 273 ORA-06512: at "SYSMAN.MGMT_JOBS", line 86 ORA-06512: at line 1

      Sql of the job:

      declare
      h1 NUMBER;
      begin
      h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'FULL', remote_link => 'B_PROD_LINK', job_name => 'BIMPORTFRMPRDTORPT4', version => 'COMPATIBLE');
      dbms_datapump.set_parallel(handle => h1, degree => 1);
      dbms_datapump.add_file(handle => h1, filename => 'IMPORT.LOG', directory => 'DATA_PUMP_DIR', filetype => 3);
      dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
      dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
      dbms_datapump.set_parameter(handle => h1, name => 'ESTIMATE', value => 'BLOCKS');
      dbms_datapump.set_parameter(handle => h1, name => 'REUSE_DATAFILES', value => 0);
      dbms_datapump.set_parameter(handle => h1, name => 'TABLE_EXISTS_ACTION', value => 'TRUNCATE');
      dbms_datapump.set_parameter(handle => h1, name => 'SKIP_UNUSABLE_INDEXES', value => 0);
      dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
      dbms_datapump.detach(handle => h1);
      end;
      /

      It says network link is active when I test the network link to make sure its connectivity. I create the network link as a system account. I'm trying to do an import from an Oracle database 10.2.0.2 to 11.2.0.1. My 10g database is on ms windows 2003x64 while my 11g database is on OEL 5.4x64.

      What should I do for now?

      Thank you.

      Edited by: user12144220 on Nov 4, 2012 5:02 AM