18.2 Supported APIs in a Sharded Database

This is a list of all the Oracle Text CTXSYS procedures that you can run with or without using the sharding-specific PL/SQL procedure SYS.EXEC_SHARD_PLSQL.

Supported With the SYS.EXEC_SHARD_PLSQL Wrapper

You can run the following procedures from the CTXSYS package using the SYS.EXEC_SHARD_PLSQL wrapper:

  • CTX_DDL.ADD_ATTR_SECTION
  • CTX_DDL.ADD_FIELD_SECTION
  • CTX_DDL.ADD_MDATA_COLUMN
  • CTX_DDL.ADD_MDATA_SECTION
  • CTX_DDL.ADD_NDATA_SECTION
  • CTX_DDL.ADD_SUB_LEXER
  • CTX_DDL.ADD_STOPWORD
  • CTX_DDL.ADD_STOPCLASS
  • CTX_DDL.ADD_SDATA_SECTION
  • CTX_DDL.ADD_SDATA_COLUMN
  • CTX_DDL.ADD_STOP_SECTION
  • CTX_DDL.ADD_STOPTHEME
  • CTX_DDL.ADD_SPECIAL_SECTION
  • CTX_DDL.ADD_ZONE_SECTION
  • CTX_DDL.CREATE_PREFERENCE
  • CTX_DDL.DROP_PREFERENCE
  • CTX_DDL.CREATE_POLICY
  • CTX_DDL.CREATE_SECTION_GROUP
  • CTX_DDL.CREATE_SHADOW_INDEX
  • CTX_DDL.CREATE_STOPLIST
  • CTX_DDL.DROP_STOPLIST
  • CTX_DDL.DROP_SECTION_GROUP
  • CTX_DDL.DROP_POLICY
  • CTX_DDL.DROP_SHADOW_INDEX
  • CTX_DDL.EXCHANGE_SHADOW_INDEX
  • CTX_DDL.OPTIMIZE_INDEX
  • CTX_DDL.REMOVE_STOPWORD
  • CTX_DDL.REMOVE_SECTION
  • CTX_DDL.RECREATE_INDEX_ONLINE
  • CTX_DDL.SET_ATTRIBUTE
  • CTX_DDL.SET_SECTION_ATTRIBUTE
  • CTX_DDL.SET_SEC_GRP_ATTR
  • CTX_DDL.SYNC_INDEX
  • CTX_DDL.UPDATE_POLICY
  • CTX_QUERY.REMOVE_SQE
  • CTX_QUERY.STORE_SQE

Supported Without the SYS.EXEC_SHARD_PLSQL Wrapper

You can run the following CTXSYS procedures on the catalog without using the SYS.EXEC_SHARD_PLSQL wrapper. These APIs work directly on the catalog because they only access the metadata stored in the catalog and do not need to be propagated to shards for accurate results.

  • CTX_ANL.ADD_DICTIONARY
  • CTX_DOC.POLICY_SNIPPET
  • CTX_ENTITY.EXTRACT
  • CTX_REPORT.CREATE_INDEX_SCRIPT
  • CTX_REPORT.DESCRIBE_INDEX
  • CTX_REPORT.CREATE_POLICY_SCRIPT
  • CTX_REPORT.INDEX_SIZE
  • CTX_REPORT.DESCRIBE_POLICY
  • CTX_QUERY.HFEEDBACK
  • CTX_QUERY.EXPLAIN

Not Supported With the SYS.EXEC_SHARD_PLSQL Wrapper

The following CTXSYS procedures are not supported on a sharded database:

  • CTX_ANL APIS
  • CTX_CLS APIS
  • CTX_DDL.ADD_INDEX
  • CTX_DDL.CREATE_INDEX_SET
  • CTX_DDL.DROP_INDEX_SET
  • CTX_DDL.POPULATE_PENDING
  • CTX_DDL.REMOVE_INDEX
  • CTX_DDL.REMOVE_MDATA
  • CTX_DDL.UPDATE_SDATA
  • CTX_DOC.HIGHLIGHT
  • CTX_DOC.MARKUP
  • CTX_DOC.FILTER
  • CTX_DOC.GIST
  • CTX_DOC.POLICY_MARKUP
  • CTX_DOC.POLICY_SNIPPET
  • CTX_DOC.SNIPPET
  • CTX_ENTITY.EXTRACT
  • CTX_QUERY.COUNT_HITS
  • CTX_QUERY.EXPLAIN
  • CTX_QUERY.HFEEDBACK
  • CTX_QUERY.RESULT_SET
  • CTX_REPORT.DESCRIBE_POLICY
  • CTX_REPORT.TOKEN_INFO
  • CTX_REPORT.INDEX_STATS
  • CTX_THES APIS