Configuring Oracle Text in Oracle Database Vault Environment

19.9 Configuring Oracle Text in Oracle Database Vault Environment

In an Oracle Database Vault environment, you can create a CTXSYS user if you have the DV_ACCTMGR role.

To create a CTXSYS user, run the @$ORACLE_HOME/ctx/admin/catctx_user.sql SQL script. Then, connect as SYS user and run the @$ORACLE_HOME/ctx/admin/catctx_schema.sql SQL script.

Note:

If the SYS user also has the DV_ACCTMGR role, then you can run the @$ORACLE_HOME/ctx/admin/catctx.sql SQL script which installs both, catctx_user.sql and catctx_schema.sql scripts.