Oracle Text

Describes Autonomous AI Database support for Oracle Text features. To ensure the security and the performance of your Autonomous AI Database, some Oracle Text features are restricted.

Oracle Text Feature	Supported in Autonomous AI Database	More Information
All logging, and APIs which perform logging such as ctx_report.query_log_summary	Not Supported	QUERY_LOG_SUMMARY
File Datastore	Not Supported (see replacement DIRECTORY_DATASTORE)	Datastore Types
URL Datastore	Not Supported (see replacement NETWORK_DATASTORE)	Datastore Types
CREATE INDEX with BIG_IO option	Supported if you grant the privilege to create a trigger to the user (GRANT CREATE TRIGGER).	Improved Response Time Using the BIG_IO Option of CONTEXT Index
OPTIMIZE_INDEX in rebuild mode	Supported if you grant the privilege to create a trigger to the user (GRANT CREATE TRIGGER).	OPTIMIZE_INDEX

For details on Oracle Text, see Oracle Text Application Developer's Guide.