Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Table not picking up new records after initial load

Solaris 11
Oracle DB 12.1.0.2
GG 18.1
Hello Team,
I have noticed for a few tables insert is not working after initial load. Kindly advise.
The initial load was performed using impdp with network_link and flashback_scn as current scn from source before initial load.
For 1 table there is a discrepency of around 12 records, for another 3 records. What steps should I take?
Thanks,
Roshan
Best Answer
-
Hi Veera,
There was HANDLECOLLISION parameter in the replicat parameter file. I removed it and it worked fine.
Thanks,
Roshan
Answers
-
HI Roshan,
What is the error you are facing? Could you please provide the parameter file of the extract, replicat processes.
Regards,
Veera
-
Hi Veera,
There was HANDLECOLLISION parameter in the replicat parameter file. I removed it and it worked fine.
Thanks,
Roshan