1 Reply Latest reply: Feb 19, 2013 9:35 PM by 989658 RSS

    DBMS_DATAPUMP + import

    989658
      Hi,

      I am trying to import data from a dmp file created using expdp. Running on oracle 11g Express and getting following error, and tried to fix but could not succeeded, please anyone can help how to overcome this issue? I have tables exist in POI schema and trying to import them in ghi schema. Created dmp file from poi shcema with two tables= '''REL20_AU_POI'',''ARCHIVE_POI''' and these tables do not exist in ghi schema
      declare
      l_handle    NUMBER;
      begin
          l_handle := DBMS_DATAPUMP.open(
              operation => 'IMPORT',
              job_mode => 'TABLE',
              job_name => 'JOB1');
              
              --dbms_output.put_line('jobhandle is : 'jobhandle);
      
      
          DBMS_DATAPUMP.add_file(
              handle => l_handle,
              filename => 'REL22_imp.log',
              directory => 'TESTDIR',
              filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE
              ); 
              
              --dbms_output.put_line('Import Log file is created..');
      
      
          DBMS_DATAPUMP.METADATA_REMAP
          (handle => l_handle,
          name => 'REMAP_SCHEMA',
          old_value => 'POI',
          value => 'GHI');   
          
          --dbms_output.put_line('metadat_remap');
      
               DBMS_DATAPUMP.metadata_filter(
              handle => l_handle,
              name => 'NAME_LIST',
              value => '''REL20_AU_POI'',''ARCHIVE_POI''');  
          DBMS_DATAPUMP.start_job(l_handle);
          DBMS_DATAPUMP.detach(l_handle);
      end; 
      Thanks in advance,

      Zaid