Kayshav.com
About Developer Oracle 11g Technology Information Sitemap

DBMS_DATAPUMP - Import
SET SERVEROUTPUT ON;

DECLARE
  v_dp_handle      NUMBER;

BEGIN
  v_dp_handle := DBMS_DATAPUMP.open(
                   operation   => 'EXPORT',
                   mode        => 'SCHEMA',
                   remote_link => dblink_destination,
                   job_name    => Null,
                   version     => 'COMPATIBLE
                 );

  DBMS_DATAPUMP.set_parallel(
                   handle => v_dp_handle,
                   degree => 1
                 );

  DBMS_DATAPUMP.add_file(
         handle    => v_dp_handle,
         filename  => 'EXPORT_DBUSER_110001_01.dmp',
         directory => 'DATA_PUMP_DIR'
         --, filetype => 3
   );

  DBMS_DATAPUMP.add_file(
    handle    => v_dp_handle,
    filename  => 'EXPORT_DBUSER_110001_02.dmp',
    directory => 'DATA_PUMP_DIR'
   );

  DBMS_DATAPUMP.add_file(
    handle    => v_dp_handle,
    filename  => 'EXPORT_DBUSER_110001_03.dmp',
    directory => 'DATA_PUMP_DIR'
   );

  DBMS_DATAPUMP.add_file(
    handle    => v_dp_handle,
    filename  => 'EXPORT_DBUSER_110001_04.dmp',
    directory => 'DATA_PUMP_DIR'
   );

  DBMS_DATAPUMP.start_job(
       handle       => v_dp_handle,
       skip_current => 0,
       abort_step   => 0
     );
 
WHEN OTHERS THEN 
   raise_application_error(-20001,'An error was encountered - '||
             SQLCODE||' -ERROR- '||SQLERRM); 
END;
/

Data Pump in Oracle Database 11g Release 2: Foundation for Ultra High-Speed Data Movement Utilities

Oracle Database Online Documentation 11g Release 1: DBMS_DataPump

DBMS_DATAPUMP Import

Oracle 11gXEr2 - Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: September 19th, 2014

  24116