Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Initial Load Extract (Date Format)

M.d900Jan 24 2015 — edited Feb 4 2015

Hi ,

I'm doing an Initial Load Extract (File To Replicat ) for module of 30 GB , and I'm getting the following error at on the extracted tables :

ERROR   OGG-00665  OCI Error error executing fetch with error code 1801  (status = 1801-ORA-01801: date format is too long for internal buffer), SQL<SELECT ........

My concerns are :

1- How to overcome this error , without updating the source data ?

2- How to deal with that at the target side (If the data replicated )  , so it'll not affect the business needs

Thanks So Much

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2015
Added on Jan 24 2015
9 comments
2,277 views