Hi Guys,
I'm doing a test using expdp/impdb and aftercsn for initial load and changes. But doesn't work as expected.
Any issue with the test plan?
1. Add Extract, Add Exttrail, Add Pump, Add Rmttrail on source.
2. Start Extract, Start Pump on source.
3. Get SCN before schema export
select dbms_flashback.get_system_change_number() from dual;
1097818
4. Export in source
expdp directory=DATA_PUMP_DIR parallel=4 dumpfile=hr.dmp logfile=hr.log flashback_scn=1097818 schemas=hr
5. Import to target
6. In source, perform a delete:
delete from hr.employees where last_name='Fay';
7. Add and Start Replicat in target
start replicat rephr, aftercsn 1097818
However in the target, i notice that the delete change in step 6 is not applied. The record is still there in the target DB.
Can advise on this?
thanks