Streams Capture Aborting With ORA-26767 Due To Temp Tables Created By DBMS_COMPRESSION
(Doc ID 1082323.1)
Last updated on DECEMBER 10, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206. and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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