Hello
how to configure stream replication when datafiles are contained in more then one directory?
My script:
On source:
create directory SRC_DIR_OBJ AS '/databases/disk01/eoc01/oradata/';
create directory SRC_DIR_OBJ_2 AS '/databases/disk02/eoc01/oradata/';
on target:
create directory DEST_DIR_OBJ AS '/databases/disk01/eoc01';
SET SERVEROUTPUT ON SIZE 1000000;
DECLARE
ts_set DBMS_STREAMS_TABLESPACE_ADM.TABLESPACE_SET;
BEGIN
ts_set(1) := 'PRODPF';
DBMS_STREAMS_ADM.MAINTAIN_TTS(
tablespace_names => ts_set,
source_directory_object => 'SRC_DIR_OBJ',
destination_directory_object => 'DEST_DIR_OBJ',
source_database => 'EOC01.ORI',
destination_database => 'EOC03.NEW',
perform_actions=>TRUE,
script_name => 'replication_simple_tbs_pf.sql',
script_directory_object => 'SOURCE',
dump_file_name => NULL,
log_file => 'LOG_STREAM_TBS_PF.LOG',
bi_directional => FALSE);
END;
/
How to put second source directory destination on line sourc_directory_object?
Thanks everybody for your help