Monday, December 3, 2007

migrating oracle from windows to solaris

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;

No comments: