for platform difference ( little endian to big endian)
DECLARE
l_ts_names DBMS_STREAMS_TABLESPACE_ADM.TABLESPACE_SET;
l_dirs DBMS_STREAMS_TABLESPACE_ADM.DIRECTORY_OBJECT_SET;
l_dp_job_name varchar2(200);
l_log_file DBMS_STREAMS_TABLESPACE_ADM.FILE;
BEGIN
l_ts_names (1) := 'USERS';
l_ts_names (2) := 'REPORTS';
l_dirs (1) := 'DBF_DIR';
l_log_file.directory_object := 'DBF_DIR';
l_log_file.file_name := 'pull_ts_log.log';
DBMS_STREAMS_TABLESPACE_ADM.PULL_TABLESPACES(
datapump_job_name => l_dp_job_name,
database_link => 'dwdb',
tablespace_names => l_ts_names,
tablespace_directory_objects => l_dirs,
conversion_extension => 'sun',
log_file => l_log_file
);
END;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment