Streams Capture Aborting With ORA-26767 Due To Temp Tables Created By DBMS_COMPRESSION
(Doc ID 1082323.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124. and later
Information in this document applies to any platform.
Streams Capture is aborting with ORA-26767 . The following error message is logged in Capture trace
ORA-26767: No enough redo log information for LogMiner
Sometime the table mentioned in above error message is either DBMS_TABCOMP_TEMP_UNCMP OR DBMS_TABCOMP_TEMP_CMP. These tables do not exist on source database.
-Streams Apply can fail with ORA-26714 and ORA-00942
-Streams slows down mining archive logs generated during maintenance window
It appears that the "Automated Maintenance Window" jobs Segment Advisor calls dbms_compression which creates two tables called DBMS_TABCOMP_TEMP_UNCMP and DBMS_TABCOMP_TEMP_CMP in users schema
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document