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!

GoldenGate extract abended -OGG-01668 -No records extracted.

onkar.nathJul 1 2013 — edited Jul 1 2013

All,

Extract process abended with OFF-01668 error.

Output to /u01/app/ggs/dirdat/db:

No records extracted.

I checked one of the thread in this forum : extracts abended because no records extracted --- no activity from database

this points to a metalink doc id: 1374091.1 but it did not resolve my problem.

System Details:

OS : RHEL 5

DB : Oracle 11g R2 (11.2.0.3)

GG : Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

One more thing: before I hit this error, extract process abended with below error:

2013-07-01 04:24:26  ERROR   OGG-01028  Object with object number 141055 is compressed. Table compression is not supported.

There was one table which was compressed, so I uncompressed it using below command:

alter table tab1 nocompress;

and after that I got OGG-01668 error.

Any help/suggestions?

-Onkar

This post has been answered by onkar.nath on Jul 1 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2013
Added on Jul 1 2013
1 comment
2,351 views