Mark an SDATA Section to Be Searchable

To mark an SDATA section to be searchable and have a $Sdatatype table created, use the CTX_DDL.SET_SECTION_ATTRIBUTE API.

The following tables are created:

• $SN – NUMBER

• $SD – DATE

• $SV – VARCHAR2, CHAR

• $SR – RAW

• $SBD – BINARY DOUBLE

• $SBF – BINARY FLOAT

• $ST – TIMESTAMP

• $STZ – TIMESTAMP WITH TIMEZONE

The following example creates a $SV table for this SDATA section to allow efficient searching on that section.

ctx_ddl.add_sdata_section('sec_grp', 'sdata_sec', 'mytag', 'varchar');
ctx_ddl.set_section_attribute('sec_grp', 'sdata_sec', 'optimized_for', 'search');

The default value of this attribute is FALSE.