Why XML_SECTION_GROUP and NEWS_SECTION_GROUP are not in CTX_SECTION_GROUPS (Doc ID 2006039.1)

Last updated on APRIL 01, 2020

Applies to:

Goal

 The default SECTION_GROUPS for Oracle text are:

NULL_SECTION_GROUP
BASIC_SECTION_GROUP
HTML_SECTION_GROUP
XML_SECTION_GROUP
AUTO_SECTION_GROUP
PATH_SECTION_GROUP
NEWS_SECTION_GROUP

However, a query of the view, CTXSYS.CTX_SECTION_GROUPS shows that we only have these section groups listed, why?

SQL> select * from ctx_section_groups;

SGP_OWNER                      SGP_NAME                       SGP_TYPE
------------------------------ ------------------------------ ------------------
CTXSYS                         NULL_SECTION_GROUP             NULL_SECTION_GROUP
CTXSYS                         HTML_SECTION_GROUP             HTML_SECTION_GROUP
CTXSYS                         AUTO_SECTION_GROUP             AUTO_SECTION_GROUP
CTXSYS                         PATH_SECTION_GROUP             PATH_SECTION_GROUP

Solution

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