This discussion is archived
1 Reply Latest reply: Feb 19, 2013 7:35 PM by 989658 RSS

DBMS_DATAPUMP + import

989658 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points