CTXSYS User

The CTXSYS user is created during installation and can:

• View all indexes

• Sync all indexes

• Run ctxkbtc, the knowledge base extension compiler

• Query all system-defined views

• Perform all tasks of a user with the CTXAPP role

Note: In earlier releases of Oracle Text, CTXSYS had SYSDBA privileges, and only CTXSYS users could perform certain functions, such as modifying system-defined preferences or setting system parameters.

Starting with Oracle Database Release 19c, the CTXSYS user is a schema only user. To use the CTXSYS schema, run the following statements:

connect / as sysdba;

alter session set CURRENT_SCHEMA=CTXSYS;