|
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 /
|