Streams Capture Aborting With ORA-26767 Due To Temp Tables Created By DBMS_COMPRESSION
Last updated on SEPTEMBER 10, 2015
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199. 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms