Streams Capture Aborting With ORA-26767 Due To Temp Tables Created By DBMS_COMPRESSION (Doc ID 1082323.1)

Last updated on SEPTEMBER 10, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.0. and later
Information in this document applies to any platform.

Symptoms

Streams Capture is aborting with ORA-26767 . The following error message is logged in Capture trace

ORA-26744: STREAMS capture process "<capture name>" does not support "<schema>"."DBMS_TABCOMP_TEMP_UNCMP" because of the following reason:
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

Additional Explanation:
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

 

Cause

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