Code Listing 2: Pulling multiple tablespaces simultaneously

SQL> DECLARE
  2     l_ts_names
  3        DBMS_STREAMS_TABLESPACE_ADM.TABLESPACE_SET;
  4     l_dirs
  5        DBMS_STREAMS_TABLESPACE_ADM.DIRECTORY_OBJECT_SET;
  6     l_dp_job_name     varchar2(200);
  7     l_log_file
  8        DBMS_STREAMS_TABLESPACE_ADM.FILE;
  9  BEGIN
 10     l_ts_names (1) := 'TS7';
 11     l_ts_names (2) := 'TS8';
 12     l_dirs (1) := 'DBF1_DIR';
 13     l_dirs (2) := 'DBF2_DIR';
 14     l_log_file.directory_object := 'LOG_DIR';
 15     l_log_file.file_name := 'ts7_ts8.log';
 16     DBMS_STREAMS_TABLESPACE_ADM.PULL_TABLESPACES(
 17        datapump_job_name            => l_dp_job_name,
 18        database_link               => 'dwdb',
 19        tablespace_names             => l_ts_names,
 20        tablespace_directory_objects  => l_dirs,
 21        conversion_extension         => 'linux',
 22        log_file                    => l_log_file
 23     );
 24  END;
 25 /

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy