catctx.sql ctxpass sysaux temp nolock

select comp_name, status from dba_registry;

select object_name, object_type, status
	from dba_objects
	where owner = 'CTXSYS'
	and status = 'INVALID';

SQL> create table test_index (a1 varchar(40));

Table created.

SQL>
SQL> insert into test_index values ('TEST information');

1 row created.

SQL>
SQL> select * from test_index
  2     where contains(a1, 'test', 1) > 0;
select * from test_index
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10599: column is not indexed
DRG-10599: column is not indexed


SQL>
SQL> create index test_index_idx on test_index (a1)
  2     indextype is ctxsys.context;

Index created.

SQL>
SQL> select * from test_index
  2     where contains(a1, 'test', 1) > 0;

A1
----------------------------------------
TEST information

SQL>
SQL> --Now I'll drop the CONTEXT index and create a CTXCAT index
SQL>
SQL> drop index test_index_idx;

Index dropped.

SQL>
SQL> create index test_index_idx on test_index (a1)
  2     indextype is ctxsys.ctxcat;

Index created.

SQL>
SQL> select * from test_index
  2     where catsearch(a1, 'test', null) > 0;

A1
----------------------------------------
TEST information