My Oracle Support Banner

What Is Triggering The Delete statements From Ctxsys.dr$sqe,ctxsys.index_set,ctxsys.index_set_index. (Doc ID 2126120.1)

Last updated on APRIL 07, 2022

Applies to:

Oracle Text - Version and later
Information in this document applies to any platform.


The Audit trail of a database is listing extra records in the aud$ table other then the audited statements executed by users such as SCOTT and APPS.
The extra statements referenced have an owner of CTXSYS and are statements like :

delete from ctxsys.dr$sqe
delete from ctxsys.dr$index_set
delete from ctxsys.dr$index_set_index

Why are these statements being generated?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.