WEB下使用impdp导入其他模式expdp的数据失败

oragri

我在10的WEB控制台用HR模式export 出表REGIONS，然后在chenyijia模式下import这个表，出现下面错误：
Import Submit Failed  
Errors: ORA-31627: API call succeeded but more information is available ORA-31655: no data or metadata objects selected for job ORA-39154: Objects from foreign schemas have been removed from import Exception : ORA-31627: API call succeeded but more information is available ORA-06512: at "SYS.DBMS_DATAPUMP", line 4646 ORA-06512: at line 2  

请问高手们如何解决？
最后一步SHOW PL/SQL如下：
user chenyijia


declare
h1   NUMBER;
begin
  begin
      h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'TABLE', job_name => '222', version => 'COMPATIBLE');
  end;
  begin
     dbms_datapump.set_parallel(handle => h1, degree => 1);
  end;
  begin
     dbms_datapump.add_file(handle => h1, filename => 'IMPORT.LOG', directory => 'exportpath', filetype => 3);
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
  end;
  begin
     dbms_datapump.add_file(handle => h1, filename => 'EXPDAT01.DMP', directory => 'exportpath', filetype => 1);
  end;
  begin
     dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''HR'')');
  end;
  begin
     dbms_datapump.metadata_filter(handle => h1, name => 'NAME_EXPR', value => 'IN(''REGIONS'')');
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'SKIP_UNUSABLE_INDEXES', value => 0);
  end;
  begin
     dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
  end;
  begin
     dbms_datapump.detach(handle => h1);
  end;
end;
/

oragri

如果我在10G的WEB控制台用chenyijia模式export 出表job，然后在hr模式下import这个表，出现同样错误：
Import Submit Failed  
Errors: ORA-31627: API call succeeded but more information is available ORA-31655: no data or metadata objects selected for job ORA-39154: Objects from foreign schemas have been removed from import Exception : ORA-31627: API call succeeded but more information is available ORA-06512: at "SYS.DBMS_DATAPUMP", line 4646 ORA-06512: at line 2  

同样最后一步SHOW PL/SQL如下：
declare
h1   NUMBER;
begin
  begin
      h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'TABLE', job_name => '1111', version => 'COMPATIBLE');
  end;
  begin
     dbms_datapump.set_parallel(handle => h1, degree => 1);
  end;
  begin
     dbms_datapump.add_file(handle => h1, filename => 'IMPORT.LOG', directory => 'exportpath', filetype => 3);
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
  end;
  begin
     dbms_datapump.add_file(handle => h1, filename => 'EXPDAT2.DMP', directory => 'exportpath', filetype => 1);
  end;
  begin
     dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''CHENYIJIA'')');
  end;
  begin
     dbms_datapump.metadata_filter(handle => h1, name => 'NAME_EXPR', value => 'IN(''job'')');
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'SKIP_UNUSABLE_INDEXES', value => 0);
  end;
  begin
     dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
  end;
  begin
     dbms_datapump.detach(handle => h1);
  end;
end;
/

oragri

如果我在同样的模式下export出一个表，再DELETE这个表，再用同样的模式import则成功恢复该表。比如，我用chenyijia用户export出job，然后delete job 表，再用chenyijia用户import job表则成功恢复了job表。最后同样查看了PS/SQL:
declare
h1   NUMBER;
begin
  begin
      h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'TABLE', job_name => '333', version => 'COMPATIBLE');
  end;
  begin
     dbms_datapump.set_parallel(handle => h1, degree => 1);
  end;
  begin
     dbms_datapump.add_file(handle => h1, filename => 'IMPORT.LOG', directory => 'exportpath', filetype => 3);
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
  end;
  begin
     dbms_datapump.add_file(handle => h1, filename => 'EXPDAT2.DMP', directory => 'exportpath', filetype => 1);
  end;
  begin
     dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''CHENYIJIA'')');
  end;
  begin
     dbms_datapump.metadata_filter(handle => h1, name => 'NAME_EXPR', value => 'IN(''job'')');
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
  end;
  begin
     dbms_datapump.set_parameter(handle => h1, name => 'SKIP_UNUSABLE_INDEXES', value => 0);
  end;
  begin
     dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
  end;
  begin
     dbms_datapump.detach(handle => h1);
  end;
end;
/

不知道expdp和impdp是否支持不同模式之间的数据迁移，还是10g的一个BUG，望高手指点！！