- declare
- h1 NUMBER;
- begin
- h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'FULL', job_name => 'IMPORT_<tablespace_name>', version => 'COMPATIBLE');
- -- Add logfile and dumpfile
- dbms_datapump.add_file(handle => h1, filename => '<tablespace_name>_IMPORT.LOG', directory => 'DATA_PUMP_DIR', filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE);
- dbms_datapump.add_file(handle => h1, filename => '<backup_name>', directory => 'DATA_PUMP_DIR', filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_DUMP_FILE);
- -- Remapping of schemas and tablespaces
- dbms_datapump.metadata_remap(h1,'REMAP_TABLESPACE','<old_tablespace_name>','<tablespace_name>');
- -- Set segment attributes to No
- dbms_datapump.metadata_transform ( handle => h1, name => 'SEGMENT_ATTRIBUTES' , value => 0 , object_type => 'TABLE' ) ;
- dbms_datapump.metadata_transform ( handle => h1, name => 'SEGMENT_ATTRIBUTES' , value => 0 , object_type => 'INDEX' ) ;
- -- Set additional parameters
- dbms_datapump.set_parallel(handle => h1, degree => 1);
- dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
- dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
- dbms_datapump.set_parameter(handle => h1, name => 'REUSE_DATAFILES', value => 0);
- -- Start job
- dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
- dbms_datapump.detach(handle => h1);
- end;
- /