This content has been marked as final. Show 5 replies
Which database version are you using on the source system?
Is there heavy workload on the table that you are exporting and that causes th e PK violation?
Have you checked from which time the trail record that causes the PK violation comes from?
Might it be that this record was created while expdp was running? This would indicate that there is an issue with expdp.
1. My source and target systems having Oracle DB version 126.96.36.199.0 and OGG version is 11.1.1
2. I perform initial load during off business hours.
3. These errors occur during Business hours.
4. Such errors occur for some more tables in discard file. chances for record creation are remote as I perform expdp during off business hours
Is there something wrong in my steps ?
Edited by: LazyDBA11g on Nov 26, 2012 10:35 AM
Did you check where the data is coming from ? Could you try to insert manually the Data to verify on Source and Target ?? Have you ever had those problems on the source ?
Please look the note: Using SCN To Do The Initial Load From Oracle To Oracle Database with GoldenGate Versions before v10 [ID 969550.1]
Pay attention about all steps in the doc. I guess that you not completed all steps ... for example:
You need start the extract from oldest long-pending transaction:
SQL> select min(START_TIME) from v$transaction;
Extract need start from the specified point of the time (03/14/08 16:05:40), so ... when use the expdp this transaction will not be exported because is not completed, then is need program the extract for capture this transaction. Then, all of the records before or equal to this SCN will be filtered out, which makes certain there are no overlapping records during the initial load.
Please, check the doc for more details.
Hi Flavio ,
Thanks for response. my OGG version is 11.1 and DB version is 11.2 and hence doc [ID 969550.1] does not apply in this case.