ORA-8103 / ORA-600 [KTSFBFMT:OBJDCHK_KCBNEW_3] with Single Consumer Queue Table
Last updated on JANUARY 25, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
The following error(s) is reported in the alert log:
ORA-8103: object no longer exists
and / or
On review of a trace generated at the time of the error, the section 'Current SQL Statement for this session' references a single consumer queue table.
- underlying AQ object index(es) of the queue table were modified/altered in some way such as an ALTER INDEX on AQ$_<queue table>_I. Operations before the ALTER succeeded, but after the ALTER they fail.
- queue table was purged recently
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